Please forgive my naivete, but either I am having a hard time understanding
the information in your posting, or what you want cannot be done.

First, bear in mind that your references to columns (cells, in some cases)
are unclear because of the mangled format of posted data (not your fault).
I suggest that you present the data another way. The following is my
interpretation.

As I understand your data, 1 exchange is 530 cal broken down as follows:

Starch: 80 cal; Carb=65, Prot=15, Fat=0
Meat:
Lean: 45 cal; Carb=0, Prot=18, Fat=27[*]
Med: 75 cal; Carb=0, Prot=30, Fat=45[*]
High: 100 cal; Carb=0, Prot=40, Fat=60[*]
Veg: 25 cal; Carb=20, Prot=5, Fat=0
Fruit: 60 cal; Carb=60, Prot=0, Fat=0
Milk: 100 cal; Carb=38, Prot=27, Fat=35
Fat: 45 cal; Carb=0, Prot=0, Fat=45

If I understand that correctly, then for 1 exchange: Carb=183, Prot=135,
Fat=212 cal.

By definition, Carb is 34.5% (183/530), Prot is 25.5% (35/530), and Fat is
40% (212/530).
[*] Since the meat categories (lean, med, high) usually refer to fat
content, it seems incongruous to assume that the fat content is 60% of each
category. You did say 60% of __total__ meat calories. But you offered no
data as how that is distributed over lean, med and high fat content. That
does not affect the summary calculations above. However, it might affect
solution to the speculated problem below ("is the dietician asking").
Please fill in this detail (fat content of __each__ meat category) when you
post a follow-up.


Our dietician has asked me to make it work inversely so that she can
insert
total calories for the client - she wants the sheet to then calculate the
number of exchanges based on a fixed 50% Carbs/20% Protein and 30% Fat

It cannot be broken by 50-20-30%. It is 34.5-25.5-40% by defintion (?).

Is the dietician asking: find some combination of starch, meats, veg,
fruit, milk and fat that sums to 530 cal, but with a breakdown of 50-20-30%?

First, I don't know if both constraints can be met, based on the data above.
But if it can be, it probably cannot be determined by a few formulas. You
might be able to use Solver; but I doubt it. I would write a macro.

But I suspect there is a problem with my interpretation. You can see how I
interpreted it. Please correct my misunderstanding, if any.


----- original message -----

"Denise" wrote in message
...

St M(Lean)/M(Med.)/M(High) Veg Frt Mlk Fat

GOALS CALS PERCENT
CAR: 1,000 50.0%
PRO: 400 20.0%
FAT: 600 30.0%
Total: 2,000 100%

1 exchange 80 45 75 100 25 60 100 45
Calories

Carbohydrates combine Starch [65 of the 80 calories], Veg [20 of the 25
calories], Fruit [all 60 calories], Milk [38 of the 100 calories],
(B,F,G,H)

Protein combines Starch [15 of the 80 calories], Meat [40% of the total
meat calories are Protein (C10-E10)], Veg [5 of the 25 calories], Milk [27
of
the 100 calories] & Fruit (C-E & H)

Fat combines Meat [60% of the total meat calories are Fat (C10-E10)] &
Milk
[35 of the 100 calories] & Fat [all 45 calories] (C-E, H & I)

The original version of this worksheet is laid out so that a
client
or our staff Dietician can choose the number exchanges in day (Starch-Fat)
and the sheet will calculate the calories and the percentage for
Carbs./Protein & Fat.

Our dietician has asked me to make it work inversely so that she can
insert
total calories for the client - she wants the sheet to then calculate the
number of exchanges based on a fixed 50% Carbs/20% Protein and 30% Fat

I'm not skilled enough to express these formulas or clear as to whether
there are too many variables for it to work.

Thank you for your help!