Hi!
Good question.
Here's a bone of contention I have when I see these types
of formulas.
Say for example that you know for certain that the
absolute largest number that could possibly in your range
is 100. It's not possible for a value greater than 100 to
be in your range of values. So, why use this formula:
=LOOKUP(9.99999999999999+307,A:A)
when this formula will do:
=LOOKUP(101,A:A)
or even this:
=LOOKUP(MAX(A:A)+1,A:A)
When the average user see's that number,
9.99999999999999+307, they freak out!
And yes, I know why *some* use that large a number!
Biff
-----Original 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
.
|