excel用if公式如何设置？

Question

绩效得分<=60%,得分为0；
60%<绩效得分<=70%,得分为0.8；
70%<绩效得分<=80%,得分为0.9；
80%<绩效得分<=90%,得分为1；
绩效得分>90%,得分为1.2；

哪位好心人帮忙设置下IF公式啊，跪谢了

Answer 1

EXCEL的IF公式只有的规则的表格才奏效，你要排列他才行，很简单的用法，但不提倡你用
=if(成绩得分!A1<60%,0,if(成绩得分!A1>60%&成绩得分!A1<=70%,0.8,if(成绩得分!A1>70%&成绩得分!A1<=80%,0.9,成绩得分!A1>70%&成绩得分!A1<=90%,1,1.2)))
一直循环嵌套
一般我们是建立个数据区域，让他去Vlookup

Answer 2

使用下列公式之一
=IF(A1<=0.6,0,IF(A1<=0.7,0.8,IF(A1<=0.8,0.9,IF(A1<=0.9,1,1.2))))
=IF(A1>0.9,1.2,IF(A1>0.8,1,IF(A1>0.7,0.9,IF(A1>0.6,0.8,0))))
=IF(A1="","",LOOKUP(A1,{0,0.6,0.7,0.8,0.9}+10^-8,{0,0.8,0.9,1,1.2}))

Answer 3

=IF(A21<=60%,0,(IF(A21<=70%,0.8,(IF(A21<=80%,0.9,IF(A21<=90%,1,(IF(A21>90%,1.2,null))))))))
公式比较长，放在a21单元格，往下拉就是了。
做人啦 最重要的是开心啦
满意请采纳哦~有财富可以加财富~有其它问题可以继续追问

Answer 4

=lookup(绩效得分所在单元格*10,{0,6,7,8,9}+0.0001,{0,0.8,0.9,1,1.2})

Answer 5

公式：
=IF(A1<=0.6,0,IF(A1<=0.7,0.8,IF(A1<=0.8,0.9,IF(A1<=0.9,1,1.2))))