+ Reply to Thread
Results 1 to 3 of 3

Fun with tax

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    Stratford, England
    MS-Off Ver
    Excel 2007
    Posts
    15

    Fun with tax

    Hi all! I've got a question which is really taxing me, one of those tax band questions. I've attached what I've got so far, but I don't see where abouts its going wrong. If I break the formula down in the 'tax to be paid' column, then it all seems to work correctly!

    For instance, for the top example, using the equation: =VLOOKUP(B13,TaxTable,3)+((B13-(VLOOKUP(B13,TaxTable,1))*VLOOKUP(B13,TaxTable,2))) gives me the value £72,802.20
    However, if I break down the formula:

    =VLOOKUP(B13,TaxTable,3) gives £5300

    =((B13-(VLOOKUP(B13,TaxTable,1)))) gives £43,502.20

    =VLOOKUP(B13,TaxTable,2) gives 0.4

    Then the seperate calculation:
    5300 + (43,502.2*0.4) = £22,700.88
    Which should be the correct answer. So what have I done with the top calculation that is making it not play ball?

    Thanks!
    Attached Files Attached Files
    Last edited by iviv; 01-12-2012 at 07:04 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Fun with tax

    Hi,

    =VLOOKUP(B13,TaxTable,3)+(B13-(VLOOKUP(B13,TaxTable,1)))*VLOOKUP(B13,TaxTable,2)
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-06-2012
    Location
    Stratford, England
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Fun with tax

    Ah, thanks! I'd started adding brackets to try and get excel to behave and group them how I wanted to, didn't realise that was the problem and that I'd had too many brackets in there in the first place! :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1