Anybody Experienced In Excel

T

thinktank1

Regular Member
Joined
Jun 3, 2012
Messages
217
Reaction score
78
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.
 
Advertise on BHW
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.
 
Just create an IF function..it'll do exactly what you need. And yeah, what mirrorman says looks right.
 
thanks but what I am trying to do is change to the letter grade in replacement of the numerical grade within the cell.


mirrorman said:
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.
Click to expand...
 
Is there a specific reason you can't do what I suggested and then paste the resulting values into the original cells?
 
Last edited:
i have tried the if statement and if working fine as the first replier says.
 
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
 
Unless you can explain better, then I think you're going to be having to use VBA/Macros to accomplish what you're asking.
 
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.
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top