Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Percentage of an Element ...
I want to know the percentsge of completion of an Element, containing 7 items
of % of completion, either as a completion rate of over 90%, and or 100%. Element 1.1 = 86% cell E6 Element 1.2 = 100% cell E14 Element 1.3 = 29% cell E19 Element 1.4 = 75% Cell E27 Element 1.5 = 0 % cell E32 Element 1.6 = 0 % Cell E38 Element 1.6 = 38% cell e41 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Percentage of an Element ...
I have three household tasks to complete and this is what I have done so far
1.1 Vacuum 6 rooms: 0% 1.2 Clean all windows in 6 rooms: 0% 1.3 Empty the dishwasher: 100% On average I have done (0+0+100)/3 = 33.3% of the tasks. True in a sense but not very meaningful since 1.1. and 1.2 take much longer than 1.3. But is this is NOT so in your case, then use =AVERAGE(E1, E14, E19, E27, E32, E38, E41) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Magic1" wrote in message ... I want to know the percentsge of completion of an Element, containing 7 items of % of completion, either as a completion rate of over 90%, and or 100%. Element 1.1 = 86% cell E6 Element 1.2 = 100% cell E14 Element 1.3 = 29% cell E19 Element 1.4 = 75% Cell E27 Element 1.5 = 0 % cell E32 Element 1.6 = 0 % Cell E38 Element 1.6 = 38% cell e41 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
look for missing element | Excel Worksheet Functions | |||
nth element extract | Excel Worksheet Functions | |||
How to define the 1st, 2nd and 3rd element | Excel Worksheet Functions | |||
hidden element | Excel Worksheet Functions | |||
hidden element | Excel Worksheet Functions |