IF function. The IF function allows you to apply a condition to your data whereby one result is returned if your condition is TRUE and another result if the condition is FALSE.IF functions can be ...

Nested IF Statement . If you want to test multiple conditions simultaneously, you can place IF statements inside another. ... As with any function in Excel, you can combine these functions.

Using Excel as a scheduling tool is a great skill to have under your belt. Learn how to use SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions.