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