+ Reply to Thread
Results 1 to 3 of 3

Need a formula or macro to solve problem with different percentages

  1. #1
    Registered User
    Join Date
    12-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Need a formula or macro to solve problem with different percentages

    Hi All,

    I have an issue that I could not figure out and wanted to get some help from you guys:

    What I want is as follows:

    so have have different employees bringing different amounts of money in, what I need to do is to possibly create a nested code that calculates the amounts they will be paid based on different percentages, for example:

    employee A has done jobs for $100, 300, 500, 1200, 100, 1250 (all entered horizontally)

    I need to pay him 50% on jobs over $1000 and 40% on jobs under $1000.

    Now, I am looking for a code that can calculate all these for me in one cell and sum them up in the same cell. So basically in one cell I want to calculate (100+300+500)*.40 + (1200+1250)*.50 = 360 + 1225 = $1585 (were the code automatically finds number under 1000 and multiply them by .4 and automatically finds the numbers over 1000 and multiply them by .5 and add up the results) . I would appreciate it if someone can help me with this issue.

    Best,
    Ash

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need a formula or macro to solve problem with different percentages

    Hi and welcome to the forum

    maybe this?
    =SUMIF(A1:F1,"<1000")*0.4+SUMIF(A1:F1,">=1000")*0.5
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    12-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Need a formula or macro to solve problem with different percentages

    Dear FDibbins,

    Thank you for your warm welcome and thanks a lot for the formula! It was exactly what I was looking for. I really appreciate your help with this.

    Best,
    Ash

+ 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. How to solve the problem with the right formula
    By gerard_gonzales33 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-16-2012, 05:36 AM
  2. Need formula to solve the problem
    By chintanbtech in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2012, 12:48 PM
  3. Sumif or other Formula to solve problem
    By Vibro in forum Excel General
    Replies: 2
    Last Post: 06-14-2011, 10:11 PM
  4. Help required to solve rounding problem with macro
    By sarath25 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2011, 05:36 AM
  5. [SOLVED] solve formula problem
    By InvGrp2 in forum Excel General
    Replies: 6
    Last Post: 11-15-2007, 09:48 AM

Tags for this Thread

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