Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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%. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Express a Formula that is + or - 20% from a Value Q | Excel Worksheet Functions | |||
outlook express 6 | Setting up and Configuration of Excel | |||
Outlook Express | Excel Discussion (Misc queries) | |||
out express | Setting up and Configuration of Excel | |||
How to express $A:$A with formula | Excel Worksheet Functions |