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

Not sure what formula you want:

No. of cups ?

=(A2*8)

8 cups of 2 ozs = 1 lb?

HTH

"OSSIE" wrote:


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

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