+ Reply to Thread
Results 1 to 2 of 2

Ways To Create worksheet working 2 national insurance.

  1. #1
    Registered User
    Join Date
    12-04-2016
    Location
    tech
    MS-Off Ver
    2016
    Posts
    21

    Ways To Create worksheet working 2 national insurance.

    Hello everyone!
    I'm working on a worksheet for a sole trader and would like to work out, how much band 2 national insurance she should pay. However if possible i would like to avoid vba and just use an equation, so:
    puesdo code

    if referenced cell is more than equal too 5995 then for every week after that change 2.80 per week.

    Could some one tell me if this is possible or will i have to use vba.

    Thanks!

    QC: chúng tôi là địa điểm đăng ký internet fpt bình địnhinternet fpt gia laiinternet fpt huế cho quý khách hàng.
    Last edited by thanhvanchi; 12-15-2016 at 03:29 AM.
    Ch?c c?c bạn vui vẻ.

  2. #2
    Forum Contributor
    Join Date
    08-25-2014
    Location
    Pennsylvania, US
    MS-Off Ver
    Windows '16
    Posts
    165

    Re: Ways To Create worksheet working 2 national insurance.

    Anything is possible, as long as you provide enough specificity about your problem. Upload a sample workbook with the data you input and the desired output. Or describe your problem better so we can help.

+ 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. Problem with a working out national insurance class 2 equation?
    By scottpattison in forum Excel General
    Replies: 1
    Last Post: 10-08-2016, 06:31 PM
  2. National insurance
    By Ayoub99k in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-04-2015, 02:16 AM
  3. [SOLVED] Display last working day of month, taking into account national holidays?
    By will1565 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-29-2015, 06:53 PM
  4. [SOLVED] Formula to calculate National Insurance
    By PDBartlett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-25-2014, 07:52 AM
  5. National Insurance Validation
    By Sirishgreen in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-29-2012, 12:08 PM
  6. Excel macro for UK national insurance number
    By woodkeith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-03-2011, 08:39 AM
  7. [SOLVED] where can i find uk tax and national insurance calculations
    By Dr.AJ in forum Excel General
    Replies: 1
    Last Post: 05-17-2005, 06:06 PM

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