Posted to microsoft.public.excel.programming

external usenet poster

Posts: 240

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IRR Calculation Question	Les	Excel Discussion (Misc queries)	3	March 6th 08 03:21 PM
VBA calculation question	momiage[_2_]	Excel Programming	1	September 10th 05 04:55 PM
Is there a way to...(calculation question)	Jambruins	Excel Discussion (Misc queries)	3	April 25th 05 02:04 PM
Calculation question	Bryan	Excel Discussion (Misc queries)	5	March 16th 05 04:24 PM
Calculation Question	Lynn Q	Excel Worksheet Functions	4	November 3rd 04 12:14 AM

All times are GMT +1. The time now is 08:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us