Return $ value by applying enbeded formula

Hello,

May I know what formula to use for return of tax amt value (3) of table C. be automatically lookup to the enbeded formula corresponding to the income code of table B.



Yearly income table
A: Tax Schedule

Inc ode Min income Max income $ 1st tier income tax 2nd tier income % tax

Col A Col B Col C Col E Col G
A 0 140000 0 0.18
B 140001 221000 25200 0.25
C 221001 305000 45450 0.3
D 305001 431000 70650 0.35
E 431001 552000 114750 0.38
F 552001 1000000 160730 0.4

B. Income corresponding to income code of tax schedule / taxable income computation
Income Income code Total tax Amt($) Remark
135000 A 24300 '=A14*$G$6
190000 B 37700 '=(A15-$C$6)*$G$7+$E$7
222000 C 45750 '=(A16-$C$7)*$G$8+$E$8
400000 D 103900 '=(A17-$C$8)*$G$9+$E$9
450000 E 121970 '=(A18-$C$9)*$G$10+$E$10
600000 F 179930 =(A19-$C$10)*$G$11+$E$11


C. individual tax amount

Input for Income(1) Income code(2) Tax amt($) (3)

332000 C ( return Value $) - Applying enbeded formula
410000 D (xxxxxxx )

Thanks.
kk