I have a spreadsheet in which I want to express a value as a % - here the
challenge!

My total is 200, and my value is 50 - I can easily express this as a
percentage by the following "=(E7/E6)" and formatting this as a %.

However there is another variable - I have 4 such calculations, and the
answers I want to express as a percentage themselves - let me explain:

Calc1 is 200 / 50 gives 25%
Calc2 is 100/ 75 = 75%
Calc3 is 50 / 25 = 50%
Calc4 is 500 / 50 = 10%

Each of these totals represnenst a fraction of a total [ 50% 20% 20% % 10% ]

Therefore, Calc1 = 12.5%, Calc2 = 12%, Calc3 = 25%, Calc4 = 1% - the result
is therefore 50.5%.

You just need to multiply your Calc1, Calc2 etc by the weighting for
each Calc.

Hope this helps.

Pete

On Feb 11, 10:36*am, Dave Eade
wrote:
I have a spreadsheet in which I want to express a value as a % - here the
challenge!

My total is 200, and my value is 50 - I can easily express this as a
percentage by the following "=(E7/E6)" and formatting this as a %.

However there is another variable - I have 4 such calculations, and the
answers I want to express as a percentage themselves - let me explain:

Calc1 is 200 / 50 gives 25%
Calc2 is 100/ 75 = 75%
Calc3 is 50 / 25 = 50%
Calc4 is 500 / 50 = 10%

Each of these totals represnenst a fraction of a total [ 50% 20% 20% % 10% ]

Therefore, Calc1 = 12.5%, Calc2 = 12%, Calc3 = 25%, Calc4 = 1% - the result
is therefore 50.5%.

so I multiply one percentage by another?

Can't believe it's that simple !!!!

"Pete_UK" wrote:

You just need to multiply your Calc1, Calc2 etc by the weighting for
each Calc.

Hope this helps.

Pete

On Feb 11, 10:36 am, Dave Eade
wrote:
I have a spreadsheet in which I want to express a value as a % - here the
challenge!

My total is 200, and my value is 50 - I can easily express this as a
percentage by the following "=(E7/E6)" and formatting this as a %.

However there is another variable - I have 4 such calculations, and the
answers I want to express as a percentage themselves - let me explain:

Calc1 is 200 / 50 gives 25%
Calc2 is 100/ 75 = 75%
Calc3 is 50 / 25 = 50%
Calc4 is 500 / 50 = 10%

Each of these totals represnenst a fraction of a total [ 50% 20% 20% % 10% ]

Therefore, Calc1 = 12.5%, Calc2 = 12%, Calc3 = 25%, Calc4 = 1% - the result
is therefore 50.5%.

.

Well, look at your examples:

wt
Calc1 is 200 / 50 gives 25% x 50% = 12.5
Calc2 is 100/ 75 = 75% x 20% = 15
Calc3 is 50 / 25 = 50% x 20% = 10
Calc4 is 500 / 50 = 10% x 10% = 1

I don't know how you get the middle two answers that you quote above,
but this is the method.

Hope this helps.

Pete

On Feb 11, 1:54*pm, Dave Eade
wrote:
so I multiply one percentage by another?

Can't believe it's that simple !!!!



"Pete_UK" wrote:
You just need to multiply your Calc1, Calc2 etc by the weighting for
each Calc.

Hope this helps.

Pete

On Feb 11, 10:36 am, Dave Eade
wrote:
I have a spreadsheet in which I want to express a value as a % - here the
challenge!

My total is 200, and my value is 50 - I can easily express this as a
percentage by the following "=(E7/E6)" and formatting this as a %.

However there is another variable - I have 4 such calculations, and the
answers I want to express as a percentage themselves - let me explain:

Calc1 is 200 / 50 gives 25%
Calc2 is 100/ 75 = 75%
Calc3 is 50 / 25 = 50%
Calc4 is 500 / 50 = 10%

Each of these totals represnenst a fraction of a total [ 50% 20% 20% % 10% ]

Therefore, Calc1 = 12.5%, Calc2 = 12%, Calc3 = 25%, Calc4 = 1% - the result
is therefore 50.5%.

.- Hide quoted text -

- Show quoted text -