Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula involving a letter that has to have a numeric value
I am trying to make a chart that I can use to figure out grade point average
(4.0 scale). I will enter the # of credits taken by the student, and then enter the grade A=4, B=3, C=2, D=1. The credits will be multiplied by the grade value. Is this possible I |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula involving a letter that has to have a numeric value
If Credits are in A2, Grade (A,B,C or D) in B2 then in C2:
=A5*(69-CODE(UPPER(B5))) UPPER allows for entry of lower case codes. HTH "Don" wrote: I am trying to make a chart that I can use to figure out grade point average (4.0 scale). I will enter the # of credits taken by the student, and then enter the grade A=4, B=3, C=2, D=1. The credits will be multiplied by the grade value. Is this possible I |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula involving a letter that has to have a numeric value
oops ..should be ...
=A2*(69-CODE(UPPER(B2))) "Toppers" wrote: If Credits are in A2, Grade (A,B,C or D) in B2 then in C2: =A5*(69-CODE(UPPER(B5))) UPPER allows for entry of lower case codes. HTH "Don" wrote: I am trying to make a chart that I can use to figure out grade point average (4.0 scale). I will enter the # of credits taken by the student, and then enter the grade A=4, B=3, C=2, D=1. The credits will be multiplied by the grade value. Is this possible I |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula involving a letter that has to have a numeric value
Hi!
One way: A1 = credits B1 = some letter grade =A1*IF(B1="",0,LOOKUP(B1,{"A","B","C","D"},{4,3,2, 1})) Biff "Don" wrote in message ... I am trying to make a chart that I can use to figure out grade point average (4.0 scale). I will enter the # of credits taken by the student, and then enter the grade A=4, B=3, C=2, D=1. The credits will be multiplied by the grade value. Is this possible I |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula involving a letter that has to have a numeric value
I'm not sure what you are asking. Do you want to convert the grade
letters to a number that can then be used to multiply the credits? If so, try this: =SEARCH(A1,"DCBA") this will return 4 if "A" is in A1, down to 1 for "D". As an alternative, the following will do exactly the same: =69-CODE(A1) Hope this helps. Pete Don wrote: I am trying to make a chart that I can use to figure out grade point average (4.0 scale). I will enter the # of credits taken by the student, and then enter the grade A=4, B=3, C=2, D=1. The credits will be multiplied by the grade value. Is this possible I |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
Find and Count Frequency of Numeric Value in Non-Contiguous Rows | Excel Worksheet Functions | |||
Match 3 Criteria and Return Lowest Numeric Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions |