Home

Excel Unit Conversion for Chemistry Units

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
Highlighted

Hi Wardah,

 

That could be like

=A1*CONVERT(1,"g","kg")/CONVERT(1,"ml","L")
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies