Number Format?

Jim · Mar 4, 2009

Hi,I am getting the following number when I use the function xirr. What
does it mean?2.98023E-09

Thanks, Jim

Ron Rosenfeld · Mar 4, 2009

Hi,I am getting the following number when I use the function xirr. What
does it mean?2.98023E-09

Thanks, Jim

These days it might be a good investment :-)

(You're not losing any money). It
is a close approximation of zero.
--ron

Bob Phillips · Mar 4, 2009

It means it is a very small number, 0.00000000298023

MartinW · Mar 5, 2009

Hi Jim,

That is scientific notation.
See this wiki site for an explanation.
http://en.wikipedia.org/wiki/Scientific_notation

HTH
Martin