If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ASSIGN NUMBER SCORES TO LETTER GRADES
I want to code scores "E" and "S" as passing and "U" as not passing. Scores
are in a table of months arranged horizontally. Suggestions are welcome. DOUG |
#2
|
|||
|
|||
ASSIGN NUMBER SCORES TO LETTER GRADES
is it you look for?
=if(A1="U","Failed","Passing") "DOUG ECKERT" wrote: I want to code scores "E" and "S" as passing and "U" as not passing. Scores are in a table of months arranged horizontally. Suggestions are welcome. DOUG |
#3
|
|||
|
|||
ASSIGN NUMBER SCORES TO LETTER GRADES
'Close. But, I want to tell Excel to evaluate a range of cells using that
formula. When I try, I receive an error. Utimately, I need to average all of the scores in the range, based on the number value assigned to each letter. I could assign a number value to "E" (Excellent), "S" (Satisfactory) and "U" (Unsatisfactory). But, it would be better to just say the "E" and "S" cells were passing scores and the "U" cells were failing scores. Then, I could count either the passing or failing scores and obtain a percentage of passing scores - (the goal of the exercise). But, first I must persuade the formula to work on a horizontal range of cells. DOUG "Andri" wrote: is it you look for? =if(A1="U","Failed","Passing") "DOUG ECKERT" wrote: I want to code scores "E" and "S" as passing and "U" as not passing. Scores are in a table of months arranged horizontally. Suggestions are welcome. DOUG |
#4
|
|||
|
|||
ASSIGN NUMBER SCORES TO LETTER GRADES
Andri: Here is what worked. It is so simple. I spun my wheels for too long
on this one. =COUNTIF(B6:M6,"U")/((ROWS(B6:M6))*COLUMNS(B6:M6)) Thanks. DOUG "DOUG ECKERT" wrote: 'Close. But, I want to tell Excel to evaluate a range of cells using that formula. When I try, I receive an error. Utimately, I need to average all of the scores in the range, based on the number value assigned to each letter. I could assign a number value to "E" (Excellent), "S" (Satisfactory) and "U" (Unsatisfactory). But, it would be better to just say the "E" and "S" cells were passing scores and the "U" cells were failing scores. Then, I could count either the passing or failing scores and obtain a percentage of passing scores - (the goal of the exercise). But, first I must persuade the formula to work on a horizontal range of cells. DOUG "Andri" wrote: is it you look for? =if(A1="U","Failed","Passing") "DOUG ECKERT" wrote: I want to code scores "E" and "S" as passing and "U" as not passing. Scores are in a table of months arranged horizontally. Suggestions are welcome. DOUG |
#5
|
|||
|
|||
ASSIGN NUMBER SCORES TO LETTER GRADES
On Sep 15, 3:15*pm, DOUG ECKERT
wrote: Andri: *Here is what worked. *It is so simple. *I spun my wheels for too long on this one. =COUNTIF(B6:M6,"U")/((ROWS(B6:M6))*COLUMNS(B6:M6)) Thanks. DOUG "DOUG ECKERT" wrote: 'Close. *But, I want to tell Excel to evaluate a range of cells using that formula. *When *I try, I receive an error. *Utimately, I need to average all of the scores in the range, based on the number value assigned to each letter. *I could assign a number value to "E" (Excellent), "S" (Satisfactory) and "U" (Unsatisfactory). *But, it would be better to just say the "E" and "S" cells were passing scores and the "U" cells were failing scores. *Then, I could count either the passing or failing scores and obtain a percentage of passing scores - (the goal of the exercise). *But, first I must persuade the formula to work on a horizontal range of cells. DOUG "Andri" wrote: is it you look for? =if(A1="U","Failed","Passing") "DOUG ECKERT" wrote: I want to code scores "E" and "S" as *passing and "U" as not passing. *Scores are in a table of months arranged horizontally. *Suggestions are welcome. DOUG- Hide quoted text - - Show quoted text - Can also use somethng like, =SUM(COUNTIF(B2:M2,{"E","S"}))/COUNTA(B2:M2) |
Thread Tools | |
Display Modes | |
|
|