When you only need two outcomes, the IF function is fine. But the moment you start stacking conditions (if this, then that, otherwise if this, then that), you’re building a house of cards. At first, ...
Often when you’re working with Excel you will use a calculation that is not available as a built-in Excel function. If you make this calculation repeatedly, you can save having to write the ...