Skip to main content


9.99999999999999E+307 is the biggest number that Excel can handle (just under 1 with 308 zeros behind it).

9.99999999999999E+307 is used in formulas to find the largest value that is less than or equal to the search value. Because 9.99999999999999E+307 is an impossibly large value, the formula finds the previous numeric value.

9.99999999999999E+307 is often used with LOOKUP, MATCH, VLOOKUP or HLOOKUP function. For example:

Find the position of the largest value

The values in the lookup_array argument must be placed in ascending order.




Find the largest value


Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>