| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
This is DRIVING ME INSANE!
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
This is DRIVING ME INSANE!
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
This is DRIVING ME INSANE!
The upper limit of your table is incorrect: it should be 38335 as you haven't
allowed for the non-taxable allowance. Allowance 5035 10.00% 10.00% Allowance plus threshold 7185 22.00% 12.00% Upper limit 38335 40.00% 18.00% HTH "Bob Phillips" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP - Driving me potty!!! | Excel Worksheet Functions | |||
| Sorry for reposting - but this is driving me crazy! | Excel Discussion (Misc queries) | |||
| How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
| My Shared workbook is driving me crazy!!! | Excel Discussion (Misc queries) | |||
| Help: Scroll wheel toggles between up and down, and left and right - is driving me crazy | Excel Discussion (Misc queries) | |||
Linear Mode
