Example
Mark - sheet
| Name | English | Math | Science | Nepali | Account | Total | Percent | Result | Division | Remarks | Student1 |
| Student2 | ||||||||||
| Student3 | ||||||||||
| Student4 | ||||||||||
| Student5 | ||||||||||
| Student6 | ||||||||||
| Student7 | ||||||||||
| Student8 | ||||||||||
| Student9 | ||||||||||
| Student10 |
Formulas
Total: =Sum(English:Account)
Percent: =total/no. Of subjects
Condition for result:
All subjects>=32 Pass
Otherwise Fail
=IF(AND(English>=32,Math>=32,Science>=32,Nepali>=32,Account>=32), "Pass","Fail")
Condition for division:
Percent>=60 First
Percent<60,Percent>=50 Second
Percent<50,Percent>=40 Third
Otherwise ***
=if(and(Percent>=60), "First" , if(and(Percent<60,Percent>=50), "Second" , if(and(Percent<50,Percent>=40),"Third","***")))
Condition for Remarks:
Percent>=80
A grade
Percent<80,Percent>=60
B grade
Otherwise
C grade
Try this one yourself!