Saturday, August 1, 2015
How to Make a Salary Sheet - Excel Tutorial
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment