Working on Employee Table in Ms-Excel

In this video we can discuss about Working on Employee. Find the Employee Per day salary & Net Salary.

Ex Problem:-

Working on Employee Table:- 

Take Employee Number, Name, Salary ,Total Working days, Total Present Days, then find Per day salary, Net Salary ? 

Employee  no = 120

Employee name = Rajesh

Salary = 12000

Total working days = 30

Total present days = 24

Find:-

Per day salary = salary/total working days

Net salary       = per day salary * total present days