Help with formula if possible

[OSSIE]

Hello I need help with a formula in A2 Amount of product= 1lb on b2the
amount of oz b2=16oz on c2 the amount of cups that each lb would give
me of product each cups takes 2 oz the amount of product will change
to 1 to 5 lb but the rest will stay the same
thank you in advance with your help

 

[Guest]

Not sure what formula you want:

No. of cups ?

=(A2*8)

8 cups of 2 ozs = 1 lb?

HTH

 

[Bob Phillips]

Sounds simple

B2: =A2*16 (format as 0"oz" if you want the oz at the end)
C2: = B2/2 if you want half cups as well, else use =INT(B2/2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)