Teacher - trying to create if rule of % into text mark A B C etc

As stated in the title....

Want to make an if rule where a student gets overall 75% in a column, then in another column next to that that would automatically give him a B or a B+ you know what I mean?

Hear are the ratios

A+ - 90-100
A - 80-89
B+ - 75-79
B - 70-74
C+ - 65-69
C - 60-64
D+ - 55-59
D - 50-54
E+ - 45-49
E - 40-44

and another one

Excellent - 80-100
Very Good - 70-79
Good - 60-69
Moderate - 50-59
Borderline - 40-49

Hope it can be done.
Thanks

I am also a teacher too and do a lot of stuff like this.

Yes there are a few ways to do this. The simplist is using an if statement. eg. =if(A1>89.9,"A",if(A1>79.9,"A",ifA1>74.9,"B",

and you can carry this on up to 8 statements.

Hope this helps. If not there are a few other ways to do it

PLease let me know if you do any other stuff using excel for education. it is always good to get new ideas

Jack

quick reply thanks jack... I will give it a go

A friend of mine is pretty good - he taught me how to do lists - but es also right into autohotkey - check that little macro proggy out - he uses it with excel. I will post any more education findings.

Can't seem to get them to work - maybe because I don't understand them

What if the column its trying o read is - SUM(E4,B4)/4

Do I just copy and paste those into an excel box?

wish I knew more about excel - at the moment I'm working on a blank sheet - A1 value is 80.

I'm then pasting in the formulas in B1 but the formula just stays there

yes just copy the formula but is you are in column F and using data from column e then swap the A to an F

e.g.
=if(F1>89.9,"A+",if(F1>79.9,"A",if(F1>74.9,"B+","B)

That will work down to B but you can just add extra conditions on the end

Jack

okay 'excel'lent - update - Jacks formula works just had to close the bracket at the end.

VBnewb - your first formula was a little wrong and the program corrected it to this

=IF(OR(A1<40,A1=""),"",LOOKUP(A1,{40,45,50,55,60,65,70,75,80,90},{"E-","E+","D-","D+","C-","C+","B-","B+","A-","A+"}))

The problem was I had to just retype "=IF'

Yay it works!!!

I have posted an example of my whole sheet.

Thanks a bunch guys