+ Reply to Thread
Results 1 to 9 of 9

Convert/Calculate flat number into Goal %

  1. #1
    Registered User
    Join Date
    01-16-2017
    Location
    San Francisco
    MS-Off Ver
    Office 2013
    Posts
    8

    Convert/Calculate flat number into Goal %

    HELP! I want to take a flat number and press it against a goal and have the answer be a %, with the option to go negative, if needed.

    Goal.png

    The goal is to use 0 (=100%) as shown in the first example. If the candidate used say 5, they would -25%, as shown in the last example.

    Thanks in advance for any help you can give me, and the goal column can say 0 or 100%, whatever is easier for the formula. Thanks!
    Last edited by MrsRobot; 01-16-2017 at 04:16 AM.

  2. #2
    Registered User
    Join Date
    01-16-2017
    Location
    Tartu, Estonia
    MS-Off Ver
    2016
    Posts
    4

    Re: Convert/Calculate flat number into Goal %

    Hi!

    Maybe try using this formula in score cell: =(max - used)/max and make the cell in percentages. It worked for me

  3. #3
    Registered User
    Join Date
    01-16-2017
    Location
    San Francisco
    MS-Off Ver
    Office 2013
    Posts
    8

    Re: Convert/Calculate flat number into Goal %

    Hi there! I tried that, but it won't level to the 0 for the max allotted - it gives me the wrong answer, not -25%

    If they were allotted 4 and used 5, the answer should -25% if we're normalizing/leveling against 0 used. 0 = 100% aka the goal.
    To do simple math is 4-5 = -1, great, but I need that score to be a % of their goal which is 0 used, which gives them = 100%.
    Last edited by MrsRobot; 01-16-2017 at 04:32 AM.

  4. #4
    Registered User
    Join Date
    01-16-2017
    Location
    San Francisco
    MS-Off Ver
    Office 2013
    Posts
    8

    Re: Convert/Calculate flat number into Goal %

    ugh, I can't delete this dup post -sorry guys. I'm a hot mess... just like my formula.
    Last edited by MrsRobot; 01-16-2017 at 04:35 AM.

  5. #5
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Convert/Calculate flat number into Goal %

    Hi, and welcome to the forum

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    01-16-2017
    Location
    San Francisco
    MS-Off Ver
    Office 2013
    Posts
    8

    Re: Convert/Calculate flat number into Goal %

    Holy crap, that works. THANK YOU RICHARD!

  7. #7
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Convert/Calculate flat number into Goal %

    ...there was a typo in my last post. The formula should of course have been shorter. i.e.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    01-16-2017
    Location
    San Francisco
    MS-Off Ver
    Office 2013
    Posts
    8

    Re: Convert/Calculate flat number into Goal %

    yup. I shaved off the excess, and it worked before your post - didn't want to call you out, given you helped me. Thanks again!

  9. #9
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,267

    Re: Convert/Calculate flat number into Goal %

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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: 9
    Last Post: 11-26-2016, 11:14 AM
  2. Calculate Daily Goal to get to End of Month Goal
    By budzique in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-31-2016, 11:02 PM
  3. Convert hierarchy list to flat table format
    By tbucki1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2016, 04:19 PM
  4. Trying to convert to a flat table for pivot analysis
    By Vaslo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2013, 07:03 PM
  5. sub grouping convert to flat file
    By tushar101 in forum Access Tables & Databases
    Replies: 3
    Last Post: 05-17-2011, 10:06 AM
  6. Convert Excel Flat File Into Relational Database
    By crazysniper in forum Access Tables & Databases
    Replies: 15
    Last Post: 01-09-2011, 08:09 PM
  7. Convert a multilayered staggered data to flat file.
    By matrosov in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-02-2009, 10:49 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