HOW TO
FIND DIVISION GRADE OF DATA [SCORES] IN EXCEL
Procedures and concepts to
consider:
- Have a data into cells [that are to be added to get total points]
- Identify the column name and row name to be used to find Division and to Comment
Example
Columns
[B, C, D, E, F, G and H]
and Row
[2]
…....... [In horizontal]
- Identify the Cell of data that are to be considered [use Total points cell ''I2'']
DIVISION
- If I = 7- 17; II = 18 – 21; III = 23 – 25; IV = 26 – 33 and FLD = 34 – 35.
- Syntax: '' = IF(I2<=6;”E*”;IF(I2<=17;”I”;IF(I2<=21;”II”;IF(I2<=25;”III”;IF(I2<=33;”IV”;IF(I2<=35;”FLD”;”FLD”)))))) ''
COMMENTS
- If 7- 17 = Excellent; 18 – 21 = Very Good; 23 – 25 = Good; 26 – 33 = Satisfactory and 34 – 35 = Fail.
- Syntax: '' = IF(I2<=6;”Incomplete”;IF(I2<=17;”Excellent”;IF(I2<=21;”Very Good”;IF(I2<=25;”Good”;IF(I2<=33;”Satisfactory”;IF(I2<=35;”Fail”;”Fail”)))))) ''
NOTE:
In writing formula, use semi-colon [;] if you use OpenOffice
otherwise use comma only [,] if you use Microsoft office
OTHER EXCEL FUNCTIONS [SYNTANX]
No comments:
Post a Comment