Hi, I have a set of data that I need to do a reverse formula calculation. I do not know how to use goal seek function with multiple cells as I need to change data on multiple cells.
Below is the picture of the set of data.
SOLVED VALUE has to match with TARGET VALUE as FIXED VALUE has to be exactly "20".
Example of for first line:
Target value formula is =(B2*5+C2*4+D2*3+E2*2+F2*1)*(H2/20)
Fixed value formula is =B2+C2+D2+E2+F2
Is that possible that i can get the value on Row B to Row F using goal seek or any other tools on excel?
This post has been edited by piresthegod: Jun 29 2015, 04:15 PM
[SOLVED] Ms Excel reverse formula