Tips for using asset inventory report template
Asset inventory report templateHow to fill it out?
1. According to the inventory objects and scope:
1. A comprehensive inventory refers to the inventory and verification of all property.
2. Partial inventory refers to the inventory of a part of the property as needed, and the main objects of the inventory are properties with high liquidity.
2. According to the inventory time:
1. Regular inventory refers to the inventory of property carried out according to the provisions of the management system or the pre-planned time.
2. Irregular inspections refer to temporary inspections of property based on actual needs.
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")
Asset inventory report templateIt is a very practical form, and most of the forms to be filled in are for general purposes. If you happen to need to download the asset inventory report template, please download it quickly. In addition,Contract management and payment details,Employee travel expense reimbursement formIt is also a good form template. You are welcome to click to download and experience it.
Useful
Useful
Useful