# Posts by Expo86

Re: Calculation with number and text in cell

ok it did work , sorry about that
now this is what I am trying to do
a1 is 750 ml
a2 is \$9.50 (cost of bottle)
a3 is cost per ml
do you have a formula for that one?

Re: Calculation with number and text in cell

26 oz is in cell

Re: Calculation with number and text in cell

i got the same error message
I am thinking that you can not use text in a cell when using a calculation
Instead of referencing the cell a1 i will use 26.

How do you calculate when there is text with the number in the cell
example:
a1 value is 26oz
the 26 oz is in the cell
a2 value is \$9.50 (cost, only \$9.50 is in the cell)
a3 is cost per ounce.

It is best illustrated with an example
I am planning a super bowl party and need to know how many 26 oz bottles of rum i need to buy.
I know total number of ounces that, is a1. We will give it a total of 1234 oz. So a1 value is 1234 oz
b2 will be the total number of 26 oz bottles
a1 is total ounces
b2 is number of bottles needed to
I need to do the calculation and the round up all in the b2 cell.
how do i do this?