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: Quick sum and average
If you want to directly know the sum or average of certain numbers, just select those numbers and you will know. After selection, summation, average, and count will be displayed in the bottom status bar.
2: Format brush
The use of Format Painter is very simple. Just click on Format Painter, then select the format you want to copy, and finally select the cells you want to modify. You can modify it in batches.
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
4: SUMIF usage is:
=SUMIF(condition area, specified summation condition, summation area)
In layman’s terms, it can be described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, sum the corresponding area of the C2:C5 cell.
Housing 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.Purchase product quotation comparison table,List of financial system industry standardsDownload to get the source file, which can be edited, modified and replaced. Download the housing provident fund withdrawal application form and go to Huajun Software Park.
it works
it works
it works