Anybody Experienced In Excel

So long story short, I need to change some numerical grades to letter grades within ...
1. ## Anybody Experienced In Excel

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. Newbies
Join Date
Sep 2011
Posts
30
Reputation
12
Thanks
8
Thanked 10 Times in 6 Posts

## Re: Anybody Experienced In Excel

Let's assume your grades are in Column A

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. ## Re: Anybody Experienced In Excel

Just create an IF function..it'll do exactly what you need. And yeah, what mirrorman says looks right.

4. ## Re: Anybody Experienced In Excel

excel reminds me of my corporate days...SMH

5. ## Re: Anybody Experienced In Excel

this is for one of my courses lol

6. ## Re: Anybody Experienced In Excel

thanks but what I am trying to do is change to the letter grade in replacement of the numerical grade within the cell.

Originally Posted by mirrorman
Let's assume your grades are in Column A

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.

7. Newbies
Join Date
Sep 2011
Posts
30
Reputation
12
Thanks
8
Thanked 10 Times in 6 Posts

## Re: Anybody Experienced In Excel

Is there a specific reason you can't do what I suggested and then paste the resulting values into the original cells?
Last edited by mirrorman; 10-23-2012 at 10:30 PM.

8. Registered Member
Join Date
Apr 2010
Posts
79
Reputation
10
Thanks
5
Thanked 6 Times in 5 Posts

## Re: Anybody Experienced In Excel

i have tried the if statement and if working fine as the first replier says.

9. ## Re: Anybody Experienced In Excel

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. Newbies
Join Date
Sep 2011
Posts
30
Reputation
12
Thanks
8
Thanked 10 Times in 6 Posts

## Re: Anybody Experienced In Excel

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. ## Re: Anybody Experienced In Excel

@OP just send me the file I do this for free.

12. ## Re: Anybody Experienced In Excel

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.

13. ## Re: Anybody Experienced In Excel

I think the only solution for this is VBA or Macros.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•