XL: ????? ???? MOD() # NUM! ???? ???

???? ???????: 119083 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
?????? ??? ????? Microsoft Excel ??? ?? Microsoft Excel 98 ?? ??? ???????? ???? 119083
(http://support.microsoft.com/kb/119083/EN-US/ )
.
????? ???? | ?? ????

???????

?? ???? ?????? MOD() ?? Microsoft Excel ??? # NUM! ???? ????? ????? ?? ???? ???? (???????).
???? ??? ?????? | ????? ???????

?????

???? ?????? MOD() # NUM! ??? ??? ??? ????? ?????? ??????:
(?????? * 134217728) ??? ?? ?? ????? ' ??? '
???? ??? ?????? | ????? ???????

???? ??????

??? ??? ????? ????? ?????? ???? ?????? MOD() ??? # NUM! ???, ????? ??????? ?????? ??????? ????? ?????? (???????) ?? ?????:
= ???-(INT(number/divisor) * ??????? ????)
??? ???? ??????? ????? ?? ??????? ??? ??????
=mod(j13,k13)
???????? ??? ??????:
=j13-(int(j13/k13)*k13)
???? ??? ?????? | ????? ???????

??????? ????

?? Microsoft Excel, ???? ?????? MOD() ?????? (???????) ???? ??? ???? ???. ???? ???? MOD() ?????????: 
   Argument   Definition
   --------------------------------------
   Number     The number being divided
   Divisor    The number being divided by
??? ???? ???? ?????? (???????) ?? 22 ???? 5 ????? ??????? ?????? ???????:
=mod(22,5)
???? ??????? 2 (22 ???? 5 ???? ???? ?? 2).

??? ???? ??????? ??????? ???? ??? 134,217,728 (?? 2 ?????? ??? ?? 27th) ? ??? ?? ?? ????? ??????? ??????? ? ???? ?????? MOD() ??? # NUM! ???? ???.
???? ??? ?????? | ????? ???????

???????

???? ???????: 119083 - ????? ??? ??????: 29/?? ?????/1427 - ??????: 2.1
????? ???
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 97 Standard Edition
????? ??????: 
kbmt kbprb KB119083 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????119083
(http://support.microsoft.com/kb/119083/en-us/ )
???? ??? ?????? | ????? ???????

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

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