Current location - Training Enrollment Network - Mathematics courses - EXL table formula mathematics
EXL table formula mathematics
The 1 sign is issued by the minus sign. 1 comes from the inventory of last month, and then the daily inventory is the inventory of the previous day minus the issued quantity of that day, so that the formula can be obtained: I8=H6-I6.

J8=I8-J6

Then press J8 to expand and fill in the back inventory ~ (that is, K8=J8-K6, and so on)

Verification method: After filling in the numbers in the warehouse after the 2nd, you will find that the relevant data will change together. And corresponding to the corresponding inventory. It shows that the formula is correct.