Match function

[fzl2007]

What is the difference between these two,

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

Thanks

 

[Gord Dibben]

The first one has fewer typing strokes.


Gord

 

[joeu2004]

What is the difference between these two,
=MATCH(1E+300,A:A)
vs
=MATCH(9.999999E+307,A:A)

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.

 

[Don Guillett]

What is the difference between these two,

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

Thanks

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