excel公式设置阶梯式提成公式

2024-11-10 11:29:58
推荐回答(2个)
回答1:

假如利润放在E列里,C11公式如下:
=IF(E4<1000,"0",IF(E4<3000,$C$10*6%,IF(E4<5000,$C$10*7%,IF(E4<8000,$C$10*8%,IF(E4<10000,$C$10*10%,$C$10*15%)
C18的公式如下:
=IF(C16-C15>0,"100%",(C16-C15)/C15))

回答2:

=IF(A1<=40,10,40)+ROUNDDOWN(A1-1-40,-1)