描述
数字除以除数后,ABS函数将返回余数。输出与除数的符号相同。
语法
MOD (number, divisor)
争论
| Argument | 描述 | Required/Optional |
|---|---|---|
| Number | The number for which you want to find the remainder. | Required |
| Divisor | The number by which you want to divide number. | Required |
Notes
如果除数为0,则MOD返回#DIV/0!错误值。
-
MOD函数可以用INT函数表示-
MOD (n, d)=n - d * INT (n/d)
适用性
Excel 2007,Excel 2010,Excel 2013,Excel 2016
Example
