The security deposit required to be paid is calculated according to the following formula:
(1) The proportion of the number of disabled people who should be employed = the number of employees of the employer in the previous year × 1.5%;
(2) Amount payable = (number of persons with disabilities who should be employed in proportion - number of persons with disabilities actually employed by the employer in the previous year) × average annual salary of the employer's active employees in the previous year;
(3) The actual amount payable = the amount payable - the amount of reduction or exemption.
1: How to sum text
In some relatively non-standard tables, there will be a problem of mixing text and numbers, which makes summation difficult.
Enter the formula in cell C12: =SUM(--SUBSTITUTE(C2:C11,"元",""))
Press the key combination to complete.
2: Sum of multiple worksheets
For example, some tables have performance statistics for several months, and Zhang Cheng’s position in each worksheet is the same. Find Zhang Cheng’s commission statistics from a certain month to a certain month.
Enter the formula in cell F5: =SUM('January:April'!C2), and press Enter to complete the filling.
Note: The above reference is supported in Excel, but it seems not supported in WPS. And please note that the structure or fixed position of the numbers in each table is the same before you can use this formula.
3: Multi-region joint calculation
In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.
For example, there is a table that calculates the totals from January to February, March and May to June.
Enter the formula in cell H2, press the Enter key to complete and fill downwards.
=SUM(B2:C2,E2,G2)
Declaration Form for Employment Security Fund for Disabled PersonsIt can meet the needs of many users and is absolutely eye-catching. Everyone is welcome to download and use it! There are also similar form templates on this site, such asUndergraduate Graduation Internship Location Intention Questionnaire,Travel Supermarket Reservation System Application Formwait!
it works
it works
it works