A1 is ccs
B1 is:

=INT(A1/30) & " oz(s) " & MOD(A1,30) & " ccs"

HTH

"OcalaElaine" wrote:

Lewis Clark got my formula half-way there this morning. Thanks Lewis! If I
had been a bit more precise, I bet he would have told me the rest of what I
need to know. When my value goes over 30 cubic centimeters (I know this is
not exact but is approx. 1 oz.), I want to use a formula that will convert
the cubic centimeters to fluid ounces and cubic centimeters. When it gets to
60 cubic centimeters, I would like the formula to say 2 oz. In between the
ounces, I need the formula to calculate the ounces and cc's. Thanks so much
for anyone who can help!