help for teacher!
 

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


--
Babio
------------------------------------------------------------------------
Babio's Profile: http://www.excelforum.com/member.php...o&userid=14601
View this thread: http://www.excelforum.com/showthread...hreadid=267492

help for teacher!
 

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

"Babio" wrote in message
...

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


--
Babio
------------------------------------------------------------------------
Babio's Profile:
http://www.excelforum.com/member.php...o&userid=14601
View this thread: http://www.excelforum.com/showthread...hreadid=267492

help for teacher!
 

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

Babio wrote:

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

--
Babio
------------------------------------------------------------------------
Babio's Profile: http://www.excelforum.com/member.php...o&userid=14601
View this thread: http://www.excelforum.com/showthread...hreadid=267492

--

Dave Peterson