Current location - Recipe Complete Network - Catering training - Warehouse forms need to calculate the number of boards, there are several kinds of cargo specifications, how do I design the formula?
Warehouse forms need to calculate the number of boards, there are several kinds of cargo specifications, how do I design the formula?
Do you think this will work?

Cell A2: the date of incoming goods;

Cell B2: the number of packages of 500KG/BAG; assuming 1200

Cell C2: the number of packages of 1000KG/BAG; assuming 30

Cell D2: the number of packages of 25KG/BAG; assuming 462

Cell E2: the number of boards; Formula E2 = B2 + C2 + CEILING (D2/40,1)

EXCEL automatically calculated to 1242, that is, 25KG/BAG of 462 packages counted as 12 boards.

Related articles
  • Beer marketing approach These points can help you attract customers
  • What is the best bottom for the scarlet letter at the door?
  • From Beijing Tongzhou Zhang Xinzhuang to Tianjin Wucheng Nankouzhan by bus route
  • How about Shaanxi Qi Hao Shejian Catering Management Co., Ltd.?
  • What time does Marriott close in Loudi
  • The best naan in Urumqi
  • What does refrigeration equipment include?
  • What about Shanghai Luoping Catering & Distribution Co.
  • Three people cooperate in a small restaurant, cooperation of the three average contribution, another 2 people into the shares, ask how to allocate equity?
  • Introduction of Shanghai Catering Association

    • copyright 2024 Recipe Complete Network All rights reserved