WebHQ

The Headquarters Of Web

Facebook Twitter RSS Feed Email

How to Make a Salary Sheet - Excel Tutorial

Published on: at 12:49 PM | Posted By:
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.

Salary Sheet Screenshot

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

Get Latest Updates

Blog Archive

Total Pageviews