# Anybody Experienced In Excel

Discussion in 'BlackHat Lounge' started by thinktank1, Oct 23, 2012.

1. ### thinktank1Regular Member

Joined:
Jun 3, 2012
Messages:
217
78
Location:
travelling on the information highway
So long story short, I need to change some numerical grades to letter grades within the cell. I know how to use vlookup but say there is a cell that has the grade of 96, I need to change this to an A+. It needs to be within the two variable data table. Really stuck on this and cant figure it out.

2. ### mirrormanNewbie

Joined:
Sep 24, 2011
Messages:
48
14

Create a new Column and use this formula

=IF(A1>90,"A+",IF(A1>80,"A",IF(A1>60,"B",IF(A1>50,"C", "D"))))

Then copy this down all the rows.

These are nested "IF" statements that take the form IF(condition,true,false)

If this doesn't make sense to you, let me know the exact gradings, and I'll do the exact formula for you.

3. ### rockongPower Member

Joined:
Jan 19, 2012
Messages:
661
283
Occupation:
Just create an IF function..it'll do exactly what you need. And yeah, what mirrorman says looks right.

4. ### rockongPower Member

Joined:
Jan 19, 2012
Messages:
661
283
Occupation:
excel reminds me of my corporate days...SMH

5. ### thinktank1Regular Member

Joined:
Jun 3, 2012
Messages:
217
78
Location:
travelling on the information highway
this is for one of my courses lol

6. ### thinktank1Regular Member

Joined:
Jun 3, 2012
Messages:
217
78
Location:
travelling on the information highway
thanks but what I am trying to do is change to the letter grade in replacement of the numerical grade within the cell.

7. ### mirrormanNewbie

Joined:
Sep 24, 2011
Messages:
48
14
Is there a specific reason you can't do what I suggested and then paste the resulting values into the original cells?

Last edited: Oct 24, 2012
8. ### VCC-bankBANNEDBANNED

Joined:
Apr 17, 2010
Messages:
86
6
i have tried the if statement and if working fine as the first replier says.

9. ### thinktank1Regular Member

Joined:
Jun 3, 2012
Messages:
217
78
Location:
travelling on the information highway
yes it does work, but there is a certain feature I am looking for that can do it without copying it from an external cell. thanks for your help

10. ### mirrormanNewbie

Joined:
Sep 24, 2011
Messages:
48
14
Unless you can explain better, then I think you're going to be having to use VBA/Macros to accomplish what you're asking.

11. ### jheyslowSenior Member

Joined:
May 11, 2010
Messages:
885
712
Occupation:
trying new things

12. ### GiorgioBSupreme Member

Joined:
Feb 28, 2012
Messages:
1,288
1,318
Occupation:
Making money
Location:
Touching the Sky
just use ctrl H mass replace.. or else create a rule to highlight cells between 90 and 100 and just paste A+ in all.. repeat with 80-90, etc.. 5 min max.

Joined:
May 11, 2010
Messages:
885