Did you try the HELP function? for conditkonal IF,Then
A
15
9
8
Formula Description (Result)
=IF(A2=15, "OK", "Not OK") If the value in cell A2 equals 15, then return "OK". (OK)
=IF(AND(A2>A3, A2
=IF(OR(A2>A3, A2
The IF function uses the following arguments.
Formula with the IF function
logical_test: the condition you want to check
value_if_true: the value to return if the condition is true
value_if_false: the value to return if the condition is false
Function details
AND
OR
IF