Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Incorrect Result Raising 10 to Very Large/Very Small Power

XL2000: Incorrect Result Raising 10 to Very Large/Very Small Power

View products that this article applies to.

Symptoms

In Microsoft Excel 2000, if you type a formula in which the value of 10 is raised to a very large power or a very small power, the formula may return an incorrect result: 
   10 Raised to       Expected Result   Actual Result
   -------------------------------------------------------------------

   very large power   #NUM! error       0, 0.1

   very small power   0                 #DIV/0! error, 10^<some value>
NOTE: These problems do not occur in earlier versions of Microsoft Excel. Also, the problem does not occur when you raise a value other than 10 to a very large power or a very small power; for example: =9^2345678901 correctly returns a #NUM! error.

↑ Back to the top

Cause

These problems occur when you type a formula in which the value of 10 is raised to a power in one of the following ranges:
  • Greater than or equal to 2^31 (2,147,483,648).
    -and-
  • Less than or equal to 10^308 (1 followed by 308 zeros).
-or-
  • Less than or equal to -(2^31) (-2,147,483,648).
    -and-
  • Greater than or equal to -(10^308) (-1 followed by 308 zeroes).

For example: 
   Formula you type          Value returned
   ----------------------------------------

   =10^2147483648            0
This formula should return a #NUM! error, because the largest positive number allowed in Microsoft Excel is 9.99999999999999E+307, which is just less than 10^308.

Or: 
   Formula you type          Value returned
   ----------------------------------------

   =10^-2147483648           #DIV/0!
   =10^-4294966989           1E+307
These formulas should all return the value 0, because the smallest positive number allowed in Microsoft Excel is 9.99999999999999E-307, which is just higher than 0 (zero).

↑ Back to the top

Workaround

To prevent this problem from occurring, make sure that formulas in your workbooks do not raise the value of 10 to a power larger than 308 or smaller than -308.

↑ Back to the top

More information

Microsoft Excel supports positive values almost as large as 10^308 (a one followed by 308 zeros) and almost as small as 10^-308 (a decimal point, followed by 308 zeroes and a one). Similar negative values are also supported. Smaller values are rounded to 0 (zero), and larger values are converted into a #NUM! error value.

↑ Back to the top

Article Info
Article ID : 214373
Revision : 3
Created on : 1/1/0001
Published on : 1/1/0001
Exists online : False
Views : 215