Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |