Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to display subjects taught by a specific teacher upon selection of the teacher name in a drop down box | New Users to Excel | |||
Why can't I use XML in the Student and Teacher Edition? | New Users to Excel | |||
Why can't I use XML in the Student and Teacher Edition? | Setting up and Configuration of Excel | |||
Teacher question | New Users to Excel | |||
School teacher | Excel Worksheet Functions |