Forum Discussion

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Feb 25, 2017

Biggest Number in Excel

Can someone tell us what is the biggest number in Excel? I have read some articles about this topic, some people say that this number is the biggest: 9.99999999999999E+307
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 25, 2017

Hi Haytham,

 

The answer is in this support page https://support.microsoft.com/en-us/help/78113/floating-point-arithmetic-may-give-inaccurate-results-in-excel

 

All computers have a maximum and a minimum number that can be handled. Because the number of bits of memory in which the number is stored is finite, it follows that the maximum or minimum number that can be stored is also finite. For Excel, the maximum number that can be stored is 1.79769313486232E+308 and the minimum positive number that can be stored is 2.2250738585072E-308.

  • UGA_Head_EE's avatar
    UGA_Head_EE
    Copper Contributor
    Aug 10, 2023

    Thanks, Sergei.

     I was trying to create a spreadsheet to calculate the ‘Birthday Paradox’, but kept getting the ‘#NUM!’ error, which has a factorial of 365 in it that put it over the limit. It wasn’t until I read your post when I found out why.

    SergeiBaklan

  • Perry960's avatar
    Perry960
    Copper Contributor
    Mar 14, 2022

    @Surge

    excel is 0ne million

     

Resources