The Friday night I realized, "I can't even read my own IF formulas anymore." Let me start with the conclusion: if you are using nested IF functions to categorize sales data into ranks like S, A, B, or ...
Modern Excel functions like IFS, SWITCH, XLOOKUP, SUMIFS, and LET replace most nested IF use cases.
A boring setting with huge payoff.
There is a common mistake that people who have learned Power Query tend to make: trying to do everything with Power Query. Power Query is not a panacea. It is important to understand what it excels at ...