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)
"OSSIE" wrote in
message ...
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
--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile:
http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=531982