View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TR TR is offline
external usenet poster
 
Posts: 11
Default Parameters question

Hi Dave,

I don't think I put the question clearly. My problem is when putting a new
growth rate, say 10%, in A2, the Sheet2 will calculate and return equity
price based on 10%. The originaly equity price (based on 5% growth rate) is
gone. How can I retain the old equity price?

As for the table, I was talking about Menu --Data--Table. It askes for row
input and column input, where both should be on the current sheet. To refer
parameters on other sheets, I have to link them back to the current sheet.

Hopefully I put it correct this time.

TR

"Dave F" wrote:

The short answer to your question is yes, and what you want to do doesn't
necessarily require coding.

If you enter values in A1:A10 on sheet 1, you can get those values to appear
on B1:B10 on sheet 2 by creating a formula which links the two cells together.

I'm not sure what you mean when you say "Table does not work in separate
sheets." Tables can be created in any sheet you want, and linked to other
sheets via dozens of different functions.

Dave
--
Brevity is the soul of wit.


"TR" wrote:

First of all, I don't think I am smart enough to go coding.
Being that, is there anyway to build calculation functions in Sheet2 and
list possible input in Sheet1 and automatically getting values under
different inputs?
For example, I put equity valuation calculations on Sheet2.
A1 of Sheet2 is the earning growth rate assumption, which drives all the
equity valuation calculations.
In sheet1, can I input 10 different expected growth rates in A1:A10 and get
equity values on B1:B10 (based on the calculations on Sheet2)?
I understand that creating a table can be helpful. But Table does not work
in separate sheets. Plus, if I want other parameters in the calculations in
addition to the equity value, I have to create other tables.

Appreciate your help!

Rt