Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1,560

IRR & #DIV0!

HI,

I've got a series of numbers in a row from which I need to know the IRR.

Because the first number is positive the function is returning the #DIV0
error.

Can anyone tell me how to get round this?

Thanks

David

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
I WANT TO HIDE THIS #DIV0!	HERNAN	Excel Discussion (Misc queries)	9	July 26th 06 07:28 PM
#DIV0/! issues	Brento	Excel Discussion (Misc queries)	2	February 2nd 06 07:52 AM
Excel - IF Formula and #DIV0!	Newsgal	Excel Worksheet Functions	2	May 25th 05 01:05 PM

All times are GMT +1. The time now is 11:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us