What are the commonly used formulas for calculating wages in Excel?

sum: sum; count: count; vlookup：

Check the table, check the type of work, wage unit price; sumif: conditional sum; countif: Condition counting and so on to be honest, now a little bit not familiar with these formulas, after all, tools make people fall, but I really want to fall ah before the end of the month often tortured by these formulas until dawn, no longer want to see, and then the company more and more people, really can't stand it, especially a sales department attendance and performance is too miscellaneous, a said that the salary is big, and then "forced" the boss to use the salary, now the salary basically does not occupy too much time for our personnel, It's nice to have more time to build corporate culture and optimize various processes

Specifically, depending on what items or requirements you have in your salary list, let's say a few that are generally used:

Keep decimal places: round(,) roundup(,) rounddown(,).

Summation: sum().

When summing up a summary table or category: sumif().

The most commonly used is this: vlookup().

Also used: subtotal(103,)if() left() find()

Because our payroll is implemented in a table, these functions are basically nested.

1. First open Excel**.

2. Then calculate the subtotal of the deduction: enter the Qisui formula =sum(g5:k5) in cell L5, and then pull down to fill.

3. Then enter the formula =sum(c5:f5)-l5 in cell m5 to calculate the payable salary, and then pull it down.

4. Subtract individual income tax from the salary that should be paid.

To get the actual salary, enter the formula =m5-n5 in the o5 cell to calculate the actual salary, and then pull it down.

5. In this way, the salary list will be made Sun Zao.

Hello, 1. Open the salary table with the data filled. Select the cell that needs to be calculated, and click "Insert Function" above the bar

2. In the pop-up window, select the summing function: sum, and click OK.

3. After confirming again, return to the excel document, and you can see that the cell you just selected has the calculation result.

4. For other cells that need to be calculated, you can directly copy the cell to bury the auspicious grid, and the prompt "copy formula" appears.

5. Custom calculations. Just now is a direct sum, let's take a look at how to customize the friendly way calculation. It's just that some can't be directly simple sums and so on. When you need to add or subtract, you need to customize the calculation formula.

6. Select the cell that needs to calculate the result of liquid completion, click on the bar, enter the equal sign "=" to click on the cell that needs to be calculated, and then enter the operation symbol, such as "+", etc. Then click on the second cell, and so on. Finally, enter the formula of the return result, and then get the calculation result.

7. In the same way, copy the calculated cells to other required cells. The formula is simply copied in the past.

Salary calculation method with excel formula:

1. Create and open a new excel**, and output the name and other relevant information spine wheel.

2. Enter the formula for calculating the final wage amount, click Auto Sum, and enter the corresponding summing formula.

3. For example, the final amount of their salary is (hourly wage * working hours + bonus) room rent.

4. Enter the corresponding summation formula.

5. Pretend to be a wild omen and then pull down the small black triangle in the lower right corner of the result.

In Excel 2007,If you set the formula according to the topic,"=if(c2<=b2,a2 day(eomonth(today(),0))*c2,a2)", butThe results obtained are different from those given by the question (Based on the total number of days in the month = 31 days, 2400 31 * 29 =.

If you want to get the same result given by the questionThe formula should be "=if(c2>=b2,a2,a2 day(eomonth(today(),0))*c2)".i.e. "when the number of days of attendance."Number of days of full attendance, payable salary = basic salary.

Total number of days in the month * number of days of attendance; When the number of days of attendanceNumber of days of full attendance, payable salary = basic salary.

In order to round the "wages payable", there are two ways: Divine Fighting

Format cells to round up. That is, the cell is formatted as a number with "decimal zero" (in order to make the result appear with a section number, the format in "Custom" is specially used

Function rounding. Use the function "roundup" to change the formula with the modified title to ".=if(c2>=b2,a2,roundup(a2/day(eomonth(today(),0))*c2,0))

In order for Payroll Payable to have a section number, additional cells must be set.

The result of following the formula is shown in the figure below:

Diagram of the formula Knot Shen Hu Guo You Xiaoxiang.

Procedure Method.

1.Create and open a new excel and output relevant information such as name (name, working hours, hourly salary, bonus, final salary).

2.Enter the formula below to calculate the final amount of wages to be paid in the state.

3.Enter the formula "= working hours * hourly salary + bonus" in the final salary cell.

4.Based on the above steps, the salary can be calculated.

Precautions Pants are clearly summarized.

1.Click Auto Sum and enter the corresponding summation formula. 2.Enter the formula "= working hours * hourly salary + bonus" in the salary cell.

First: how to calculate wages, you need to have an algorithm first, and then you can express it in excel, without a combination of kernels to explain the calculation method, excel can't calculate the formula.

Second: Take the daily wage of 150 yuan as an example to calculate the salary, then you can count the number of working days, and then calculate the salary of Zheng Liang, such as the common evaluation table to calculate the salary, <>

Count how many people are in each cell.

Cell 1 person, 0 shirt chop Chunton number (,).

Cell 2 people, 1 ton (, ).

Cell 3 people, 2 ton (, ).

That is, the number of tons (,) is calculated and then +1, which is the number of people.

With find or countif+wildcard, you can only determine whether the cell contains the ton number (,), and there is no way to directly calculate the number of ton numbers (,).

Here, the indirect calculation method can be adopted. By substituting the or netten (,) with a function, calculate how many characters are reduced, so as to obtain the number of tons (,).

Then enter =abc in the right box of any formula with an equation, and press enter.