Learn how to calculate payback and discounted payback in Excel with formulas, SCAN, XMATCH, LET, and SWITCH, plus partial-year and error handling ...