The IF() function allows you to check a (boolean) condition, then if the condition is TRUE use one formula, or if the condition is FALSE, use another formula.