• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to create a sensitivity table when one of the variables is a result of a goal seek?

Asafshani87

New Member
Hi,
I'm trying to create a sensitivity table but one of the variables is a result of a goal seek.
for example, finding a company value: company value = goal seek of (VARIABLE 1-VARIABLE 2)*YEAR

How do i create a sensitivity table by changing the YEARS
 

Asafshani87

New Member
Hi Bosco,

attached please find the excel file.
for example the formula:

Variable1 + Variable2 = Result1
Variable2 x Variable3 = FINAL RESULT

what i meant is "Result1" is a result of a goal seek and FINAL RESULT is based on that.
For example:
5 + Variable2 = 30 ( the goal seek)
25 x 1 =25

now i want to create a sensitivity table by changing variable1 so Result1 does not change (by goal seek = 30)
for example:
now Variable1 is 10:
Goal seek on Result1= 10 + 20 = 30 (still)
FINAL RESULT = 20 x 1 = 20

so the sensitivity table should look like this:
Variable1 FINAL RESULT
5 25
10 20
.....

is that possible?
 

Attachments

Asafshani87

New Member
Hi,

I meant using data goal seek and data table... automatically.
in the excel you sent there is none of it...

you should create a sensitivity table (data -> what if analysis -> data table) based on a goal seek (the 25 + 5 was just an easy example.

it that possible?
 

bosco_yip

Excel Ninja
Hi,

I meant using data goal seek and data table... automatically.
in the excel you sent there is none of it...

you should create a sensitivity table (data -> what if analysis -> data table) based on a goal seek (the 25 + 5 was just an easy example.

it that possible?
You know Goal Seek and Excel Table already.

Why not do it and study it by yourself?
 
Last edited:

Asafshani87

New Member
As far as i know it is impossible to create a data table based on a constant goal seek.
in the example i showed you i don't know how maintain the Result1 = 30 (as a result of goal seek) no matter what is Var1...
then it changed Var 2 .... and now based on Var2 create a sensitivity table.

I know excel very well including data table and a goal seek...
so i'm asking if there is a way to create a data table based on a constant value from a goal seek

many thanks
 
Top