Learn how to calculate payback and discounted payback in Excel with formulas, SCAN, XMATCH, LET, and SWITCH, plus partial-year and error handling ...
Write Excel formulas that are easy to understand and don't consume lots of memory.