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!

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!

.. ..... or

=IF(MOD(A1,30)<0,INT(A1/30)&" oz(s) "&MOD(A1,30)&" ccs",INT(A1/30)&" ozs")

"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!

Oh my, Toppers! It is wonderful! Thank you so much.

"Toppers" wrote:

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!

Toppers - sure hope you can help. I have been using the formula below and it
works grand. Today - and I have check the formula letter/space/etc. - and it
got to 30 ccs and would not put 1 oz. Instead it put 0 oz and 30 cc. Please
help if you can. Thanks!

"Toppers" wrote:

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!