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

???? ?????? ???? ??????
???? ID: 119083 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
???? Microsoft Excel 2001 ?? Microsoft Excel 98 ??????? ?? ??? ?? ???? ??, ?????119083.
??? ?? ??????? ???? | ??? ?? ??????? ????

?????

Microsoft Excel ??? MOD() ?????? ??? #NUM ?? ???? ?? ???? ??! ?????? ??? ????? ??? (modulus) ?? ????? ?? ???

????

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

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

??? ??????? ????????? ???? ??, ?? MOD() ?????? ?? ?? #NUM ???? ??! ??????, ????? ?? ???? ??? ????? ????? ??? (modulus) ?? ?? ???????? ?? ?????? ???? ?? ???:
=??????-(INT (??????/????)*????)
?????? ?? ???, ?? ???? ?? ????? ?? ????? ????
=MOD(J13,K13)
?? ????? ?? ????? ????:
=J13-(INT(J13/K13)*K13)

???? ???????

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

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

???

???? ID: 119083 - ????? ???????: 19 ??????? 2011 - ??????: 6.0
???? ???? ???? ??:
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 97 Standard Edition
??????: 
kbprb kbmt KB119083 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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