Tips for using warehouse registration form
Warehouse registration formHow to fill it out?
Product shipment: sales shipment or other shipments, the shipment order number can be automatically generated, and different shipping methods such as normal shipment and gift shipment can be distinguished;
Inventory management: When entering and exiting the warehouse, the inventory quantity of the product is recorded for easy query;
Inventory management: Users can inventory the warehouse at any time and automatically generate inventory documents, making the inventory work convenient and fast.
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: Multi-condition search
It is required to check that the department is production and the position is the name of the director.
The formula is:
=LOOKUP(1,0/((B2:B9=F2)*(C2:C9=G2)),A2:A9)
The writing method of multi-condition query of LOOKUP function is:
=LOOKUP(1,0/((condition area 1=condition 1)*(condition area 2=condition 2)),query area)
4: Calculate text equations
To calculate the text formula in the cell, first click on the first cell where you want to enter the formula and define the name:
Calculation = EVALUATE(C2)
Then enter the formula in the cell:
= Calculate
Warehouse registration formIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the warehouse registration form, download it quickly. In addition,New employee tenure evaluation form,Drug verification and use registration formIt is also a good form template. You are welcome to click to download and experience it.
Useful
Useful
Useful