Dear,

First of all thank you for your response.

I also occur the same. That is to say upto 1% it worked well.

But below that........????

any help?

TT

wrote in message
oups.com...
No News wrote:
I am having the values in cells a1 to a23 . 1000 in each cell
In the a24 cell the value entered was 24000
Now I want to have the INTERNAL RATE OF RETURN in the cell a25
I put the formula as =IRR(a1:a24)
Now I have the following error.
"The formula or function used is dividing by zero or empty cell"

You need to show direction of cash flows by using the sign of the
number. The choice of negative and positive is arbitrary. Most people
use "-" to represent outflows (1000?) and "+" or no sign to represent
inflows (24000?).

But that alone will not solve your problem. When I use -1000 and
24000, I still get #DIV/0. The problem is: you need a "guess"
parameter for this cash flow. The default guess is 10%. I found that
1% works well.