MOD命令请教

lwlp

MOD命令有些不明白 <table cellspacing="0" cellpadding="0" width="269" border="0" xstr="" style="WIDTH: 202pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="98" style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3136;"></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col><col width="99" style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3168;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="98" height="19" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; WIDTH: 74pt; BORDER-BOTTOM: #76ace4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">=MOD(5,4)</font></td><td align="right" width="72" xfmla="=MOD(5,4)" xnum="" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; WIDTH: 54pt; BORDER-BOTTOM: #76ace4; BACKGROUND-COLOR: transparent;"><font face="宋体">1</font></td><td width="99" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; WIDTH: 74pt; BORDER-BOTTOM: #76ace4; BACKGROUND-COLOR: transparent;"><font face="宋体">&nbsp;&nbsp; 5/4的余数</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; BORDER-BOTTOM: #76ace4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">=MOD(-5,4)</font></td><td align="right" xfmla="=MOD(-5,4)" xnum="" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; BORDER-BOTTOM: #76ace4; BACKGROUND-COLOR: transparent;"><font face="宋体">3</font></td><td class="xl24" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; BORDER-BOTTOM: #76ace4; BACKGROUND-COLOR: transparent;"><font face="宋体">&nbsp; -5/4的余数</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; BORDER-BOTTOM: #76ace4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">=MOD(5,-4)</font></td><td align="right" xfmla="=MOD(5,-4)" xnum="" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; BORDER-BOTTOM: #76ace4; BACKGROUND-COLOR: transparent;"><font face="宋体">-3</font></td><td class="xl24" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; BORDER-BOTTOM: #76ace4; BACKGROUND-COLOR: transparent;"><font face="宋体">&nbsp; 5/-4的余数</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; BORDER-BOTTOM: #76ace4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">=MOD(-5,-4)</font></td><td align="right" xfmla="=MOD(-5,-4)" xnum="" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; BORDER-BOTTOM: #76ace4; BACKGROUND-COLOR: transparent;"><font face="宋体">-1 </font></td><td class="xl24" style="BORDER-RIGHT: #76ace4; BORDER-TOP: #76ace4; BORDER-LEFT: #76ace4; BORDER-BOTTOM: #76ace4; BACKGROUND-COLOR: transparent;"><font face="宋体">&nbsp;-5/-4的余数</font></td></tr></tbody></table>后面三个不明白，希望大家帮忙解释下

knifefox

<p>函数 MOD 可以借用函数 INT 来表示:</p><pre><code>MOD(n, d) = n - d*INT(n/d)</code>
</pre><pre></pre>

小笨蛋

<p>学习了!</p>

yingshan5

<p>好东西，我也学习了</p>

yingshan5

<p>好东西，我也学习了</p>

yingshan5

<p>好东西，我也学习了</p>

szyygb

路过，学习一下