Goal seek

  • Thread starter Thread starter cindylee
  • Start date Start date
C

cindylee

I have a excel spreadsheet calculating yield of an investment.

I am using function "YIELD", in which there are 4 items : sold date
sold price, bought date and purchased price.

the last two items are fixed, won't change.

the first two are variables.

Firstly, i will enter the sold date. then adjust the sold price unti
the yield reach 4 %.

I heard that i can use "goal seek" , can anyone help me how to use thi
function?

thanks a lot!!!!

Cind
 
cindylee said:
I have a excel spreadsheet calculating yield of an investment.

I am using function "YIELD", in which there are 4 items : sold date,
sold price, bought date and purchased price.

the last two items are fixed, won't change.

the first two are variables.

Firstly, i will enter the sold date. then adjust the sold price until
the yield reach 4 %.

I heard that i can use "goal seek" , can anyone help me how to use this
function?
Click to expand...
On the Tools menu, click Goal Seek.
In the Set cell box, enter the reference for the cell that contains the
formula you want to resolve. (YIELD)

In the To value box, type the result you want. (4)

In the By changing cell box, enter the reference for the cell that
contains the value you want to adjust. (sold price)

Click OK.
 
cindylee said:
I have a excel spreadsheet calculating yield of an investment.

I am using function "YIELD", in which there are 4 items : sold date,
sold price, bought date and purchased price.

the last two items are fixed, won't change.

the first two are variables.

Firstly, i will enter the sold date. then adjust the sold price until
the yield reach 4 %.

I heard that i can use "goal seek" , can anyone help me how to use this
function?

thanks a lot!!!!

Cindy
Click to expand...

Select the cell with the YIELD formula in it.
Tools > Goal seek
The dialogue box is very easy to fill in.
 
hi all!!

I have tried, but failed.

1.set cell: i click on the "yield' cell
2. to value : i click 4
3. by changing cell : i click on the "sold price" cell

why cannot work? or are there any other function that i can use?

thanks for helping again!
 
cindylee said:
*hi all!!

I have tried, but failed.

1.set cell: i click on the "yield' cell
2. to value : i click 4
3. by changing cell : i click on the "sold price" cell

why cannot work? or are there any other function that i can use?

thanks for helping again!! *
Click to expand...

Cindy, Yield is a percentage, perhaps you need to enter 0.04 in order
to get what you want.
 
Back
Top