# Convert/Calculate flat number into Goal %

1. ## 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!

2. ## 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. ## 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%.

4. ## 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.

5. ## Re: Convert/Calculate flat number into Goal %

Hi, and welcome to the forum

Formula:

6. ## Re: Convert/Calculate flat number into Goal %

Holy crap, that works. THANK YOU RICHARD!

7. ## 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:

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. ## Re: Convert/Calculate flat number into Goal %

There are currently 1 users browsing this thread. (0 members and 1 guests)