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

?????? ????????? ?????? ?????????
???? ???????: 119083 - ??? ???????? ???? ????? ????? ??? ???????.
?????? ??? ????? Microsoft Excel ??? ?? Microsoft Excel 98 ?? ??? ???????? ???? 119083.
????? ???? | ?? ????

???????

?? ???? ?????? 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

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

 

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