Sum
This function is use for Addition
Sytex: =sum(Select Range)
Function for Addition
Sno Name Gender Post B/Salary Allownce
1 Ali Male Doctor 1000 300
2 Imad Male Engineer 1200 350
3 Adil Male Clerk 1400 400
4 Kashif Male Teacher 1600 450
5 Fawad Male Driver 1800 500
6 Nailla Female Teacher 2000 550
7 Fazilat Female Engineer 2200 600
Total 11200 3150
Formula For Subtraction
Sno Name Gender Class Total Fee Paid Fee
1 Ali Male DIT 1200 750
2 Imad Male DIT 1200 500
3 Adil Male DIT 1200 820
4 Kashif Male DBA 1000 1500
5 Fawad Male DBA 1000 600
6 Nailla Female DBA 800 150
7 Fazilat Female DEL 800 2000
Sno Name Gender Post SALARY Perday
1 Ali Male Doctor 1500.00 50.00
2 Imad Male Engineer 1200.00 40.00
3 Adil Male Clerk 1400.00 46.67
4 Kashif Male Teacher 1600.00 53.33
5 Fawad Male Driver 1800.00 60.00
6 Nailla Female Teacher 2000.00 66.67
7 Fazilat Female Engineer 2200.00 73.33
Sno Name Gender Post SALARY Absenties Cutting
1 Ali Male Doctor 1500.00 2 100
2 Imad Male Engineer 1200.00 0 0
3 Adil Male Clerk 1400.00 4 186.66667
4 Kashif Male Teacher 1600.00 0 0
5 Fawad Male Driver 1800.00 5 300
6 Nailla Female Teacher 2000.00 0 0
7 Fazilat Female Engineer 2200.00 6 440
[Link] =salaary-salary*absenties/30
Cutting Formula =salary/30*Absenties
Name Gender Post SALARY Zakat
Ali Male Doctor 100000.00 2500
Imad Male Engineer 1200.00 30
Adil Male Clerk 1400.00 35
Kashif Male Teacher 1600.00 40
Fawad Male Driver 1800.00 45
Nailla Female Teacher 2000.00 50
Fazilat Female Engineer 2200.00 55
Zakat Formula =Rupees*2.5/100
Item Qty Type Unit Price Commission [Link]
Mouse 120 Dell 150 150 17850
Keyboard 200 IBM 200 0 40000
Monitor 10 DELL 1500 200 14800
USB 500 Kingston 550 0 275000
Printer 5 HP 5000 300 24700
Mouse 130 Sony 250 0 32500
Keyboard 400 HP 300 0 120000
Monitor 40 Panasonic 2000 500 79500
Item Price =Qty*Unit Price-Comm
Total
1300
1550 +
1800
2050
2300
2550
2800
14350 Total 28700
Balance
450
700
380
500
400
650
1200
Weekly Hourly
375.00 6.25
300.00 5.00
350.00 5.83
400.00 6.67
450.00 7.50
500.00 8.33
550.00 9.17
[Link]
1400
1200
1213.33333
1600
1500
2000
1760
senties/30
2.5