How to calculate salary in excel 2007

First Type All Of Your Data Like This Picture. Emp ID, Emp Name,
Basic Salary, Ta, Da, Hra, Pf, Lic, Net Sal.


Then Type The Formula Strating " = " Symbol.
TA = BASIC SAL*PERCENTAGE/100
DA= BASIC SAL*PERCENTAGE/100
HRA= BASIC SAL*PERCENTAGE/100
GROSS SAL = TA + DA + HRA
PF= GROSS SAL*PERCENTAGE/100
NET SAL = GROSS SAL -( PF + LIC)