# 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

• 8.6 KB Views: 1

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