Excel Stuff: Nested IF, AND, OR, NOT, Conditional formulas

The following video gives a pretty good overview of AND and OR, and reviews IF statements:



The NOT function is not discussed in this video, but the concept is that NOT(argument) merely reverses whatever the value of the argument. For example, switches a TRUE to FALSE, and vice versa. Sometimes comes in handy when constructing an IF statement.

Here is a pretty clear example of a nested IF statement. However, please note that whenever you have a scheme, like grading, with more than 3 outcomes, using a VLOOKUP is much better. Simply because embedding all the outcomes is time consuming and would be better as an assumption table.



This final video demonstrates conditional formulas: