Best Microsoft Excel Bloggers

Thursday, April 4, 2019

Tired of Nesting IF after IF?
Get off the Nest and use IFS()

IFS()  is a Logical Function that can be found in Excel 2019 and Office 365.
This function allows you to test for up to 127 conditions and determine if they are true.
So, no more pulling out the magnifying glass to find your mismatched parentheses or mumbling the formulas to yourself as you go through trying to figure out where your error is.
IFS() makes it much easier although it is not perfect. Two things to be aware of. It only tests for TRUE conditions and displays a #N/A error if it finds a FALSE. Also, Excel stops as soon as it finds a TRUE condition so the order of your tests (conditions) can matter sometimes. Here is a quick video on the IFS() function.

BTW - If you are doing nested IFs that contain anywhere near 127 conditions, please read about INDEX MATCH and VLOOKUP because no one should be doing nested IFs to that degree. I need to get an aspirin, just thinking about it!

Ms. Excel- Resident Excel Geek