How to use excel table to reconcile

(1) Insert the function IF in the cell that needs to be reconciled (such as F3), and in the "IF Function" dialog box that appears Enter "D3＝B3" in the 'logical_test' input box, enter "Same" in the "Value_if_true" input box, enter "Different" in the "Value_if_false" input box, and press the "OK" button of the unit;

(2) Set "Conditional Formatting" in the reconciliation cell (for example, F3:F13), click the "Format" button, and set the "Format" to the font color to "red" and the pattern fill color is "yellow", thus realizing the reconciliation. How to reconcile two excel tables with different data?

If the design format of the two tables is exactly the same, I recommend creating a third table. Define B2=Sheet1!B2=Sheet2!B2 (for example), and then use the drag and drop function to subtract all the cells in the third sheet that need to be reconciled. If the result is 0, it means the data is the same. If it is not 0, check that one again. Data, if there is a lot of data that needs to be reconciled, and it is not easy to find non-0 cells, just write a statistical formula at the end of each column (or row, choose less): =countif (B2: B100, 0), so that you can see The total number of the last row is enough. How to reconcile in excel

Take a look at the vlookup function. How to use excel2007 to create a table

You should know how to express the question completely on Baidu. Question, it is helpful for friends to understand and give advice!

According to the purpose of the data, determine the row and column frame, and then enter the data.

I don’t know what you asked this question. How to answer you? Just type it, and enter the date, class and course one by one.

How to use VBA to generate sales statements in Excel? Please give me some advice

Full automation is more complicated and requires the use of VBA

And the complexity is related to your first table

If you have partially sorted Table 1 in advance The processing of classes should be relatively simple

If it is a completely messed up table, it will probably be more complicated. How does Huatang reconcile the accounts?

From what perspective do you view it?

For customer reconciliation, if the payment is by credit card (bank), you can go to the bank to print the statement.

For store employees, the reconciliation is to reconcile the entry receipt. How to check the reconciliation date

1. The statement dates of different banks are different

2. Your card is recorded on the statement you receive every month. Important dates such as billing dates and due repayment dates.

3. You can also call the customer service hotline of your credit card to check your billing date. How to use the query function in Microsoft Excel worksheet

Query and replace: press the shortcut key CTRL F

Positioning (pictures, formulas, comments, etc.): press the shortcut key F5. How to use the Excel table to Are employees paid?

First create an EXCEL basic information table, such as job number, name, salary, bonus, subsidy, etc. (financial department data can be used), and then insert any column after the name (such as sick leave, personal leave, lateness, etc. ). In the last few columns of the table, mark the corresponding salary deductions, bonus deductions, subsidy deductions and marks, etc., as shown in the attached table in the article.

Now we use the IF function to design the salary calculation table.

Assumptions:

Salary: If the number of sick leave days in the month is less than 6 days, no salary will be deducted; if the number of sick leave days is more than 5 days, 20% of the monthly salary will be deducted. If the number of personal leave days in the month is less than 6 days, no salary will be deducted; if the number of personal leave days is more than 5 days, 30% of the monthly salary will be deducted.

Bonus: If the total number of sick and personal leave days in the month exceeds 10 days, the bonus for that month will be suspended. If the total is less than 10 days of sick leave, a bonus of RMB 10 will be deducted for each day; a bonus of RMB 20 will be deducted for each day of personal leave; a bonus of RMB 5 will be deducted for each late arrival.

Subsidy: If the sick leave is less than 16 days in the month, 1/23 of the subsidy will be deducted every day, and it will be suspended if it exceeds 15 days. If the personal leave is less than 11 days in a month, 1/23 of the subsidy will be deducted every day, and if the personal leave is more than 10 days, it will be suspended.

Tabulation process:

1. Click I2, open the paste function (fx), select the logical IF, and click OK. Fill in C2lt; 6 in the Logical_test position; fill in 0 in the Value_if_true position; fill in F2*20% in the Value_if_false position and press Enter.

2. Stop the cursor on the right side of the formula bar, open Paste Function (fx), select logical IF, but fill in D2lt; 6, 0, F2*30% respectively, and press Enter .

3. Click J2, repeat step 1, fill in C2+D2gt; 10, G2, C2*1D2*20, and press Enter.

4. Repeat step 2, fill in E2gt; 0, E2*5, 0, and press Enter.

5. Click K2, repeat step 1, fill in C2lt; 16, C2*H2*1/23, H2.

6. Repeat step 2, respectively Fill in D2lt;11, D2*H2*1/23, H2, and press Enter.

7. Click L2, repeat step 1, fill in I2+J2+K2gt; 0, 1, 0.

Finally, use the auto-fill handle in columns I, J, K, and L Fill in as needed. In the future, you only need to enter the attendance records in columns C, D, and E every month, then use automatic filtering in column L, select 1 and take a look. What is the result? Are you satisfied? Of course, those who have received a salary increase must remember to update.