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