9.9999E+307+?

dennisli

Well-known Member
In Excel, 9.9999E+307 = ?
Thanks

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Seti

Well-known Member
In Excel help under Microsoft Excel Specifications,

Largest allowed positive number is 9.99999999999999E307

so if you are trying to find the largest value, it can not be any greater than 9.99999999999999E307.

DRJ

MrExcel MVP
That is a pretty big number. I mean a google is only 10^100 So this is a google * google * google. I don't think you would need a bigger number for anything. The total numbers of atoms in the universe is less than one google.

just_jon

Legend
Often a named value called BigNum. You can use it, for example, to determine the end of a numeric range of data as in the below example --
Book1
ABCD
11113
222
333
444
555
667
778
889
999
10456
11678
12
13999
14but
15not
16these
Sheet2

DRJ

MrExcel MVP
Or you could just use Max(A:A) to find the largest value

Or Match(Max(A:A),A:A)

MrExcel MVP
DRJ said:
Or you could just use Max(A:A) to find the largest value

Or Match(Max(A:A),A:A)

And you think that's the same thing as:

[1]

=MATCH(9.99999999999999E+307,A:A)

but it's not.

You can of course try:

[2]

=MATCH(MAX(A:A)+1,A:A)

However, [2] introduces an additional functional call, therefore it doesn't match the speed of [1].

Thank, body.

GorD

Well-known Member
Jon, I think your post being in numeric order as thrown a few folk. But I may be mistaken as I have only picked up this technique of you guys in the last 2 months.

My understanding which I believe you say is that the 9.9999.... will find the last numeric entry in a range, where as the max one will find the occurence of the largest value within the range. not the same.

Or have I got this wrong?

GorD

Well-known Member
Okay, I've checked the match formula and it seems to give the last numeric value as well. Teach me not to check it first.

Replies
11
Views
303
Replies
8
Views
66
Replies
3
Views
165
Replies
2
Views
205
Replies
4
Views
283

1,186,326
Messages
5,957,214
Members
438,293
Latest member
ginkycart

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back