F fzl2007 Feb 28, 2012 #1 What is the difference between these two, =MATCH(1E+300,A:A) vs =MATCH(9.999999E+307,A:A) Thanks
J joeu2004 Feb 28, 2012 #3 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.
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 Feb 28, 2012 #4 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
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
