How to pay the social security payroll?

According to what I said below, you can pay with the picture effect! 1. Create an Excel file and store the original data of the payroll in sheet 1, assuming there are n columns. The first line is the salary item, and from the second line is everyone's salary. 2. In sheet2, let's set the payroll. According to the actual situation, the payslip consists of three lines, one corresponding to salary items, one corresponding to salary data of one person, and then a blank line, which is convenient for cutting. These three lines make up a payroll. When the line number is divided by 3, the salary item is on the line with the remainder 1; A blank line is on a line whose line number is divisible by 3. The above two lines are not difficult to set. The key is the salary data line, which involves the corresponding relationship between the data in sheet 1 and sheet2. After analysis, it is not difficult to see that "data line in sheet 1 = int ((data line 4 in sheet 2)/3)". 3. So we enter the formula "= if (mod (row (), 3) = 0", "if (mod (row (), 3) = 1, sheet 1! A 1 USD, index (Sheet 1! $A:$N, INT((ROW() 4)/3), COLUMN ()). After confirmation, select cell A 1 and place the mouse in the lower right corner of cell A 1. When the mouse changes to "",drag the mouse to the right to automatically fill in N columns, so that the first row of the payroll will come out. Select A 1: N 1, and place the mouse in the lower right corner of the cell N 1. When the mouse changes to ""again, drag the mouse down to automatically fill in the last row of data, and all payslips will be completed. Remember the formulas "= if (mod (row (), 3) = 0", "if (mod (row (), 3) = 1, sheet 1! A 1 USD, index (Sheet 1! $A:$N, INT((ROW() 4)/3), COLUMN ()) "The quotation marks should be removed!