ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Scenario manager and IRR (https://www.excelbanter.com/excel-worksheet-functions/71706-scenario-manager-irr.html)

PeterW

Scenario manager and IRR
 

Hi All

Does anybody know why the IRR formula doesn't appear to calculate when
it is one of the output fields under the Scenario Manager Pivot Table
option? (it incorrectly results in the number "1" under all scenarios)

Thanks in advance

Peter


--
PeterW
------------------------------------------------------------------------
PeterW's Profile: http://www.excelforum.com/member.php...fo&userid=6496
View this thread: http://www.excelforum.com/showthread...hreadid=512491



All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com