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(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