formula for percentage ranges, can't figure out

**Mainbeam** · 10-19-2011, 09:50 PM

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

**shg** · 10-19-2011, 10:01 PM

Welcome to the forum, Mainbeam.

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

Thanks.

**timtrag12** · 10-19-2011, 10:02 PM

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.

**Mainbeam** · 10-19-2011, 10:37 PM

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?

**timtrag12** · 10-19-2011, 10:51 PM

Please attach a sample spreadsheet.

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

**Mainbeam** · 10-20-2011, 12:06 AM

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