Display and add up Grams/Kilograms

[Geek Girl 007]

Can I show and add up displays as grams and Kilograms???

Roberta's Accounts.xlsx
	A	B	C	D	E
1	Product	Weight	Amount		Price
2	White Choc	0.75	6	4.5	£14.99
3	W/C Strawberry	0.75	4	3
4	Milk Choc	0.75	6	4.5
5	Dark Choc	1kg	1	#VALUE!	£24.95
6	Vanilla Paste	50g	1	#VALUE!	£5.97
Costs

Cell Formulas
Range	Formula
D2:D6	D2	=B2*C2

 

[HighAndWilder]

Can I show and add up displays as grams and Kilograms???

Roberta's Accounts.xlsx
	A	B	C	D	E
1	Product	Weight	Amount		Price
2	White Choc	0.75	6	4.5	£14.99
3	W/C Strawberry	0.75	4	3
4	Milk Choc	0.75	6	4.5
5	Dark Choc	1kg	1	#VALUE!	£24.95
6	Vanilla Paste	50g	1	#VALUE!	£5.97
Costs

Cell Formulas
Range	Formula
D2:D6	D2	=B2*C2

Are you able to add in an extra column?

Cycle through different Rate Sheets.xlsm
	A	B	C	D	E	F
1	Product	Unit	Weight	Qty	Total Weight	Price
2	White Choc	kg	0.75	6	4.5 kg	14.99
3	W/C Strawberry	kg	0.75	4	3 kg
4	Milk Choc	kg	0.75	6	4.5 kg
5	Dark Choc	kg	1	1	1 kg	24.95
6	Vanilla Paste	g	50	1	50 g	5.97
Sheet1

Cell Formulas
Range	Formula
E2:E6	E2	=IF($B2="g",$C2*$D2 & " g",IF($B2="kg",($C2*$D2) & " kg",""))

 

[Geek Girl 007]

Are you able to add in an extra column?

Cycle through different Rate Sheets.xlsm
	A	B	C	D	E	F
1	Product	Unit	Weight	Qty	Total Weight	Price
2	White Choc	kg	0.75	6	4.5 kg	14.99
3	W/C Strawberry	kg	0.75	4	3 kg
4	Milk Choc	kg	0.75	6	4.5 kg
5	Dark Choc	kg	1	1	1 kg	24.95
6	Vanilla Paste	g	50	1	50 g	5.97
Sheet1

Cell Formulas
Range	Formula
E2:E6	E2	=IF($B2="g",$C2*$D2 & " g",IF($B2="kg",($C2*$D2) & " kg",""))

Fantastic, Thank you

 

[Cubist]

Column B already tells you the unit, don't need the IF's

=D2*C2&" "&B2

 

[Geek Girl 007]

Column B already tells you the unit, don't need the IF's

=D2*C2&" "&B2

Also Fantastic, Thank you