Results 1 to 4 of 4

Multiple IF Statements with < and > functions for range of values

Threaded View

  1. #1
    Registered User
    Join Date
    09-27-2011
    Location
    Dundalk, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    8

    Multiple IF Statements with < and > functions for range of values

    Hi There,

    I have a sheet used to calculate USC levies in Ireland for payroll purposes. I am tryng to use one formula to calcalate amount due. At present i have it set up manually. If there was an IF statement i could use to make thngs easier i would appreciate your help. I have attached sample sheet to help understand what im looking for.

    Basically in short i would like column k "Total Due" to include IF statement for 3 conditions rather than columns E-J in blue.
    If gross wage <€193 then calculate at a rate of 2%
    If >€193.01 but <€308 calculate first €193 at 2% remainder at 4%
    If >308.01 calculate first €193 at 2%, between €308-€193.01 at 4% and remainder >€308.01 at 7%. This is on cummulative basis and for week1 so

    Week2 will be as follows
    If gross wage <€193*2 then calculate at a rate of 2%
    If >€193.01*2 but <€308*2 calculate first €193*2 at 2% remainder at 4%
    If >308.01*2 calculate first €193*2 at 2%, between (€308*2)-(€193.01*2) at 4% and remainder >€308.01*2 at 7% as so on *3, *4, *5..........*52 weeks
    Attached Files Attached Files

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