| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
week end and week so far results formular in % format
Hi im trying to find /maka a formula for 5 cells with data in which is
percentage but in 6th cell i want to create a week so far percentage result that adjust each day data is inputed any ideas im very novice at this. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
week end and week so far results formular in % format
So you end up with 5 cells each containing a percentage. That seems fairly
straight forward. Now you wnat to know how do you get the Week to date percentage. Now that depends on how you want to calculate the percentage. Is it the average of the percentages or is it based on the souce data... here is an example with just 2 days. 100 100 100% 500 1000 50% The rows generate 100% and 50%. tahe average of those 2 is 75%. However if I add up the values from the source I get 600 1100 55% What number were you looking for. 75% or 55%? Can you tell I'm an accountant. -- HTH... Jim Thomlinson "happyhammer" wrote: Hi im trying to find /maka a formula for 5 cells with data in which is percentage but in 6th cell i want to create a week so far percentage result that adjust each day data is inputed any ideas im very novice at this. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
week end and week so far results formular in % format
"Jim Thomlinson" wrote: So you end up with 5 cells each containing a percentage. That seems fairly straight forward. Now you wnat to know how do you get the Week to date percentage. Now that depends on how you want to calculate the percentage. Is it the average of the percentages or is it based on the souce data... here is an example with just 2 days. 100 100 100% 500 1000 50% The rows generate 100% and 50%. tahe average of those 2 is 75%. However if I add up the values from the source I get 600 1100 55% What number were you looking for. 75% or 55%? Can you tell I'm an accountant. -- HTH... Jim Thomlinson "happyhammer" wrote: Hi im trying to find /maka a formula for 5 cells with data in which is percentage but in 6th cell i want to create a week so far percentage result that adjust each day data is inputed any ideas im very novice at this. Hi Id be looking for 75% of the 2 results but would need the next 3 cell to be empty and not afecting the result ive tried =averagea(A1:E1) which only gives me a result if all data is inputed but if empty is useing the 5 cells at 20% of each result which i dont want |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
week end and week so far results formular in % format
Don't use AVERAGEA, as it will include text as 0. The normal AVERAGE function
will ignore blank cells, or formulas that evluate to "", thus not distorting your results. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "happyhammer" wrote: "Jim Thomlinson" wrote: So you end up with 5 cells each containing a percentage. That seems fairly straight forward. Now you wnat to know how do you get the Week to date percentage. Now that depends on how you want to calculate the percentage. Is it the average of the percentages or is it based on the souce data... here is an example with just 2 days. 100 100 100% 500 1000 50% The rows generate 100% and 50%. tahe average of those 2 is 75%. However if I add up the values from the source I get 600 1100 55% What number were you looking for. 75% or 55%? Can you tell I'm an accountant. -- HTH... Jim Thomlinson "happyhammer" wrote: Hi im trying to find /maka a formula for 5 cells with data in which is percentage but in 6th cell i want to create a week so far percentage result that adjust each day data is inputed any ideas im very novice at this. Hi Id be looking for 75% of the 2 results but would need the next 3 cell to be empty and not afecting the result ive tried =averagea(A1:E1) which only gives me a result if all data is inputed but if empty is useing the 5 cells at 20% of each result which i dont want |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
| Tie a Calendar week to a Scoped Projected Week | Excel Worksheet Functions | |||
| How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Linear Mode
