根据条件算周六加班工资

咱，狠幸福_

问题1xlsx.zip (12.14 KB, 下载次数: 28)

2024-5-11 09:39 上传

点击文件名下载附件

晨光晞微

1. =ROUND(LOOKUP(E5,{0,27,30},{4,6,9})*2*1900/21.75,)

复制代码

dengjq2000

=ROUND(LOOKUP(E5,{0,27,30},{4,6,9})*1900/21.75*2,)

沈默00

沈默00

=LET(x,1900/21.75*2,IFS(E5<=26,x*4,AND(E5>26,E5<=29),x*6,AND(E5>29,E5<=31),x*9))

hugeinfo

=1900/21.75*2*LOOKUP(E5,{0;27;30},{4;6;9})

hxj119

这问题与昨天基本一样呀。
=ROUND(1900/21.75*2*IF(E5<=26,4,IF(E5<=29,6,IF(E5<=31,9,"未知"))),0)

用lookup比较简单不用写这么多IF.

mykitami

=1900/21.75*2*LOOKUP(E5,{0.01,4;26.01,6;29.01,9})

renzhe3496

=IFS(E5<=26,1900/21.75*2*4,E5<=29,1900/21.75*2*6,E5<=31,1900/21.75*2*9)

swl4561255

1. =ROUND(1900*2*LOOKUP(E5,{0,4;27,6;30,9})/21.75,)

复制代码