Adding the TRIMRANGE function to the calculation tells Excel to discount any blank cells ... Excel to trim the blanks at the ...
You can solve for the discount rate in Excel in two ways: Find the IRR in Excel by employing the IRR function, then use it as the discount rate that causes NPV to equal zero. Use What-If analysis ...
You can solve for the discount rate in Excel in two ways: Find the IRR in Excel by employing the IRR function, then use it as the discount rate that causes NPV to equal zero. Use What-If analysis ...