Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation help
Hi guys,
Your help will be very much appreciated - So here is my problem. I have a column that has 5 average values of 10 10 10 10 10 10 Now if I change the 3rd value (or 3rd row) to say 15 how do I make sure that the average for the column remains the same (i.e. 10) but the values in last 2 rows changes -- i.e it should be 7.5 and 7.5. The values in the first two rows should not change and the cloumn should appear as 10 10 15 7.5 7.5 Any help will be appreciated. Thanks spray2006 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation help
will it always be the third row to change and 4 and 5 to correct????
-- paul remove nospam for email addy! "spray2006" wrote: Hi guys, Your help will be very much appreciated - So here is my problem. I have a column that has 5 average values of 10 10 10 10 10 10 Now if I change the 3rd value (or 3rd row) to say 15 how do I make sure that the average for the column remains the same (i.e. 10) but the values in last 2 rows changes -- i.e it should be 7.5 and 7.5. The values in the first two rows should not change and the cloumn should appear as 10 10 15 7.5 7.5 Any help will be appreciated. Thanks spray2006 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation help
Hi Paul,
Thanks for the reply. No...it can be any row. the challenge is i have to change the values of the rows below the one that I change so that the average remains constant. spray2006 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |