Housing provident fund withdrawal conditions:
1. Hold a valid withdrawal voucher for purchasing, constructing, renovating, or overhauling your own housing;
2. Those who are retired or retired must hold a valid withdrawal certificate;
3. Those who have completely lost their ability to work and have terminated their labor relationship with the unit must hold a valid withdrawal certificate;
4. Those who have settled abroad, Hong Kong, Macao and Taiwan must hold a valid withdrawal voucher;
5. To repay the principal and interest of the housing loan, hold a valid withdrawal certificate;
6. Those who are included in the minimum living security range for urban residents in this city and pay rent must hold valid withdrawal vouchers;
7. Employees who are not registered in this city leave this city and terminate their labor relationship with their employer.
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)
Provident Fund Withdrawal Application FormIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Capital construction financial management personnel registration form,Urban maintenance and construction fund income statementDownload to get the source file for you to edit, modify and replace. Download the provident fund withdrawal application form and go to Huajun Software Park.
it works
it works
it works