Help with formula if possible

  • Thread starter Thread starter OSSIE
  • Start date Start date
O

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
 
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)
 
Back
Top