=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

分类: 作业答案 • 2022-02-01 23:12:42

问题描述：

=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