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

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

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