Tests to see whether the first formula provided is true or false. If the formula is true, then the second formula is calculated and returned. Otherwise, the third formula is calculated and returned.

IF(FormulaTest, FormulaTrue, FormulaFalse)

FormulaTest: formula that is either True or False (2>1 for example).

FormulaTrue: formula whose result is calculated if the test formula is True.

FormulaFalse: formula whose result is calculated if the test formula is False.

IF(10 > 20, 1, 2) equals 2