IT Help Desk > Use of PC

Microsoft Excel: Learning Tutorial

<< < (6/12) > >>

ashiqbest012:


For soft copy Click here

ashiqbest012:
Formula of Weekly Wage

WEEKLY PAY
=sum (Hour Cell Address*Rate Cell Address)        =SUM(B16*C16)

OVERTIME PAY
 =IF(B16>40,(B16-40)*C16*2,0)

GROSS PAY
=Sum(weekly pay cell address + Overtime Pay Cell Address)           =SUM(D16+E16)

TAX
=IF(F16<=2000,F16*$B$6,IF(AND(F16>2001,F16<=3000),F16*$B$7,IF(AND(F16>3001,F16<=4500),F16*$B$8,IF(AND(F16>4501,F16<=6000),F16*$B$9,IF(AND(F16>6001,F16<=7500),F16*$B$10,IF(AND(F16>7501,F16<=9000),F16*$B$11,IF(F16>9001,F16*$B$12)))))))

TOTAL
=sum(Gross Pay Cell Address-Tax Pay Cell Address)         =SUM(F16-G16)

Thank you

ashiqbest012:




Click here for soft copy

ashiqbest012:
Topic name: ::Student Grade Sheet::
Number distribution
Class attendance =7
Quiz                   =10
Assignment         =5
Mid term             =20
Presentation        =5
Lab                     =13
Final                    =40

Total                 =100

(N.B: "IF" function can't be used more than 8 times.)
So, I have created the number of 2 Grade column and the number of 2 GPA column.

Suppose, the course instructor has taken 4 quiz. So, I have averaged 4 quiz and continue it. 

ashiqbest012:
Functions of Student Grade Sheet

Quiz
=SUM(D17:G17)/4

Total
=SUM(C17+H17+I17+J17+K17+L17+M17)

Grade-1
=IF(N17>=80,"A+",IF(N17>=75,"A",IF(N17>=70,"A-",IF(N17>=65,"B+",IF(N17>=60,"B",IF(N17>=55,"B-",IF(N17>=50,"C+",IF(N17>=45,"C","Grade-2"))))))))

Grade-2
=IF(N17<=39,"F",IF(N17<=44,"D","N/A"))

G.P.A-1
=IF(N17>=80,"4.00",IF(N17>=75,"3.75",IF(N17>=70,"3.50",IF(N17>=65,"3.25",IF(N17>=60,"3.00",IF(N17>=55,"2.75",IF(N17>=50,"2.5",IF(N17>=45,"2.25","GPA-2"))))))))

G.P.A-2
=IF(N17<=39,"0",IF(N17<=44,"2","N/A"))

Prepared by Ashiq Hossain

Navigation

[0] Message Index

[#] Next page

[*] Previous page