What is the accurate excel calculation of salary?

Asked By Deborah Hall 10 points N/A Posted on - 01/21/2013

Hi,

What is the accurate excel calculation of salary? I need a formula or a step by step process on how to come up total salary using Microsoft excel software application. An instruction is very relevant, all I need is to follow it properly. This is for my company. I need your help.

Thank you.
Regards,

Deborah Hall.

• Status: Open
• Question Views: 714
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Williamson Mellisa 5 points N/A #175393

What is the accurate excel calculation of salary?

There are a lot of video tutorials for excel calculations, step by step. With this tutorials you can easily calculate total salary. I will give you some links with video tutorials, so you can choose what most fits at your requirements.

This tutorial will calculate salary based on relevant years worked:

Here you can calculate gross pay for week from time worked:

If you want something simple, calculating total salary for month based on the time worked:

Open a new excel document and make tables like this.

Column under January you fill with names and surnames of employees. Row from 1 to 31 is for how many hours they worked each day. In AH2 column set the function =SUM(C2:AG2) to calculate how many hours each employer worked. In AI column set value of their payment: 5 (if is 5 euros per hour). The last column is AJ and there set the function =AH2*AI2.

Hope you will find one of this tip useful.

About Williamson Mellisa

Questions
2

Answers
201

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 01/24/2013
• Question Category: MS Excel