Microsoft Excel: Calculation of Bill and Mark Sheet By MsExcel

Microsoft Excel: Calculation of Bill and Mark Sheet By MsExcel: Total Marks Sheet FORMULAS for total marks sheet:                             Sum              à =sum(c2:h2) Subtraction à =(c2-...

Calculation of Bill and Mark Sheet By MsExcel

Total Marks Sheet

FORMULAS for total marks sheet:                            
Sum              à=sum(c2:h2)
Subtractionà=(c2-h2)
Multiply      à=(c2*h2)
Division       à=(c2/h2)
Percentageà=(i2/j2)*100
Grade          à=IF(K2>=80,”A”,IF(K2>=65,”B”,IF(K2>=50,”C”,IF(K2>=40,”D”,”F”))))
For Pass,Failà=if(k2>=60,”pass”,”fail”)
For discount feeà=IF(K2>=80,($Q$2-($Q$2*20%)),IF(K2>=65,($Q$2-($Q$2*10%)),IF(K2>=50,($Q$2-($Q$2*5%)),$Q$2)))
For Average       à=IF(AVERAGE(C3:H3)>80,($K$2-2000),IF(AVERAGE(C3:H3)>=65,($K$2-1500),K$2))
Max.Numberà=MAX(C2:H2)
Min.Numberà=MIN(C2:H2)
Max.Round-offà=ROUND(K2,3)
Min.Round-offà =ROUND(K2,1)

Calculation of Bill

FORMULAS:

For Total Amount à=IF(C2<=100,(C2*6),IF(C2<=200,(100*6)+((C2-100)*8),(100*6)+(100*8)+((C2-200)+10)))
For Surcharge        à=IF(C2<=100,(D2*0),IF(C2<=200,(D2*2%),(D2*5%)))
For Taxà=IF(C2<=100,(D2*0),IF(C2<=200,(D2*5%),(D2*8%)))
For Total Bill          à=SUM(D2:E2:F2)