=IF( A1<=15000,0, IF( A1<=30000,( A1-15000)*2.5%, IF( A1<=45000,( A1-30000)*10%+375, IF( A1<=60000,( A1-45000)*15%+375+1500, IF( A1<=200000,( A1-60000)*20%+375+1500+2250, IF( A1<=400000,( A1-200000)*22.5%+375+1500+2250+28000, IF( A1<=600000,( A1-400000)*25%+375+1500+2250+28000+45000, IF( A1>600000,( A1-400000)*25%+375+1500+2250+28000+45000 +IFERROR(LOOKUP( A1,{600001;700001;800001;900001;1000001},{375;2625;4875;7875;12875}),0) ))))))))