=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)解释 =TEXT(((748+TRUNC(RAND()*10))*10+IF(RAND()>0.5,5,0))/1000,0.000)解释每段语句的意识 第一个公式：=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 TRUNC TRUNC w:=trunc(sqrt(I));是什么意思求答案 =TRUNC(RAND()*1.5+C13*100,2)可以得到什么? 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|位处进行截断, style=text-decoration: =text(a1,aaaa) text led白光做到Ra=90 Ra是什么意思led白光做到Ra=90 Ra是指什么值? 关于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中“=INDIRECT(CONCATENATE(Sheet2!,ADDRESS((B6-TRUNC(B6))*100,(TRUNC(B6)-129)*3+2,4)))”这个公式什么意思,都有什么作用? Function fw(x,ra As Range) Dim r1 As Range For Each r1 In ra If r1.text = x And InStr(1,r1.Formula,=TT() > 0 Thenfw = fw & Split(Split(r1.Formula,()(1),,)(0) & ,End IfNext r1If fw = Then fw = 没有End Functio这个能做成输出地址 FOR i:=2 to trunc(sqrt(a)) do是什么意思,解释下,谢谢 trunc什么意思