Exceljet

Quick, clean, and to the point

Excel tips: if

These videos come from our Excel video training.
Tip: IF this OR that
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.
Run time: 3:02
Tip: How to use the IF function
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...
Run time: 3:08
Tip: How to quickly fill in missing data - part 2
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.
Run time: 2:56
Tip: Why VLOOKUP is better than nested IFs
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.
Run time: 2:58
Tip: How to make a nested IF formula easier to read
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.
Run time: 3:10
Tip: How to use VLOOKUP instead of nested IFs
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...
Run time: 3:57