1.取整文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
=INT(数字)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
2.求余数文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
=MOD(除数,被除数)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
3.四舍五入文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
=ROUND(数字,保留小数位数)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
4.取绝对值文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
=ABS(数字)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
5.算术平方根文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
=SQRT(数字)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
6.产生随机数文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
=RAND()文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
7.返回一个介于指定的数字之间的随机数文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html
=RANDBETWEEN(数字,数字)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/office/33167.html