Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Worksheet IF Functions
How do I create a function that will give letter grades for students within
a certain range. For example, John Doe has 89.6 and my grading scale is 90 and above A, 85-89 is an A-, 80-84 is a B+. The percentages that have been calculated are in cell J5 and I would like the answers in K5. Thanks in advance |
#2
|
|||
|
|||
Worksheet IF Functions
=LOOKUP(J5,{0,"F";0.4,"E-";0.45,"E";0.5,"D-";0.55,"D";0.6,"C-";0.65,"C";0.7,
"B-";0.75,"B";0.8,"B+";0.85,"A-";0.9,"A"}) -- HTH RP (remove nothere from the email address if mailing direct) "AlvinAlvin" wrote in message lkaboutsoftware.com... How do I create a function that will give letter grades for students within a certain range. For example, John Doe has 89.6 and my grading scale is 90 and above A, 85-89 is an A-, 80-84 is a B+. The percentages that have been calculated are in cell J5 and I would like the answers in K5. Thanks in advance |
#3
|
|||
|
|||
Worksheet IF Functions
Create a table that shows your ranges and use a vlookup to make the assignment.
Ex: in AA1:AA4 enter the breakpoints: 0,80,85,90 and in AB1:AB4 the corresponding grades: F,B+,A-,A (of course you'll complete the entire table). Then in k5: =vlookup(j5,$AA1:$AB4,2,true) (chage the ending cell $AB$4 to point to the end of your completed table) --Bruce "AlvinAlvin" wrote: How do I create a function that will give letter grades for students within a certain range. For example, John Doe has 89.6 and my grading scale is 90 and above A, 85-89 is an A-, 80-84 is a B+. The percentages that have been calculated are in cell J5 and I would like the answers in K5. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get the complete list Excel Worksheet Functions | Excel Worksheet Functions | |||
Worksheet functions | New Users to Excel | |||
Worksheet Memory hog | Excel Discussion (Misc queries) | |||
Worksheet functions - Ajit11021225 | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |