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
|