Home

Excel Unit Conversion for Chemistry Units

Highlighted
Wardah Mustahsan
Occasional Contributor

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?

1 Reply

Hi Wardah,

 

That could be like

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