Job Recruitment Website - Social security inquiry - How to do the salary table with five insurances and one gold?
How to do the salary table with five insurances and one gold?
1. Open excel and fill in the related information of total salary.
2. Select cell F3 and enter "= IF(E3 & gt；; 22, E3* 10), press enter to complete the attendance award setting, and then drag and drop fill handle to set attendance awards for all employees.
3. Select cell G3. Enter "=(C3+D3+F3)*5%", press enter to complete social security setting, and then drag fill handle to set social security for all employees.
- Previous article:Kunshan social security landing website
- Next article:Can I get a refund for my social security card?
- Related articles
- Can Beijing's five insurances and one gold be transferred back to your hometown?
- Shangrao County Social Security Expense 20 19
- Buying a house in Wuhan and paying social security
- 20 19 what is the proportion of social security contributions in Vietnam?
- How many years does social security need?
- Is maternity insurance reimbursed by the unit or by the Social Security Bureau?
- What should I do if I resign from my unit?
- Activation of Social Security Card of Rural Credit Cooperatives
- Standard of social security pension in Henan Province
- How much does Rugao social security individual pay a month?