| 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! |
| 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 | |||
Threaded Mode
