How-To Geek on MSN
I stopped overusing IF in Excel—and my formulas instantly became cleaner and faster
Modern Excel functions like IFS, SWITCH, XLOOKUP, SUMIFS, and LET replace most nested IF use cases.
I know how to write Excel formulas, but I just don't need to. Memorizing argument order for XLOOKUP or counting parentheses in a nested IF has never been the interesting part of working with data.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results