(1) Housing provident fund is only established in cities and towns, and no housing provident fund system is established in rural areas.
(2) The housing provident fund system is established only for current employees. The housing provident fund system is not applicable to unemployed urban residents and retired employees.
(3) The housing provident fund consists of two parts, one part is paid by the employee's unit, and the other part is paid by the employee personally.
(4) The long-term nature of housing provident fund deposits. Once the housing provident fund system is established, employees must make uninterrupted contributions in accordance with the regulations while on the job. Except for the employee's retirement or other circumstances stipulated in the "Housing Provident Fund Management Regulations", it shall not be suspended or interrupted. It reflects the stability, uniformity, standardization and mandatory nature of the housing provident fund.
(5) The housing provident fund is a personal housing savings deposited by employees in accordance with regulations and specifically used for housing consumption expenditures.
1: Sum of multiple conditions
It is necessary to count the total amount of subsidies provided by the department for production and the position is for the main operator.
The formula is:
=SUMIFS(D2:D9,B2:B9,F2,C2:C9,G2)
2: Conditional counting
It is necessary to count the number of business transactions of the designated store. That is, count how many specified store names there are in column B.
=COUNTIF(B2:B12,E3)
3. Change number format
Excel’s shortcut keys are not chaotic, but follow a certain logic.
For example, if you want to quickly change the format of a number, you can immediately add a dollar sign to the number, because the $ symbol and the number 4 share the same key.
In the same way, "Ctrl+shift+5" can quickly change the number into the form of percentage (%).
Housing provident fund application formIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.House rental announcement form,Machinery usage signDownload to get the source file, which you can edit, modify and replace. Download the housing provident fund application form and go to Huajun Software Park.
it works
it works
it works