作业帮=TRUNC(RAND()*1.5+C13*100,2)可以得到什么?
来源：学生作业帮助网 编辑：作业帮 时间：2024/04/29 16:52:31
=TRUNC(RAND()*1.5+C13*100,2)可以得到什么?
=TRUNC(RAND()*1.5+C13*100,2)可以得到什么?
=TRUNC(RAND()*1.5+C13*100,2)可以得到什么?
rand()会产生一个0到1之间的随机数,然后这个数乘以1.5加上C13乘以100的和,trunc命令是取整命令,形式有两种trunc(a)为对a数字取整,trunc(a,b)为对数字a取b位小数,TRUNC(RAND()*1.5+C13*100,2)即为对RAND()*1.5+C13*100求的数取2位小数
=TRUNC(RAND()*1.5+C13*100,2)可以得到什么?
=TEXT(((748+TRUNC(RAND()*10))*10+IF(RAND()>0.5,5,0))/1000,0.000)解释
=TEXT(((748+TRUNC(RAND()*10))*10+IF(RAND()>0.5,5,0))/1000,0.000)解释每段语句的意识
TRUNC
TRUNC
=IF(RAND()
=IF(RAND()
=ROUND(RAND()*1.5+91.5,1)能实现什么,
第一个公式：=TEXT(TRUNC(DEGREES(E6)),000)&'&TEXT(TRUNC((DEGREES(E6)-TRUNC(DEGREES(E6)))*60),00)&'&TEXT(((DEGREES(E6)-TRUNC(DEGREES(E6)))*60-TRUNC((DEGREES(E6)-TRUNC(DEGREES(E6)))*60))*60,00.00)第二个公式：=(TRUNC(B6)/180*PI())+V
请问rand()%100=rand(0,100)吗
w:=trunc(sqrt(I));是什么意思求答案
trunc是什么意思?
Oracle的Trunc函数请教select trunc(5.75),trunc(5.75,1),trunc(5.75,-1) from dualtrunc(x [,y]),其中如果没有指定y,则对x在0位小数进行截断,例如：TRUNC(5.75)=5,如果y是负数,则对x在小数点左边的第|y|位处进行截断,
关于EXECL保留小数点写了一个公式“=IF(A1>1,IF(A1>10,ROUND(A1,1)-IF(AND(ROUND(A1,1)> A1,TRUNC(A1*20)= A1*20,TRUNC(A1*10)/2=TRUNC(A1*10/2)),0.1),ROUND(A1,2)-IF(AND(ROUND(A1,2)> A1,TRUNC(A1*200)= A1*200,TRUNC(A1*100)/2=TRUNC(A1*100/2)),0.01
EXCEL问题 =IF(C2=,,RAND()),
=ROUND(950+78*RAND(),1) excel
=(round(rand()*50+60,1)是什么意思?
=round((10^rand()*5),0