Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a homework assignment for my cooking class and am trying to enter the
information in a spreadsheet to convert to different size recipes and can't remember how to set it up to convert. Like if I have one recipe that says it is for 1 quart and you need 1lb 4 oz convert to a recipe that is 3 1/4 pints what is needed for the new recipe??? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
1 quart = 2 pints
1lb 4 oz = 20 ounces The above is what you have given me. Therefore 2 pints must equal 20 ounces. Therefore 1 pint equals 10 ounces. Therefore 3.25 pints equals 10 ounces times 3.25 = 32.5 ounces. I reckon that's your answer. Takes me back to my school days! If my comments have helped please hit Yes (and change to metric it's alot easier!). Thanks. "Mary Jayne" wrote: I have a homework assignment for my cooking class and am trying to enter the information in a spreadsheet to convert to different size recipes and can't remember how to set it up to convert. Like if I have one recipe that says it is for 1 quart and you need 1lb 4 oz convert to a recipe that is 3 1/4 pints what is needed for the new recipe??? |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Sun, 17 Jan 2010 12:17:01 -0800, trip_to_tokyo
wrote: 1 quart = 2 pints 1lb 4 oz = 20 ounces The above is what you have given me. Therefore 2 pints must equal 20 ounces. Therefore 1 pint equals 10 ounces. Therefore 3.25 pints equals 10 ounces times 3.25 = 32.5 ounces. I reckon that's your answer. Takes me back to my school days! If my comments have helped please hit Yes (and change to metric it's alot easier!). Thanks. "Mary Jayne" wrote: I have a homework assignment for my cooking class and am trying to enter the information in a spreadsheet to convert to different size recipes and can't remember how to set it up to convert. Like if I have one recipe that says it is for 1 quart and you need 1lb 4 oz convert to a recipe that is 3 1/4 pints what is needed for the new recipe??? Except that 2 pints does not equal 20 ounces. 1 pint is 16 ounces, but that is not what was asked for either. |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a homework assignment for my cooking class and am trying to enter
the information in a spreadsheet to convert to different size recipes and can't remember how to set it up to convert. Like if I have one recipe that says it is for 1 quart and you need 1lb 4 oz convert to a recipe that is 3 1/4 pints what is needed for the new recipe??? Except that 2 pints does not equal 20 ounces. 1 pint is 16 ounces, but that is not what was asked for either. It doesn't matter - the problem is the equivalent of knowing A, B, and C and wanting X in the following A/B = C/X where A = 1 quart (2 pints), B = 20 Ounces, and C = 3.25 pints so X = C*B/A or 3.25*20/2 or 32.5 ounces. A pint _is_ a pound the world around, but only if you're talking about water. Bernie |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
No, 1 pint is 20 oz unless you live in USA
Blame Jefferson for this Bernard "CellShocked" <cellshocked@thecellvalueattheendofthespreadsheet. org wrote in message ... On Sun, 17 Jan 2010 12:17:01 -0800, trip_to_tokyo wrote: 1 quart = 2 pints 1lb 4 oz = 20 ounces The above is what you have given me. Therefore 2 pints must equal 20 ounces. Therefore 1 pint equals 10 ounces. Therefore 3.25 pints equals 10 ounces times 3.25 = 32.5 ounces. I reckon that's your answer. Takes me back to my school days! If my comments have helped please hit Yes (and change to metric it's alot easier!). Thanks. "Mary Jayne" wrote: I have a homework assignment for my cooking class and am trying to enter the information in a spreadsheet to convert to different size recipes and can't remember how to set it up to convert. Like if I have one recipe that says it is for 1 quart and you need 1lb 4 oz convert to a recipe that is 3 1/4 pints what is needed for the new recipe??? Except that 2 pints does not equal 20 ounces. 1 pint is 16 ounces, but that is not what was asked for either. |
#7
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Mary Jayne
Check this site http://joshmadison.com/software/convert-for-windows/ It's a free utility to convert almost anything. HTH John "Mary Jayne" <Mary wrote in message ... I have a homework assignment for my cooking class and am trying to enter the information in a spreadsheet to convert to different size recipes and can't remember how to set it up to convert. Like if I have one recipe that says it is for 1 quart and you need 1lb 4 oz convert to a recipe that is 3 1/4 pints what is needed for the new recipe??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Does anyone have a template to convert Kilos to Pounds & Ounces | Excel Worksheet Functions | |||
how do i format a number into stones, pounds and ounces, please? | Excel Discussion (Misc queries) | |||
Inputting data as Stone, pounds and ounces | Excel Discussion (Misc queries) | |||
How set up a spread in pounds & ounces? | Excel Discussion (Misc queries) | |||
How can I add pounds and ounces in excel, | Excel Discussion (Misc queries) |