20170218

If Function with Example

IF function is one of the most valuable functions in Excel. you can make logical comparisons.

IF(Something is True, then do something, otherwise do something else)

IF Examples :- 

If value is Equals to "RAM" Then return "OK" otherwise return "Not Ok"
=IF(A1="RAM","OK","Not Ok")

If value is Grater then to 5 Then return "OK" otherwise return "Not Ok"

=IF(A4>5,"OK","Not Ok")

If F1 is grater then 3 then (F1*2) cell value is multiple 2 and the condition of first condition false result is 0

=IF(F1>3,F1*2,0)






No comments:

Post a Comment