詳情鏈接地址： https://www.xiaobuteach.com/excelfunc/number/outline.html?from=bilibili??

Excel數(shù)值函數(shù) 大綱

abs 絕對(duì)值

mod 求余

power 求冪

int 向下取整

trunc 截尾取整

round 四舍五入取整

floor 向下舍入到倍數(shù)

rand 隨機(jī)數(shù)

randbetween 范圍隨機(jī)整數(shù)