Excel Tutorial - IF Function

IF Function - specify a condition and yields one value if the condition is true and another if the condition is false.

Arguments:
Logical test –is any value of expression that can be evaluated to TRUE or FALSE
Value if TRUE –is the value returned if the logical test is TRUE.
Value if FALSE –is the value returned if the logical test is FALSE.

Syntax:
=if(logical test,[value if true], [value if false])

example:

condition:
if A2 is less than B2?

result:
is TRUE