Forum Discussion
Cost Calculation
Hi I am trying to make an Inventory spreadsheet for my company to track Inventory and the costs of supplies. For the cost calculation I am confused why the Column O says #VALUE!
If you are using Excel tables, why not size them correctly to the data they contain. The equation using structured references would then fill down to match the price and quantity information.
=[@PricePerUnit]*[@TotalUnits]