excel大神请指教
如果0.1<x<0.12,每增加0.01扣10,如果0.12<X<0.15,每增加0.01扣15元,用excel表格表示
=IF(AND(A2>0.1,A2<0.12),INT((A2-0.1)*100)*10,IF(AND(A2>0.12,A2<0.15),INT((A2-0.12)*100)*15,))
热门标签:
如果0.1<x<0.12,每增加0.01扣10,如果0.12<X<0.15,每增加0.01扣15元,用excel表格表示
=IF(AND(A2>0.1,A2<0.12),INT((A2-0.1)*100)*10,IF(AND(A2>0.12,A2<0.15),INT((A2-0.12)*100)*15,))