Question: 2c) Add conditional formatting bars to the Quantity on Hand column as a visual representation of your current inventory. (1 Point) In the Cost Basis
2c) Add conditional formatting bars to the "Quantity on Hand" column as a visual representation of your current inventory. (1 Point) In the "Cost Basis Rounded", use an Excel function to Round Up your cost basis numbers to an integer. (1 Point) Use IFERROR to replace any HDIV/ D I^ prime prime with 0. The average cost can be found by dividing Cost Basis (Column Z) by the Quantity on Hand (Cost Basis/Quantity on Hand). (1 Point)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
