IRR Calculation question
Hi all,
I am doing the calculation below and it works great, with the exception that if the value i get out is too high it goes to "#NUM!". is there a way to prevent this and put a text in "Value to High" ?? =IF(premises!F12="no",IRR('NPV calculation'!E121:L121),IRR(F122:L122)) Any help would be greatly appreciated. -- Les |
IRR Calculation question
just enclose what you already have inside another if statement, like so:
=if(iserror(<your_formula),"Value is too high",<your_formula) long and cumbersome, i know, but the simplest answer to your question. "Les" wrote: Hi all, I am doing the calculation below and it works great, with the exception that if the value i get out is too high it goes to "#NUM!". is there a way to prevent this and put a text in "Value to High" ?? =IF(premises!F12="no",IRR('NPV calculation'!E121:L121),IRR(F122:L122)) Any help would be greatly appreciated. -- Les |
IRR Calculation question
Thanks Ryan.
-- Les "ryan" wrote: just enclose what you already have inside another if statement, like so: =if(iserror(<your_formula),"Value is too high",<your_formula) long and cumbersome, i know, but the simplest answer to your question. "Les" wrote: Hi all, I am doing the calculation below and it works great, with the exception that if the value i get out is too high it goes to "#NUM!". is there a way to prevent this and put a text in "Value to High" ?? =IF(premises!F12="no",IRR('NPV calculation'!E121:L121),IRR(F122:L122)) Any help would be greatly appreciated. -- Les |
All times are GMT +1. The time now is 05:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com