Module 16 : IF Formula

16.1 IF Formula The IF function allows you to make logical comparisons between an actual value in a worksheet, and what you expect. The result of the comparison can be TRUE or FALSE. The function can carry out different actions depending on whether something is true or false. It looks something like this: =IF(Something is TRUE, then do something, if not do something else) The IF function can be used to evaluate text and values, and it can be used to evaluate errors. One example of when you...