Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 [SOLVED] Ms Excel reverse formula

views
     
TSpiresthegod
post Jun 29 2015, 03:26 PM, updated 9y ago

New Member
*
Junior Member
6 posts

Joined: Feb 2008
From: Ampang


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.

user posted image

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

 

Change to:
| Lo-Fi Version
0.0135sec    0.31    5 queries    GZIP Disabled
Time is now: 28th March 2024 - 05:47 PM