Match function

F

fzl2007

What is the difference between these two,

=MATCH(1E+300,A:A)
vs
=MATCH(9.999999E+307,A:A)

Thanks
 
J

joeu2004

fzl2007 said:
What is the difference between these two,
=MATCH(1E+300,A:A)
vs
=MATCH(9.999999E+307,A:A)
Click to expand...

Probably nothing.

Both are likely to find to find the last number in column A, since you
probably do not use such large numbers yourself.

It is true that 9.999999E+307 is closer to the largest number that Excel
allows us to enter. Actually, it is 9.99999999999999E+307.

(The largest computable number is about 1.79769313486232E+308; exactly
(2^1023-2^970)*2.

But 1E+300 is easier to remember, IMHO. It is also fewer characters to
enter; we actually type just 1E300.
 
D

Don Guillett

What is the difference between these two,

=MATCH(1E+300,A:A)
vs
=MATCH(9.999999E+307,A:A)

Thanks
Click to expand...

any number larger than the largest possible number in your range will
do
 
Top