Turning waste weight into cost 1. kg =$3

[Abo666]

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

 

[FormR]

Hi Something like this maybe:

Book1
	C	D	E
1	Weight	Waste	Cost
2	14	0.5	1.5
3	18.54	5.04	15.12
4	10
Sheet1

Cell Formulas
Range	Formula
D2:D4	D2	=IF(C2>13.5,C2-13.5,"")
E2:E4	E2	=IF(D2="","",D2*3)

 

[Abo666]

Hi Something like this maybe:

Book1
	C	D	E
1	Weight	Waste	Cost
2	14	0.5	1.5
3	18.54	5.04	15.12
4	10
Sheet1

Cell Formulas
Range	Formula
D2:D4	D2	=IF(C2>13.5,C2-13.5,"")
E2:E4	E2	=IF(D2="","",D2*3)

Hi Something like this maybe:

Book1
	C	D	E
1	Weight	Waste	Cost
2	14	0.5	1.5
3	18.54	5.04	15.12
4	10
Sheet1

Cell Formulas
Range	Formula
D2:D4	D2	=IF(C2>13.5,C2-13.5,"")
E2:E4	E2	=IF(D2="","",D2*3)

 

[Abo666]

Thank you so much, fantastic people on here,learning lots.
Worked perfectly.I am very happy that on this site I have asked help on three threads to help build a formula and got great results and more.
A very big thank you,to all that help me learn more