Unfortunately, your question didn't get answered. I don't
know the answer as I'm not very knowledgable on
exponential notation but I just thought I'd raise a
related point of my own.

Here's another related question:

Is it exponential notation or scientific notation?

Biff

-----Original Message-----
Hi Folks,

Thanks for the good discussion. Always good information
in this forum. May
not always understand it fully, but you can count on
getting the full scoop!

Regards,
Howard

"L. Howard Kittle" wrote in
message
...
Hello Excel users and experts,

Is there any significant difference in these formulas
that return the last
value in the column.

=LOOKUP(9.99999999999999+307,A:A)
=LOOKUP(9.99999999999999E+307,A:A)
=LOOKUP(9.999+307,A:A)
=LOOKUP(9.999E+307,A:A)

Why use fourteen 9's past the decimal point, either
with or without the E
when three 9's with or without the E works just as well?

Thanks
Howard



.