麻烦厉害的小伙伴帮我列个EXCEL公式,条件如图所示:
比如A1是0.17%和0.0051%,那么他分别应该得多少分?
=IF(A2>0.19%,0,IF(A2>0.023%,60-(A2-0.023%)*60/(0.19%-0.023%),100-A2*40/0.023%))
=MAX(100-A2*40/0.023%,60-(A2-0.023%)*60/(0.19%-0.023%),0)
热门标签:
比如A1是0.17%和0.0051%,那么他分别应该得多少分?
=IF(A2>0.19%,0,IF(A2>0.023%,60-(A2-0.023%)*60/(0.19%-0.023%),100-A2*40/0.023%))
=MAX(100-A2*40/0.023%,60-(A2-0.023%)*60/(0.19%-0.023%),0)