This download accompanies our Excel 2016 and 2019 cheat sheet. See that article for detailed information on how to get the most out of Excel 2016 and Excel 2019 for Windows.

Excel and Google Sheets have IRR functions programmed to run 20 iterations to find a value that is accurate to within 0.00001%. 6 7 If the program can’t find one, then it returns "#NUM" in the cell.