Changing a cell's value

  • Thread starter Thread starter naztazia
  • Start date Start date
N

naztazia

Can someone point me in the right direction? Or tell me what the below
"concept" is called so I can search for the answer?

I have a cell [A1] {containing the number 2) that is referenced in
numerous calculations throughout the spreadsheet. If I change [A1] to
5, my final calculation in cell [A15] changes. If I change [A1] to 6,
cell [A15] changes again.

How do I automatically summarize the changes to cell [A15] in a matrix,
without having to keep typing in 2, 3, 4, 5 in cell A1 and manually
copying cell [A15]s values?

Thanks.
 
Naztazia,

You could put 2, 3, 4, going down from A1. Drag with the Fill Handle
holding Ctrl to do that. Then copy your A15 formula down also in the same
way (without Ctrl). You'll now have your array of results in A15, A16, etc.
You could do this going across instead of down (for both A1 and A15) also.
Depending on the formula in A15, some references may need to be changed to
absolute before you do the copy.
 
Thank you for responding so quickly! I appreciate the suggestion, but
I probably over-simplified my question. Unfortunately, the cell [A1]
is an elasticity number which is referenced by approximately 7 other
sheets to come up with monthly subscriber calculations, which are then
used to calculate monthly revenue numbers. So I can't really "fill"
downward with different numbers, since that one cell [A1] is incredibly
referenced on the 7 other sheets to calculate gobs of data, which are
then sum'd to calculate a bottom line revenue. The 'bottom line'
revenue number [A15] is a cell on an 8th sheet. I'm trying to create a
separate (9th) summary sheet matrix that gives a summary of various
elasticity numbers in cell [A1] -- that then produces a corresponding
bottom line result for those 10 different ways.

So are you saying that what I'm trying to do is an "array" ?

Thanks.
 
Naztazia,

I don't think I have a very good picture of how your project works. If you
want to plug different numbers into A1 and capture resulting calculations in
other cells, you should probably write a macro that plugs in the numbers
(automatically, from a list, whatever), and grabs the results and populates
your summary sheet.
 
I'm sorry to barge into this thread, but II've been expanding my
knowledge of these sorts of situations with Excel (mostly using Solver
or Table).

it struck me that you might use a function like Data...Table... (which
I have used) or Tools...Scenarios (which I have not used).
 
Scenarios - thank you! YES! It worked perfectly. I was able to
program in different values for cell A1, and it automatically
summarizes the results of these different "scenarios" of A1. It
created a matrix for me [if A1 = 2, then A15 = 300, if A1 = 3, then
A15=400] .

http://techrepublic.com.com/5100-6270-1040562.html if anyone is
interested.

Thanks.
 
Back
Top