IF Function

IF function

Use the IF function to return one value if a condition is true and another value if it’s false.
Syntax

IF(logical_test, value_if_true, [value_if_false])

example:

=IF(A2>B2,“Over Budget”,“OK”)
=IF(A4=500,B4-A4,“”)

WORKBOOKS