Mr. Jyothis, a Plus two commerce student, entered the following details in a worksheet of LibreOffice Calc.
|
A |
B |
C |
D |
E |
F |
G |
H |
1 |
Aralam Associates
Pay roll - June 2006 |
2 |
Name |
BP |
DA (15% of BP) |
HRA (5% of BP) |
HTA (2% of BP) |
Gross pay |
PF (6% of GP) |
Net Pay |
3 |
Baby |
14000 |
|
|
|
|
|
|
4 |
Shibu |
12000 |
|
|
|
|
|
|
5 |
Rehman |
10000 |
|
|
|
|
|
|
6 |
Shija |
8000 |
|
|
|
|
|
|
7 |
Seema |
6000 |
|
|
|
|
|
|
Write the command to calculate Net Salary