Excel table entry and exit formula: inventory = receipt-issue. The following explains how to make the table.

Tools/raw materials:

S3 Professional Edition of Mechanical Revolution

Windows 10

wps20 19

1, as shown in figure, is the original data area, as shown in figure:

2. Fill in the outbound and inbound records, as shown:

3. Select a blank inventory cell and enter a formula, as shown in the figure below:

4. Enter to get an inventory value, as shown in figure:

5. Select the above inventory value and drop it down to get other inventory values, as shown: