Why do I get a result that looks like this? 298023E-09

J

Jim

I am using the xirr function and I get a result of 298023E-09. Why and what
does it mean?
Thanks, Jim
 
P

PJFry

It represents the number .00000000298023. Set your format to Number with
decimals out to 15.

PJ
 
M

Mike H

Jim,

It's a very large number and probably being generated because you gave xirr
incorrect data. Post your formula and data

Mike
 
A

Alojz

Hi, Mike.

Actually, it's slightly smaller than very large number, as far as value very
close to zero is not large :)
 
A

Alojz

One more remark: previous suggestion works only when changing source data,
not when adding new data which then have to be pivoted. To pivot new adds u
have to go back to pivot wizard and expand the source area (clicking on back
button in wizard).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XIRR 1
XIRR Help 0
XIRR 3
How to write XIRR formula on excel using different Year basis than 365. 5
Number Format? 3
xirr function 1
Sumproduct with added days 2
sumproduct with additions to data 1

Top