We want to display the word “Overdue” if the date in column B is in the past. In this third example, we use the IF function to track a list of due dates.
And running different formulas dependent upon the values of other cells is a very powerful skill to have. What’s important is that you can use any formula in the value_if_true or value_if_false sections. The B2*90% part of the formula is a way that you can subtract 10% from the value in cell B2. In this example, we want to give a 10% discount if the customer spends a certain amount of money.
