Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find components of an Average Result
Hello,
I have data below, On D1 if I put the formula =AVERAGE(A1:C1) it will return 80; the input data are A1 to C1 A B C D 1 75 80 85 80 My question is...is there a way/ possible to "reverse" this process, where I will input 80 (or any value) on D1 and it will give the values in A1 to C1 (which are not equal to each other, like in my example)? Thanks in advance for your help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find components of an Average Result
Hi,
For that to happen, you have have to define a relation between A, B, C and D. Alternatively, if any two of the 3 values can be fixed, the third can be back calculated by using Goal Seek -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "al_ba" <al_814 wrote in message ... Hello, I have data below, On D1 if I put the formula =AVERAGE(A1:C1) it will return 80; the input data are A1 to C1 A B C D 1 75 80 85 80 My question is...is there a way/ possible to "reverse" this process, where I will input 80 (or any value) on D1 and it will give the values in A1 to C1 (which are not equal to each other, like in my example)? Thanks in advance for your help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find components of an Average Result
There will be an infinite number of those numbers with an average of
80, eg 79, 80, 81 - 78, 80, 82 - 77, 80, 83 etc. just to show 3 sets. How to determine which is the right set? Pete On Oct 1, 9:09*am, al_ba <al_814 wrote: Hello, I have data below, On D1 if I put the formula =AVERAGE(A1:C1) it will return 80; the input data are A1 to C1 * * * *A * * * B * * * * C * * * * * *D 1 * * 75 * * 80 * * * *85 * * * * *80 My question is...is there a way/ possible to "reverse" this process, where I will input 80 (or any value) on D1 and it will give the values in A1 to C1 (which are not equal to each other, like in my example)? Thanks in advance for your help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find components of an Average Result
Hello,
That would be +5, (like my example)...if possible can be changed to +3 (or any number). Thanks in advance. :) "Pete_UK" wrote: There will be an infinite number of those numbers with an average of 80, eg 79, 80, 81 - 78, 80, 82 - 77, 80, 83 etc. just to show 3 sets. How to determine which is the right set? Pete On Oct 1, 9:09 am, al_ba <al_814 wrote: Hello, I have data below, On D1 if I put the formula =AVERAGE(A1:C1) it will return 80; the input data are A1 to C1 A B C D 1 75 80 85 80 My question is...is there a way/ possible to "reverse" this process, where I will input 80 (or any value) on D1 and it will give the values in A1 to C1 (which are not equal to each other, like in my example)? Thanks in advance for your help! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find components of an Average Result
Use F1 to specify the spacing (i.e. 5 in this case), then you can have
these formulae: A1: =D1-F1 B1: =D1 C1: =D1+F1 Hope this helps. Pete On Oct 1, 11:12*pm, al_ba <al_814 wrote: Hello, That would be +5, (like my example)...if possible can be changed to +3 (or any number). Thanks in advance. :) "Pete_UK" wrote: There will be an infinite number of those numbers with an average of 80, eg 79, 80, 81 - 78, 80, 82 - 77, 80, 83 etc. just to show 3 sets. How to determine which is the right set? Pete On Oct 1, 9:09 am, al_ba <al_814 wrote: Hello, I have data below, On D1 if I put the formula =AVERAGE(A1:C1) it will return 80; the input data are A1 to C1 * * * *A * * * B * * * * C * * * * * *D 1 * * 75 * * 80 * * * *85 * * * * *80 My question is...is there a way/ possible to "reverse" this process, where I will input 80 (or any value) on D1 and it will give the values in A1 to C1 (which are not equal to each other, like in my example)? Thanks in advance for your help!- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find components of an Average Result
Hi Pete,
That's a lot of help, thanks! "Pete_UK" wrote: Use F1 to specify the spacing (i.e. 5 in this case), then you can have these formulae: A1: =D1-F1 B1: =D1 C1: =D1+F1 Hope this helps. Pete On Oct 1, 11:12 pm, al_ba <al_814 wrote: Hello, That would be +5, (like my example)...if possible can be changed to +3 (or any number). Thanks in advance. :) "Pete_UK" wrote: There will be an infinite number of those numbers with an average of 80, eg 79, 80, 81 - 78, 80, 82 - 77, 80, 83 etc. just to show 3 sets. How to determine which is the right set? Pete On Oct 1, 9:09 am, al_ba <al_814 wrote: Hello, I have data below, On D1 if I put the formula =AVERAGE(A1:C1) it will return 80; the input data are A1 to C1 A B C D 1 75 80 85 80 My question is...is there a way/ possible to "reverse" this process, where I will input 80 (or any value) on D1 and it will give the values in A1 to C1 (which are not equal to each other, like in my example)? Thanks in advance for your help!- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find components of an Average Result
You're welcome - strange request, though !!
Pete On Oct 2, 5:35*am, al_ba <al_814 wrote: Hi Pete, That's a lot of help, thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=AVERAGE returning a #DIV/0! result | Excel Worksheet Functions | |||
Average function not returning expected result | Excel Discussion (Misc queries) | |||
Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
Hide formula result values until all components are entered | Excel Discussion (Misc queries) | |||
formula result #value! needs to equal zero for average calculation | Excel Worksheet Functions |