=TRUNC(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