+ 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
    28,336

    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.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  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
    28,336

    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
    19,088

    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