IRR Calculation question

[Les]

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.

 

[ryan]

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]

Thanks Ryan.
--
Les

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.