求教：EXCEL计算病假工资：假期工资/21.75*病假天数*需扣款的比例。

Answer 1

下表D2公式：
=IF(C2="Y",LOOKUP(B2,{0,1,3},{0.6,0.5,0.4}),LOOKUP(B2,{0,2,4,6,8},{0.4,0.3,0.2,0.1,0}))*A2

追问

不好意思，还要加个病假的天数，谢谢！

追答

E2公式：
=IF(C2="Y",LOOKUP(B2,{0,1,3},{0.6,0.5,0.4}),LOOKUP(B2,{0,2,4,6,8},{0.4,0.3,0.2,0.1,0}))*A2/21.75*D2