Forum Discussion
Lookup Formula (Any type of lookup) for repeated values
Hi I have the following table, Chargeable Income Rate ( % ) Gross Tax Payable ($) Cumulative income On the first 20,000 0.0% 0 20000 On the next 10,000 2.0% 200 30000 On the...
=IF(AND($C$8>SUM($C$1:C1),$C$8>SUM($C$2:C2)),C2,$C$8-SUM($D$1:D1))An alternative could be a helper column with this formula in cell D2 and filled down.
=SUMPRODUCT($D$2:$D$5,$E$2:$E$5)Then SUMPRODUCT calculates the tax. The taxable amount is in cell C8.