Scribd
Upload
27 views2 pages

IT Application Microsoft Excel Basic Formula

The document shows the results of a quiz with 3 questions for multiple students. It includes the scores for each question, total score, grade percentage, and remarks. Formulas are provided to automatically generate the remarks ("Passed", "Failed", etc.) based on the grade percentage. The formulas are then expanded to include additional remark categories like "Condition", "Poor", "Average", and "Excellent" as the grade thresholds are adjusted.

Uploaded by

Angel Tolentino
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
27 views2 pages

IT Application Microsoft Excel Basic Formula

The document shows the results of a quiz with 3 questions for multiple students. It includes the scores for each question, total score, grade percentage, and remarks. Formulas are provided to automatically generate the remarks ("Passed", "Failed", etc.) based on the grade percentage. The formulas are then expanded to include additional remark categories like "Condition", "Poor", "Average", and "Excellent" as the grade thresholds are adjusted.

Uploaded by

Angel Tolentino
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

A B C D E F

1 QUIZ
2 100%
3 Q1 Q2 Q3 TOTAL GRADE REMARKS
4 50 50 100 200
5
6 50 50 100 200 100 PASSED
7 25 25 50 100 50 FAILED

FORMULA:

=IF(E6>=75, "PASSED", "FAILED")

=IF(E7>=75, "PASSED", "FAILED")

FAILED → 0 – 74
A B C D E F
1 QUIZ CONDITION → 50 - 75
2 100%
PASSED → 76 – 100
3 Q1 Q2 Q3 TOTAL GRADE REMARKS
4 50 50 100 200
5
6 50 50 100 200 100 PASSED
7 25 25 50 100 50 CONDITION
8 15 10 25 50 25 FAILED

FORMULA:

=IF(AND(E6>=50,E6<=75),"CONDITION",IF(E6>=76,"PASSED","FAILED"))

=IF(AND(E7>=50,E7<=75),"CONDITION",IF(E7>=76,"PASSED","FAILED"))

=IF(AND(E8>=50,E8<=75),"CONDITION",IF(E8>=76,"PASSED","FAILED"))

FAILED → 0 – 74
A B C D E F
1 QUIZ POOR → 75 - 80
2 100%
AVERAGE → 81 - 85
3 Q1 Q2 Q3 TOTAL GRADE REMARKS
4 50 50 100 200 EXCELLENT → 86 - 100
5
6 50 50 100 200 100 EXCELLENT
7 35 40 95 170 85 AVERAGE
8 35 35 90 160 80 POOR
9 34 34 80 148 74 FAILED

FORMULA:
=IF(AND(E6>=75,E6<=80),"POOR",IF(AND(E6>=81,E6<=85),"AVERAGE",IF(E6>=86,"EXCELLENT","FAILED")))
=IF(AND(E7>=75,E7<=80),"POOR",IF(AND(E7>=81,E7<=85),"AVERAGE",IF(E7>=86,"EXCELLENT","FAILED")))
=IF(AND(E8>=75,E8<=80),"POOR",IF(AND(E8>=81,E8<=85),"AVERAGE",IF(E8>=86,"EXCELLENT","FAILED")))
=IF(AND(E9>=75,E9<=80),"POOR",IF(AND(E9>=81,E9<=85),"AVERAGE",IF(E9>=86,"EXCELLENT","FAILED")))
[Type a quote from the document or the
summary of an interesting point. You can
position the text box anywhere in the
0
document. Use the Drawing Tools tab to
change the formatting of the pull quote text
box.]

You might also like