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