Excel Unit Conversion for Chemistry Units

[Wardah Mustahsan]

Hi

Can someone please give some guidance on the CONVERT function in Excel with chemistry unit.

I have two examples:

1----- 143.57 g/mL to kg/L how would I do that with this function.

2----- 100 g/0.5 Liters to g/hectoLiters

Since this dual units (g/mL)  and not single units (g to kg) I am not sure how to go about using this function effectively for 400 samples.

Can someone please give me an idea of how to do this?

[#2]

Hi Wardah,

That could be like

=A1*CONVERT(1,"g","kg")/CONVERT(1,"ml","L")