Hi - Dave here.
Happy Friday!
The IF function is one of the most popular functions in Excel. Easy to use and flexible, IF can be used to solve all kinds of problems.
Yet many Excel users don't know you can use
other functions and formulas directly
inside of IF. You can use formulas for the logical test, for the TRUE result, or for the FALSE result, in any combination.
In addition, you can use the NOT function to
reverse the behavior of IF. You can see an example of this in the worksheet below, where the IF function is used to mark records where the color is NOT Red or Green:
[
Download the workbook and read the full explanation]
The article above explains this formula in more detail and provides links to related formulas and videos. Click the link to download the workbook and give it a try yourself.
Excel formulas
The best way to learn Excel formulas is to
practice.
We maintain a list of over 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a nice weekend!
Dave
