Try using a series of nested IF statements in hiden cells. Like this:


A1 = TOTAL

B1
=IF(A1<1000000,A1*0.05,50000)

C1
=IF(A11000000, IF(A1<2000000,(A1-1000000)*0.04,40000),“”)

D1
=IF(A12000000, IF(A1<3000000,(A1-2000000)*0.03,30000),“”)

E1
=IF(A13000000, IF(A1<4000000,(A1-3000000)*0.02,20000),“”)

F1
=IF(A14000000,(A1-4000000)*0.02,“”)

G1
=SUM(B1:F1)


---
~~ Message posted from http://www.ExcelForum.com/