+ Reply to Thread
Results 1 to 4 of 4

UK tax calculator

  1. #1
    Registered User
    Join Date
    02-05-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    56

    UK tax calculator

    The UK Chancellor is toying with the idea of taking away the Personal TAX Allowance from expatriate Brits.

    In anticipation of this I have set up an Excel calculator which shows two boxes - one red and the other blue.

    The red box ix simple and calculates the tax I must pay on income without the personal tax allowance.

    The blue box contains similar information except that it does show the personal allowance. Since my income in box B22 does not exceed the personal tax allowance in box B24, it means that Box B26 should return a zero numberUK taxable income 2013 without personal allowance.xls answer.

    How can I achieve this?


    David
    Last edited by David HK; 11-26-2014 at 06:00 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: UK tax calculator

    Try

    in B26
    =IF(B24 > B22,0,B22-B24)
    or possibly
    =MAX(B22-B24,0)
    Last edited by Special-K; 11-26-2014 at 05:55 AM.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: UK tax calculator

    hi David HK, please check attachment

  4. #4
    Registered User
    Join Date
    02-05-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: UK tax calculator

    Thanks to both contributors for successful recommendations.

    David

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. GPA calculator
    By kovachattack in forum Excel General
    Replies: 3
    Last Post: 04-24-2009, 09:31 AM
  2. GPA Calculator
    By JB4 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2008, 03:26 AM
  3. Integrated calculator in excel 07 instead of separate calculator
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 11:20 AM
  4. uk tax calculator
    By DarkNight in forum Excel - New Users/Basics
    Replies: 21
    Last Post: 05-03-2006, 01:25 PM
  5. [SOLVED] Hex Calculator
    By Luis Rentería in forum Excel General
    Replies: 1
    Last Post: 02-25-2005, 05:24 AM

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