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.
Most of us never question the IF function. It works, it's familiar, and there's a formula for everything if you're willing to nest enough of them together. But functioning and functioning well are two ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results