We may need a selary sheet in various ways.
We are going to make a salary sheet today.
Imagine that 8 hours of working is recomended in a factory. And selary is 50 Dolar per hour.
We are going to make a salary sheet today.
Imagine that 8 hours of working is recomended in a factory. And selary is 50 Dolar per hour.
Conditions:
Main Selary 400 Dolar. 8 Hours everyday.
Overtime 75 Dolar per Hour
Solution:
Select C2 Cell.
Write=B2-8
Click enter key.
Select D2 Cell.
Write=((B2-C2)*50+C2*75)
Click enter key.
You got the result.
No comments On "How to Make a Salary Sheet - Excel Tutorial"
Post a Comment