+ Reply to Thread
Results 1 to 4 of 4

Calculating Percentage need to hit new percentage

  1. #1
    Registered User
    Join Date
    05-08-2017
    Location
    United stated
    MS-Off Ver
    7
    Posts
    2

    Calculating Percentage need to hit new percentage

    Hello,

    I'm having trouble with a formula to take a percentage currently established to a higher percentage. My employees have a 40% goal on a company attachment metric and I'm trying to find the percentage they will need to hit to accomplish the minimum of 40%.

    Employee A has 2 attached out of a possible 10 for 20% for example. What percentage of new attachments will they need to achieve to reach their current attachment of 20% to the minimum goal of 40%

    Thanks,

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Calculating Percentage need to hit new percentage

    If they have attached 2 out of 10, I assume the remaining 8 were not attached and never will be.

    How many new attachment attempts will there be? That bit of data is required for this calculation. Here is why.

    To continue your example, if they have 10 more attempts, then they will need to attach 6 out of those 10, or 60%, to reach a total of 40%, which is 8 for all 20 attempts. But if they have 20 more attempts, they will need to attach 10 of those, or 50%, or reach a total of 40%, which is 12 for all 30.

    What in the world is an "attachment"?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-08-2017
    Location
    United stated
    MS-Off Ver
    7
    Posts
    2

    Re: Calculating Percentage need to hit new percentage

    Sorry probably worded it incorrectly. Also attachment is when the employee makes a sale there are items we want them to "attach" to the sale.

    What I'm looking for is a formula to that will calculate how many the employee has to attach to the sale in order for their percentage to be at 40%.

    So Employee A has 2 of 10 for 20% but how many will they have to get before their percentage reaches 40%. Or a way that will add 1 to their attached number and attempts before the 20% reaches 40%.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Calculating Percentage need to hit new percentage

    You have to know one of two things:

    How many attempts will be included in the total

    or

    You assume that subsequent attempts will be 100%

    In my first post I described why the first number would be needed. Let's take a second scenario: The employee has 2 of 10 for 20%. How many more do they have to do, at a rate of 100%, for the overall rate to be 40%? I think that is what you are saying by "a way that will add 1 to their attached number and attempts" but if you provide an example of the final result you want, it would go a long way.

    For the second scenario, let's say A1 has 2, A2 has 10. You don't need the resulting percentage for the calculation. Assume B1 has 40%, the target. To determine how many more they need for 40%:

    =CEILING.MATH((A1-B1*A2)/(B1-1))

    gives the next whole number that will give 40% or better.

    ETA: In this example they need 4 out of 4 to reach 40% (and they will be a little better than 40%)
    Last edited by 6StringJazzer; 05-08-2017 at 03:11 PM. Reason: added blue

+ 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. Replies: 1
    Last Post: 09-20-2016, 07:33 PM
  2. [SOLVED] Formula for percentage Increase and corresponding percentage decrease (and viceversa)
    By jcroque89 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2015, 10:25 AM
  3. [SOLVED] Calculating a Percentage of a Percentage
    By tpedry in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2014, 03:44 PM
  4. calculating percentage of percentage
    By zinneken in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-10-2013, 10:12 AM
  5. Replies: 1
    Last Post: 01-13-2013, 08:39 PM
  6. [SOLVED] Calculating a percentage with the end percentage in mind
    By Shadowshady in forum Excel General
    Replies: 2
    Last Post: 06-17-2006, 04:45 AM
  7. Replies: 2
    Last Post: 02-01-2006, 12:50 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