Works fine for me, can you post an example data that isn't working?
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
wrote in message
oups.com...
Hi,
This SHOULD calculate TAX in the UK for 2006 (see
http://www.tfpl.com/permanent_recrui...calculator.cfm
or
http://www.listentotaxman.com/index....bmit=Calculate)
I did....
Allowance 5035 10.00% 10.00%
Allowance plus threshold 7185 22.00% 12.00%
Upper limit 33300 40.00% 18.00%
=SUMPRODUCT(--(C31B1:B3),(C31-B1:B3),D1:D3)
Where C31 is the gross anual salary
But it doesn't work! PLEASE help! What am I doing wrong?
Thanks,
Rob