But if the date is in the future, calculate the number of days until the due date. 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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |