假如利润放在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))
=IF(A1<=40,10,40)+ROUNDDOWN(A1-1-40,-1)