MIRR
MIRR helps you calculate the modified internal rate of return for cash flows. It provides the tools you need to enter the function accurately and review its syntax, making your work more efficient and helping you accomplish tasks with ease. With MIRR, you can insert the function through the function dialog, type =MIRR(...) directly in a cell or the formula bar, view the syntax MIRR(values, finance_rate, reinvest_rate), and open detailed help for the function. You can also troubleshoot #VALUE! errors by checking data types and cleaning text or spaces, verify unexpected results by checking ranges and numeric formats, and apply the formula across multiple cells with fill or copy and paste while managing relative and absolute references. Choose the documentation below that best matches your needs to learn more.