Abo666
New Member
- Joined
- Mar 17, 2022
- Messages
- 11
- Office Version
- 2016
- Platform
- Windows
If I know how much waste is generated and the cost per kg ,how can I covert that.
Exp. 1.25 kg at $3 a kg ?
At the moment I type in the weight of the product and have a formula that's shows the waste weight,,,now I would like to convert that into cost of waste.
This is the formula for finding the amount of waste.=if(c2>13.5,c2-13.5,"") I have a formula for under weight,but it is the over weight that I want to cost,,,1 kg cost $3 and there usually will be a decimal point in there and the weight of the waste can vary.
I have had great help from this site,so thank you all
Exp. 1.25 kg at $3 a kg ?
At the moment I type in the weight of the product and have a formula that's shows the waste weight,,,now I would like to convert that into cost of waste.
This is the formula for finding the amount of waste.=if(c2>13.5,c2-13.5,"") I have a formula for under weight,but it is the over weight that I want to cost,,,1 kg cost $3 and there usually will be a decimal point in there and the weight of the waste can vary.
I have had great help from this site,so thank you all