请教几个excel公式?答:公式1:=IF(A1<=40,2,MAX(2-(ROUNDUP((A1-40)/5,0))*1.5,0))公式2:=IF(A1=0,2+1,IF(A1<=1%,2,MAX(2-(ROUNDUP((A1-1%)/0.5%,0))*1,0)))公式3:=IF(A1=0,4+1,IF(A1<=2%,4,4-(ROUNDUP((A1-2%)/0.5%,0))*1))公式4:=IF(A1>=0.9,2,IF(AND(A1<0.9...
excel 问题 请教 工资怎么做答:看你工资是要怎么样付的,以实际的付还是按合同的付,具体还有什么要求?HI我帮你 --- =IF(A1>=60,LOOKUP(A1,{60,70,80,100},{3000,3650,4330,5730}),3000+(A1-60)*50)