【www.jmzhongda.cn--学生作文作业】
题目:
=C3+$F$2+IF(ROUND(RAND(),0),+$G$2,-$G$2)这个函数是什么意思
主要讲解下IF(ROUND(RAND(),0),+$G$2,-$G$2)条件函数
解答:
RAND()是随机函数,其值是0~1之间的任意值
ROUND(),是四舍五入函数
ROUND(RAND(),0)表示对RAND()进行四舍五入到整数位.
所以当RAND()<0.5时,ROUND(RAND(),0)=0
而当RAND()≥0.5时,ROUND(RAND(),0)=1
对于IF(ROUND(RAND(),0),+$G$2,-$G$2)
当ROUND(RAND(),0)=0,=$G$2
当ROUND(RAND(),0)=1,=-$G$2