Question

excel表的函数公式

A1是绩效工资标准（假如是2000），A2是绩效得分，A3是实际发放的绩效工资，实际发放的绩效工资的计算方法是：1.当A2大于或者等于90分以上，A3=A1*A2/100;
2.当A2大于或者等于80分小于90分，A3=A1*A2*70%/100;
3.当A2大于或者等于60分小于80分以上，A3=A1*A2*50%/100;
4.当A2小于60分，A3=0，及不发放绩效工资;
请求那个大仙帮助做个excel表的函数公式！

Answer 1

=LOOKUP(A2,{0,60,80,90},{0,0.5,0.7,1})*A1*A2/100

Answer 2

A3公式:
=IF(A2<60,0,IF(AND(A2>=60,A2<80),A1*A2*50%/100,IF(AND(A2>=80,A2<90),A1*A2*70%/100,A1*A2/100)))
你直接把上面公式复制,然后粘贴到你的A3单元格即可.

Answer 3

A3公式
=a1*a2*lookup(a2,{0,60,80,90},{0,0.5,0.7,1})/100

Answer 4

=IF(A2>=90,A1*A2/100,IF(AND(A2>=80,A2<90),A1*A2*0.7/100,IF(AND(A2>=60,A2<80),A1*A2*0.5/100,"")))

Answer 5

简单函数入门，求和，求平均值……