How do I express the following calculation.

[Dave Eade]

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%.

 

[Pete_UK]

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

Hope this helps.

Pete

 

[Dave Eade]

so I multiply one percentage by another?

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

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

Hope this helps.

Pete

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%.

.

 

[Pete_UK]

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

so I multiply one percentage by another?

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

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

Hope this helps.

Pete

I have a spreadsheet in which I want to express a value as a % - herethe
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 -