MOD函数返回数字除以除数后的余数。输出与除数的符号相同。
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 |
MOD函数可以用INT函数表示-
MOD(n,d)= n-d * INT(n/d)
如果除数为0,则MOD返回#DIV/0!错误值
Excel 2007,Excel 2010,Excel 2013,Excel 2016
祝学习愉快!(内容编辑有误?请选中要编辑内容 -> 右键 -> 修改 -> 提交!)