help for teacher!

[Babio]

Can someone tell me what the formula would be (using the IF function) if
I wanted to, for example, add a column of grades next to a column of
scores... I can do the basic IF function if I wanted just to do a pass
or fail but say I wanted to beak it down to A,B,C,D & F. They give very
breif instructions in Excel, but its scrappy and vague at best. If
anyone knows please pass it on
thanks

 

[Cecilkumara Fernando]

Babio,
Assuming 85 & above A, 70-84 B, 55-69 C, 40-54 D, 0-39 F
and your "score" column is A starting A2
put this formula in B2 and fill down
=If(A2<40,"F",If(A2<55,"D",If(A2<70,"C",If(A2<85,"B","A"))))
Cecil

 

[Dave Peterson]

Debra Dalgleish uses grades as an example in her =vlookup() instructions:
http://www.contextures.com/xlFunctions02.html