What is the difference between these two,

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

Thanks

The first one has fewer typing strokes.


Gord


On Tue, 28 Feb 2012 07:08:23 -0800 (PST), fzl2007
wrote:

What is the difference between these two,

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

Thanks

"fzl2007" wrote:
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.

On Feb 28, 9:08*am, fzl2007 wrote:
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