I created a VLOOKUP table like:
E F G H I J
1 0 0C 0 0T 0 0t
2 40 1/4C 10 1T 33.33 1t
3 53.33 1/3C 20 2T 6.66 2t
4 80 1/2C 30 3T
5 106.67 2/3C 40 4T
6 120 3/4C 50 5T
7 160 1C 60 6T
8 200 1 1/4C 70 7T
9 213.33 1 1/3C 80 8T
10 240 1 1/2C 90 9T
11 266.66 1 2/3C 100 10T
12 280 1 3/4C 110 11T
13 320 2C 120 12T
14 360 2 1/4C 130 13T
15 373.33 2 1/3C 140 14T
16 400 2 1/2C 150 15T
17 426.67 2 2/3C
18 440 2 4/4C
19 480 3C
then with the flour in grams in A1 try:
=VLOOKUP(A1,E1:F19,2) &"
"&VLOOKUP(INT((A1-VLOOKUP(A1,E1:E19,1))/10),G1:H16,2)& "
"&VLOOKUP(ROUND(A1-VLOOKUP(A1,E1:E19,1)-INT((A1-VLOOKUP(A1,E1:E19,1))/10)*10,2),I1:J3,2)
there are tree spaces between the quotes but as Bernard said, buy metric
scale.
--
HTH
Sandy
Replace@mailinator with @tiscali.co.uk
"Wazza McG" wrote in message
u...
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