View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default How do I convert cubic centimeters to ounces in Excel?

No Pete, the ounce is(was) also a volume measurement.
In Imperial there were 20 oz to a pint; in US there are only 16.
And the oz has different size - Hail to metric!

Excel lets you convert litres (1000 cc) to pints
So this will work for US ounces =CONVERT(A1/1000,"lt","pt")*16
Or for UK =CONVERT(A1/1000,"lt","uk_pt")*20

On the other hand, if in Google you type "cc to ounce" Google tells you:
1 cc = 0.0338140226 US fluid ounces (my what precision!)

SO we could use =A1*0.0338140226 or better yet =ROUND(A1*0.033814,2)

Excel and Google do not quite agree: Excel converts 1000cc to 33.80667 US oz
while Google's value give 33.81402. A 0.02% difference will not ruin the
cake!

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Pete_UK" wrote in message
oups.com...
But cubic centimeters are a measure of volume and ounce is a measure of
weight. The conversion will depend on the density of the liquid you are
using - is this water?

Pete