excel大神请指教
提问: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,))