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

[Toppers]

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
>
>

[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)

"OSSIE" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>