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