描述
数字除以除数后,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
参考链接
https://www.learnfk.com/javascript/advanced-excel-math-trignometric-abs-function.html
标签：Required,函数,JavaScript,Excel,无涯,number,ABS,除数,MOD From： https://blog.51cto.com/u_14033984/7493972