① During the validity period of the policy, if the insured subject matter is sold or transferred, the insured may apply for a refund of part of the premium in accordance with relevant regulations.
② If the insured surrenders the policy midway, the insurer will refund a portion of the premium in accordance with regulations;
③During the validity period of the policy, if the liability of the insurer is reduced due to changes in circumstances, or the risk of the subject matter insured is reduced, the risk liability borne by the insurer is reduced, a portion of the premium will be refunded to the insured in accordance with regulations.
1: IF function conditional judgment
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
2: Multi-condition judgment
If the department is production and the position is mainly for operations, there is a high temperature subsidy. Use the formula in column D:
=IF(AND(B2="Production",C2="Main Operator"),"Yes","No")
Social Security Premium Refund Application FormIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Application Form for Housing Security for Lowest Income Residential Families,Agency housing rental information formDownload to get the source file, which you can edit, modify and replace. Download the social insurance premium refund application form and go to Huajun Software Park.
it works
it works
it works