Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Goal Seek On Members of an Array within Array
Greetings.
I am trying to use goal seek within an array. Essentially the first column would contain an amount of time, the second a cash flow, and I would like to set the third column to the interest rate that sets the present value of the prior three cash flows to a given interest rate(from a table on the worksheet). The interest rates would only change every three entries. To do this calculation on a worksheet I could use the goal sheet function. Can anyone think of a way to do all of this within an array? Thank you very much. |
#2
|
|||
|
|||
LostInVBA wrote...
I am trying to use goal seek within an array. Essentially the first column would contain an amount of time, the second a cash flow, and I would like to set the third column to the interest rate that sets the present value of the prior three cash flows to a given interest rate(from a table on the worksheet). The interest rates would only change every three entries. To do this calculation on a worksheet I could use the goal sheet function. Can anyone think of a way to do all of this within an array? Thank you very much. What do you mean by "sets the present value of the prior three cash flows to a given interest rate"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal Seek | Excel Discussion (Misc queries) | |||
goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) | |||
goal seek vs solver | Excel Worksheet Functions | |||
Goal Seek - Why make the PV negative? | Excel Discussion (Misc queries) | |||
Goal Seek - reference a cell for "To value" field? | Excel Worksheet Functions |