# formula for percentage ranges, can't figure out

1. ## formula for percentage ranges, can't figure out

Hi everyone! I am a excel newbie and I am ready to pull my hair out! Having trouble with this formula I want to reference the percentage in cell G2. Here is the formula,

>= 75% add 6
65-74.9% add 3
55-64.9% add 1
45-54.9% none
35-44.9% subtract 1
25-34.9% subtract 3
Less then 25% subtract 6

Could someone help me with this, I keep getting errors with everything I enter after IF(G2>=75,6,IF(G2?

Thanks

2. ## Re: Impossible formula need help

Welcome to the forum, Mainbeam.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

3. ## Re: Impossible formula need help

Can you give us an example spread sheet.

But going on what you gave us. Change the percentage references to .75 as this is how excel sees 75% in a cell.

4. ## Re: Impossible formula need help

Originally Posted by shg
Welcome to the forum, Mainbeam.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.
I'm sorry, I fixed it, but why did it still get deleted?

5. ## Re: formula for percentage ranges, can't figure out

Please attach a sample spreadsheet.

But based on what you provided change IF(G2>=75,6,IF to IF(G2>=.75,6,IF...

6. ## Re: formula for percentage ranges, can't figure out

Ok I will tomorrow once I get to office.
It's the 2nd part that screws me up, for example: IF(G2>=.75,6,IF(G2>=.65<74.9,3,IF.......? Is this right cause I keep getting errors. Thanks

#### Thread Information

##### Users Browsing this Thread

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

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