????? ??? ????? ??? ?? ??? ???? ????/???? ?????? ?????

?????? ????????? ?????? ?????????
???? ???????: 172911 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

???????

?? ??????? Microsoft Excel ???????? ?? ????? ??? ??????? ??? ??? ?????? ???? ?? ???? ??? ??? ?????? 10 ??? ?? ???? ???? ?? ???? ????? ???? ?????? ?? ?????? ????? ??? ?????:
   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>
??????: ?? ???? ??? ???????? ?? ????????? ??????? ?? Microsoft Excel. ?????? ???????? ?? ???? ??? ??? ???? ??? 10 ???? ????? ???? ?? ????? ???? ????; ??? ???? ??????? = 9 ^ ????? 10000000000 ???? ???? ??? # NUM! ???.

?????

???? ??? ???????? ??? ????? ???? ?????? 10 ??? ??? ??? ?? ?? ??? ???????? ???????:

  • ???? ?? ?? ????? 2 ^ 31 (2,147,483,648) ???? ?? ?? ????? 10 ^ 308 (1 ??????? ????? 308) - ?? -

  • ??? ?? ?? ?????-(2^31) (-2,147,483,648) ????? ?? ?? ?????-(10^308) (-1 ??????? ????? 308)
??? ???? ??????:
   Formula you type          Value returned
   ----------------------------------------

   =10^2147483648            0
   =10^10000000000           0.1
   =10^(10^308)              0.1
				
??? ??? ?? ???? ???? ????? ??? ????? # NUM! ?????? ???? ???? ??? ???? ????? ?? ?? Microsoft Excel ?? 9.99999999999999E + 307 ??? ??? ??? ?? 10 ^ 308. ??:
   Formula you type          Value returned
   ----------------------------------------
   =10^-2147483648           #DIV/0!
   =10^-4294966989           1E+307
   =10^-4294967295           10
   =10^-(10^308)             10
				
??? ????? ??? ?? ???? ?????? ?????? 0, ??? ???? ??? ???? ????? ?? ?? Microsoft Excel 1E-307 ??? ?????? ??? 0.

???? ??????

???? ???? ??? ??????? ???? ?? ?? ????? ?? ???????? ??? ??? ????? 1.797 ??? ???? ?? 308 ?? ??? ???? ??-308 2.225.

?????

???? Microsoft ??? ???? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????.

??????? ????

????? Microsoft Excel ??? ????? ??????? ????? ???? 10 ^ 308 (???? ??????? ????? 308) ? ??????? ????? ???? 10 ^-308 (?????? ??????? ????? 308 ????). ??? ????? ?????? ?????? ????? ???????. ??? ????? ????? ???? ??? 0 ? ??? ????? ????? ???? ?? # NUM! ???? ???.

????????? ???? ?? ??? ?????? particles ?????????? ?? universe ???????? ?? 10 ^ 80 ?? ???? ??????? ????? 80. ???? ???? ????????? ?? physics ?? ????? 10 ^ ???????-33 ? ????? ??????? ?????? ???? ????? ????. ???? ??? ????? ???? ??? ??? ?????? ???????? ?? ??? Microsoft Excel; ???? ???? ????? Microsoft Excel ?? ?? ??? ??? ???? ?? universe.

?? ??????? ??? ?????? ???? ?????? ?????: ???? ??? googol 10 ^ 100 ?? 1 ??????? ????? 100 ? googolplex ?? 10 ^ googol ?? 1 ??????? 10 ^ ????? 100.

??????? ??????? ?????? ?????? ????? = 10^(1E+308) ?? ?? 1 ??????? 10 ^ ????? 308. ???? ????? ?????? ?????? ?????? ???????:
googolplex*googolplex*googolplex*(10^(10^8))
????? ?? ?????? (1 ??????? 10 ^ ????? ???) universes ????? ??? (1 ??????? 10 ^ ????? 308) particles ??????????.

???????

???? ???????: 172911 - ????? ??? ??????: 22/???? ?????/1435 - ??????: 1.1
????? ???
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 98 ?? Macintosh
????? ??????: 
kbnosurvey kbarchive kbmt kbbug kbpending KB172911 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????172911

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com