This is so close. I can see I need to be much more specific with what I am
trying to do. Your formula works just great but I need the number of ounces
plus the number of cc's when it gets over an ounce. If I knew Excel better I
could probably figure out what to do next, but, alas.... Thanks for much for
your help.

"Lewis Clark" wrote:

The conversion factor is: 1 fluid ounce = 29.57353 cubic centimeters

If your volume in cc's is in Cell A1, then in cell B1 type:

=IF(A129.57353, ROUND(A1/29.57353,3)&" ounces",A1&" cc's")

Note that this will round the number of ounces to 3 decimal places. You can adjust this as necessary.


--

"OcalaElaine" wrote in message ...
I need to creat a chart that starts out with measurements in cubic
centimeters and need a formula to convert to ounces when there are enough cc
to equal an ounce