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