Howard,

Under the topic "Excel specifications and limits" in the Excel Help, we
read:

Largest number allowed to be typed into a cell 9.99999999999999E+307

That's a known constant. We can define, say, BigNumber, as referring to
this constant and use it in the relevant formulas. Theoretically, it's
the less probable number to occur in the ranges of interest. Having it
as such would also minimize questions emamating from variations.

Aladin

L. Howard Kittle wrote:
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