=IF(K3=<1500,K3*0.03,IF(K3=<4500,K3*0.1-105,IF(K3=<9000,K3*0.2-555,IF(=<35000,K3*0.25-1005,IF(K3=<55000,K3*0.3-2755,IF(K3=<80000,K3*0.35-5505,K3*0.45-13505))))))
这个公式为什么不对
应该是<=
<=而不是=<
IF(K3>80000,K3*45%-13505,IF(K3>55000,K3*35%-5505,IF(K3>35000,K3*30%-2755,IF(K3>9000,K3*25%-1005,IF(K3>4500,K3*20%-555,IF(K3>1500,K3*10%-105,K3*3%-0))))))
没有=号