Excel tips: if
These videos come from our Excel video training.
In this video we look at how to combine the IF function with the OR and AND functions to test more than one condition at the same time.
The IF function is very versatile. You can use it whenever you need to test a condition and take an action based on the result. You can even combine multiple IF statements to check multiple...
In this video, we look at a way to fill in missing data when the structure is not consistent, using formula created with IF and ISBLANK functions.
In this video, we look at a few reasons why VLOOKUP is a better option than nested IF statements, when you need to assign a commission rate (or a grade) based on an arbitrary value.
By their nature, nested IF formulas are hard to read. In this video, we show you how to easily make a nested IF formula more readable, by adding line breaks.
In this short video, we look at how to replace a typical nested IF formula with a VLOOKUP formula. Compared to nested IF statements, VLOOKUP is simpler and more transparent.You can change...