mshd.net
当前位置:首页 >> EXCEL,分值是30,小于等于0.5%得满分,每高0.05%... >>

EXCEL,分值是30,小于等于0.5%得满分,每高0.05%...

A1输入 百分比, B1输入公式 =30-((A1-0.005)/0.0005)/(1+(A1

=1-if(a1>90%,0,ceiling((0.9-a1)/0.05,1)*0.1) =MAX(1-IF(A1>90%,0,CEILING((0.9-A1)/0.05,1)*0.1),)

=SUMPRODUCT(TEXT(A1-{0,200,250,300,350},"0.00;\0")*{0.5,0.05,0.05,0.05,0.05})/100

等于3000乘多少? 设这数在A1,结果 在B1,请在B1输入公式: =A1*IF(A1

=if(a1

网站首页 | 网站地图
All rights reserved Powered by www.mshd.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com