Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Converting pounds and ounces in worksheet for a recipe

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???
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 833
Default Converting pounds and ounces in worksheet for a recipe

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 277
Default Converting pounds and ounces in worksheet for a recipe

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,441
Default Converting pounds and ounces in worksheet for a recipe

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 563
Default Converting pounds and ounces in worksheet for a recipe

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Does anyone have a template to convert Kilos to Pounds & Ounces Pagie Excel Worksheet Functions 6 May 26th 09 12:28 AM
how do i format a number into stones, pounds and ounces, please? paula23234 Excel Discussion (Misc queries) 2 February 4th 09 12:59 PM
Inputting data as Stone, pounds and ounces BigAndy Excel Discussion (Misc queries) 2 September 13th 07 12:33 AM
How set up a spread in pounds & ounces? Peter Excel Discussion (Misc queries) 4 August 27th 05 12:05 PM
How can I add pounds and ounces in excel, Agoogirl Excel Discussion (Misc queries) 3 January 5th 05 10:00 PM


All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"