=ROUND(MAX((A1-0.95)/0.01,(B1-0.85)/0.03,0),0)*0.5-ROUND(MIN(MAX(0.95-A1,0.85-B1,0)/0.01,2),0)*2.5+5其中的意思...

=ROUND(MAX((A1-0.95)/0.01,(B1-0.85)/0.03,0),0)*0.5-ROUND(MIN(MAX(0.95-A1,0.85-B1,0)/0.01,2),0)*2.5+5其中的意思... =ROUND(A1*B1, 函数max(round(128.5,0),round(128.3, =ROUND(MAX((A1-3500)*0.05*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},0),2）想请问一下MAX((A1-3500)*0.05*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701}MAX函数的原理 IF(ROUND(A1,2)=3,0,ROUND(A1,2))这个函数是什么意思 =(SUM(A1:A10)-MAX(A1:A10)-MIN(A1:A10))/(COUNT(A1:A10)-2)是什么意思 请问：round(A1, =ROUND(RAND()*(MAX(B3,D3)-MIN(B3,D3)+0.04)+MIN(B3,D3)-0.018, 关于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 =IF(AND(ROUND(MAX(SUM(B22,D22)),2)=0,ROUND(MIN(SUM(B22,D22)),2)=0),校验通过,校验失败) 假设A1:A5分别存储l,3,9,10,20 则 MAX(A1:A5)=_______；MIN(A2:A5,A4)=_______;MAX(A1:A3,A5)=_____ =ROUND(MAX((A1-3500)*5%*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},0),2)怎么理解如题,我想知道这个函数怎么理解.为什么他可以算出来新个人所得税的征收钱数?中括号里的数都代表什么意思?谢谢 Max looks smart in his small round glasses .同义句要求如下Max's small round glasses ______ _______ ______him 缠中说禅中枢的区间：（max（a2,b2,c2）,min（a1,b1,c1））,那么存在max（a2,b2,c2）=min（a1,b1,c1）? max=a if(max COLUMN(D1:F1) EXCL函数,=MAX(FREQUENCY(IF(A1:P1=1,COLUMN(A1:P1)),IF(A1:P1=1,COLUMN(A1:P1)))) 请求详解这个语句的含义：=IF(COUNTIF(A$1:A1,A2),ROW(A1)-MAX(IF(A$1:A1=A2,ROW(A$1:A1))),) 在Excel中如果A1:A5包含数字8、11、15、16和4,MAX(A1:A5,18)=（ ）.