Help with formula if possible
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 |
Help with formula if possible
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 |
Help with formula if possible
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 |
All times are GMT +1. The time now is 02:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com