??? ??? ????? ????? ??????? ?? ???? ??????? ???????

???? ???????: 214118 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

???????

?? ???? ?? ?????? ?? ??????? ?? ???????? ???????? ??? ????? ??????? ??????? ?? Microsoft Excel ? Microsoft Works ????? ???? ??? ????? ?????? ????? ????? ????. ??? ???? ??????? ????????
=1*(.5-.4-.1)
??? ????? ??? ??????? (- 2.78E - 17) ? ??-0.0000000000000000278 ????? ?? 0.
???? ??? ?????? | ????? ???????

?????

??? ?????? ??? ????? ?? ?? ????? ?? Excel ?? Works; ???? ??? ?????? ???? ????? ???? ????????? ? ??????????? ????????????? (IEEE) 754 ??????? ??????? ??????? ????? ????? ?? ????? ?????.
???? ??? ?????? | ????? ???????

???? ??????

??????? ??????

?????? ??? ??????? inaccuracy ??????? ????? ?????? ??????? ?????? ?????? Round() ??????? ??? ??? ??????? ??????? ???? ??????? ?????? ????? ??. ??? ???? ??????? ??? ??? ???? ?? ?????? ???? ?? ??????? ?? ???? ?????? ??? ??????? ???????:

=round(1*(0.5-0.4-0.1),2)

??????? ???????

????? ??? ?????? ??????? ????? ?? ??????? ??? ????? ???????? ????? ??? ?? ????? ??????? ???? ????? ??????. ???? ??? ?????? ???? ?? ??? ?? ???? ????? ?? ????? ???? ??? ????? ?? ???? ?????.

?????? ???? ?? ???? ??????? ???? ????? ??? ???????? ??????? ?????? ???????? ?? ???? ???????? ??? ????? ????? ????? ?????. ?????? ??? ?????? ??? ??? ??? ??????? ?? percision ??????? ?????? ??? ???????.

???????? ???? ????? ??? ?? ????? ???? ??????? ???????:

Excel 2000 ?Excel 2002 ? Excel 2003
  1. ?? ??????? ?????? ???? ??? ??????.
  2. ??? ????? ??????? ???? ??? ?????? ?????? ???? ?????? ???? ???????? ????? ??? ?? ?????.
  3. ???? ??? ?????.
Excel 2007
  1. ???? ??? ?? Microsoft Office ? ?? ???? ??? Excel ??????, ?? ???? ??? ????? ?????? ??????.
  2. ?? ?????? ??? ???? ??? ?????? ??? ?????? ???? ?????? ?? ???? ??? ???? ???????? ????? ????? ??? ???????? ?? ???? ??? ?????.
??? ??????? ???? ????? ??? ?? ????? ??? ????? ????? ?????? ?? ???????? ????? ??? ????.

?????? ????? ????? ???? ??? ???? ??????? ???????:
  1. ???? ??? ?????? ?????? ??? ??????? ???? ???? ??????? ?? ???? ??? ????? ?????.
  2. ??? ????? ??????? ??? ??? ???, ???? ??? ???.
  3. ?? ?????? ??????? ??????? ??? ????? (??? ??????? ???????) ???? ??????.
  4. ???? ??? ?????.
Excel 2010
  1. ???? ??? ????? ??????? "???" ? ???? ??? Excel ??????, ?? ???? ??? ????? ?????? ??????.
  2. ?? ?????? ??? ???? ??? ?????? ??? ?????? ???? ?????? ?? ???? ??? ???? ???????? ????? ????? ??? ???????? ?? ???? ??? ?????.
??? ??????? ???? ????? ??? ?? ????? ??? ????? ????? ?????? ?? ???????? ????? ??? ????.

?????? ????? ????? ???? ??? ???? ??????? ???????:
  1. ???? ??? ?????? ?????? ??? ??????? ???? ???? ??????? ?? ???? ??? ????? ?????.
  2. ??? ????? ??????? ??? ??? ???, ???? ??? ???.
  3. ?? ?????? ??????? ??????? ??? ????? (??? ??????? ???????) ???? ??????.
  4. ???? ??? ?????.
???? ??? ?????? | ????? ???????

??????? ????

754 IEEE ??????? ?? ????? ?????? ????? ??????? ??????? ?? ????? ????? ??? ??????? ????. ??? ??????? ??? ??????? ?? ??? Intel coprocessors ???????? ???? ???????? ??? ????????? ???? ???? ?????? ??????? ??????? ?? ?????????.

????? IEEE 754 ????? ????? ?? ????? ????? ????? ??????? ????? ??????? ??????? ???????? ????? ????????? ???????? ?? ???? ????????? ??????? ??? ?????? ???????? ???? ???? ??????. ??? ???? ??? ??? ??????? ???? ???? ????? ??? ????? ??????? ??????? ??? ????? ??? ????? ??????? ???????? ???? ?? ???? ????? ???? ??????.

????? ??? ???? ??????? ???? ????? 1/10 ?? ???? ??????? ???? ?? ???? ????:
.1
??? ???? ???? ??? ????? ?? ????? ????? ????? ???? ??????:
.0001100011000111000111 (?????)
?? ???? ????? ??? ????? ?? ????? ??????? ????. ?????? ??? ??? ??? ????? ????? ?????? ??????? - 2.78E - 17 ??? ???????.

??? ??? ??? ????? ???????? ???????? ?????? ?????? ??? ????? ?????, ?? ???????? ??? ??????? ???????.
???? ??? ?????? | ????? ???????

?????

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
78113
(http://support.microsoft.com/kb/78113/ )
???? ??????? ??????? ?? ???? ????? ??? ?????

Excel 2007 ??? Excel 2010

????? ?? ????????? ??? ????? ????? ??? ????????, ???? ??? ??????? Microsoft Office Excel ??? ???? ??????? ???? ??????? ????? ?????? ??? ???? ????? ?? ??????? Excel ?? ???? ??? ??? ???? ???????.

Excel 2002 ? Excel 2003

????? ?? ????????? ??? ????? ??? ?????? ???? ??? ??????? Microsoft Excel ?? ??????? ??????? ? ???? ??????? ????? ?????? ??? ???? ????? ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????.

Excel 2000

????? ?? ????????? ??? ????? ??? ?????? ???? ??? ??????? Microsoft Excel ?? ??????? ??????? ? ???? ????? ??????? ???? ???? Microsoft Excel ????? ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????.
???? ??? ?????? | ????? ???????

???????

???? ???????: 214118 - ????? ??? ??????: 29/????? ??????/1431 - ??????: 8.0
????? ???
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Office Excel 2003
  • Microsoft Office Excel 2007
  • Microsoft Excel 2010
????? ??????: 
kbmt kbprb KB214118 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????214118
(http://support.microsoft.com/kb/214118/en-us/ )
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????