hmm, not sure, reading tells me for IRR you have to have a negative but try
here for possible solutions
http://www.exceluser.com/solutions/irr.htm

http://exceltips.vitalnews.com/Pages..._Function.html

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"David" wrote:

John,

Normally I'd agree but I work for a University and it's never that simple!

The plan is expected to produce more students, therefore more cash, before
the new building is complete. Hence the positive figure in year 0.

Any way around this?

"John Bundy" wrote:

Correct me if i'm wrong but it is suppsed to always be negative right? If
that is the case and you are just wanting positives to turn to negatives
throw this in =IF(A10,A1*-1,A1)

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"David" wrote:

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