Hi All,

Oh, I just researched the delemma and I now understand the argument
regarding the amount of teaspoons in a tablespoon due to the difference in
conversions between US, British, Canada and Australia measurements. This
site has a Standard Liquid Measurement -
http://www.ozevillage.com.au/gs/tips...pic=conversion .

a.. 5ml = 1/6fl oz = 1 teaspoon (50 teaspoons in 1 cup)
a.. 20ml = 2/3fl oz = 1 tablespoon (12.5 Tablespoons in 1 cup)
a.. 30ml = 1 fl oz = 1 tablespoon plus 2 teaspoons
a.. 60ml = 2fl oz = 1/4 cup
a.. 125ml = 4fl oz = 1/2 cup
a.. 185ml = 6fl oz = 3/4 cup
a.. 250ml = 8fl oz = 1 cup
a.. 500ml = 16fl oz = 2 cups
a.. 1 litre = 35fl oz = 4 cups

As you can see, I have made some corrections to my initial query.

I know the math in some of the conversions is not brilliant to say the
least, however, I am happy enough to use the above table. I agree with Ron
Rosenfeld - give the 1/3 and 2/3 of a Cup the flick.

I do own a metric scale, but, it is a real pain having to measure with it
all the time. This is the reason why, High Gluten Flour is 160g for 1 cup
and standard Flour is 120g for 1 cup. Sugar is 250g for 1 cup - the same as
water. I was hoping to measure 1 cup of an ingedient and then use that to
work out the imperial volume of random measurements eg ;
270g of sugar = 1C, 1T,0t ;
270g of High Gluten Flour is 1 C, 2T,1t.

Where 1C = 1 Cup, 1T = 1 Tablespoon and 1t = 1 teaspoon.

I know this is doosy of an equation, however, I am hoping there is an excel
guru out there that can shine some light on this.

Regards,

Wazza McG



"Ron Rosenfeld" wrote in message
...
On Mon, 21 Nov 2005 06:41:18 +1000, "Wazza McG"
wrote:

Hi,

I have been having trouble trying to work out a formula for the following.

One cup of flour weighs 160g.

If I had 240g of flour I would have 1 1/2 Cups.

Now the hard bit, there are 16 Tablespoons and 48 teaspoons in a cup of
flour.

If I had 270g of flour I want the formula to have an end result of - 1 1/2
C, 2T and 3t - rounded off as close as possible.

In the cup measures, I would only want to use 1/4 C, 1/3 C, 1/2 C, 2/3 C,
3/4 C and 1C and so on. I know 5t should read 1T and 1t, however, getting
a
formula to work is beyond me at this stage.

If anyone can help, It would be greatly appreciated.

Regards,

Wazza McG


If you could eliminate those pesky 1/3 and 2/3 cup measures, it would be
much
simpler (rounding Tsp to the nearest 1/4 tsp)

With the weight in A2:

Cups B2: =ROUNDDOWN(A2/160*4,0)/4
Tbsp C2: =INT((A2-(B2*160))/10)
Tsp D2: =ROUND((A2-B2*160-C2*10)/3*4,0)/4

If you insist on using those 1/3 and 2/3 cup measures, then the formula
for
Cups becomes more complicated, as I believe you would want the most
accurate
measu

Cups B2:

=MAX(ROUNDDOWN(A2/160*4,0)/4,ROUNDDOWN(A2/160*3,0)/
IF(ABS(A2-(ROUNDDOWN(A2/160*4,0)/4*160+INT((A2-(
ROUNDDOWN(A2/160*4,0)/4*160))/10)*10+ROUND((A2-
ROUNDDOWN(A2/160*4,0)/4*160-INT((A2-(ROUNDDOWN(
A2/160*4,0)/4*160))/10)*10)/3*4,0)/4*3))<ABS(A2-(ROUNDDOWN(
A2/160*3,0)/3*160+INT((A2-(ROUNDDOWN(A2/160*3,0)/3*160))
/10)*10+ROUND((A2-ROUNDDOWN(A2/160*3,0)/3*160-INT((A2-
(ROUNDDOWN(A2/160*3,0)/3*160))/10)*10)/3*4,0)/4*3)),30,3))


--ron