excel函数2

RAND() 随机数；0-1

RAND()*40 随机数0-40

RAND()*40+40 随机数40-80

SUBSTITUTE(C12,"set","get") 替换

IF(条件判断, 结果为真返回值, 结果为假返回值)

TEXT(value,"yyyy-mm-dd")