+ Reply to Thread
Results 1 to 2 of 2

Percentage values based on number of reports not actual percentage value

  1. #1
    Registered User
    Join Date
    08-30-2016
    Location
    Dallas, Texas
    MS-Off Ver
    excel 2013
    Posts
    71

    Percentage values based on number of reports not actual percentage value

    Hi all,

    I'm back again. Todays question is about setting increasing percentage value based on the number of reports finished, not on what the actual numerical percentage. For example, if an employee completes 55 reports, they have achieved 80% of expected production for the day. 56 reports would be 81%, 57 would be 82% up to 75 which is 100%. The problem I am running into is 55 report out of possible 75 is actually 73.33%. The next break point is 65 reports which is 90%, except 65 out of 75 is actually 86.66%. How do I set up the formula to take the number of reports completed and return a percentage value based on an artificial value, not actual math?

  2. #2
    Registered User
    Join Date
    08-30-2016
    Location
    Dallas, Texas
    MS-Off Ver
    excel 2013
    Posts
    71

    Re: Percentage values based on number of reports not actual percentage value

    I can make a VLOOKUP work if I create a chart with each number and a corresponding percentage value, but I was hoping to use a formula and not have to go with the VLOOKUP option

+ 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. change in percentage for actual data
    By ruchi1127 in forum Excel General
    Replies: 4
    Last Post: 10-17-2015, 08:57 PM
  2. Calculating percentage complete based on actual and not forecasted
    By greeneggsandsam in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-16-2014, 01:23 PM
  3. Percentage the actual value is between the min and max values.
    By James.T in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-17-2013, 02:16 PM
  4. [SOLVED] Percentage of a Goal / Actual with Negative Numbers
    By Rwilliams_09 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-08-2013, 04:43 PM
  5. Replies: 2
    Last Post: 04-04-2013, 12:44 AM
  6. Displaying actual values on a percentage bar graph
    By BFlick11 in forum Excel General
    Replies: 9
    Last Post: 07-21-2011, 08:39 AM
  7. Replies: 2
    Last Post: 01-31-2008, 07:20 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