changing values in speadsheet
 

i am working on a project that requires me to make asumptions. If change the
value of the assumption, what forrmula do I use that will change all the
values associated with that value without copying and pasting the new value
to the new assumed values?

changing values in speadsheet
 

Roni

Store the assumption in a cell.

Have your other cells refer to this cell so when you change the assumption
value, the other cells will make the appropriate changes.

Basic example.......................

B1 contains 123
B2 contains 321

In A1 enter 10

In A2 enter =$A$1 * B1

Copy to A3

Change A1 to 5 and see A2 and A3 update.

NOTE: the $ signs. This anchors A1 as the assumption cell.

Another quick way that does not involve formulas is to enter 10 in a cell.

Copy that cell then select all other cells and Paste SpecialAdd or Multiply
or DivideOKEsc

Delete the 10 from the cell.


Gord Dibben Excel MVP


On Sat, 3 Dec 2005 15:15:02 -0800, "Roni"
wrote:

i am working on a project that requires me to make asumptions. If change the
value of the assumption, what forrmula do I use that will change all the
values associated with that value without copying and pasting the new value
to the new assumed values?

changing values in speadsheet
 

Hi Roni,
Say your assumption is in A1, then every cell that relies on that
assumption should contain an absolute reference to A1 using $A$1. When
you fill or paste you formula (that relies on the assumption) into
other cells it will always use the value in A1 as the assumption.
Ken Johnson

changing values in speadsheet
 

Thanks for the quick response...this worked like charm....

"Gord Dibben" wrote:

Roni

Store the assumption in a cell.

Have your other cells refer to this cell so when you change the assumption
value, the other cells will make the appropriate changes.

Basic example.......................

B1 contains 123
B2 contains 321

In A1 enter 10

In A2 enter =$A$1 * B1

Copy to A3

Change A1 to 5 and see A2 and A3 update.

NOTE: the $ signs. This anchors A1 as the assumption cell.

Another quick way that does not involve formulas is to enter 10 in a cell.

Copy that cell then select all other cells and Paste SpecialAdd or Multiply
or DivideOKEsc

Delete the 10 from the cell.


Gord Dibben Excel MVP


On Sat, 3 Dec 2005 15:15:02 -0800, "Roni"
wrote:

i am working on a project that requires me to make asumptions. If change the
value of the assumption, what forrmula do I use that will change all the
values associated with that value without copying and pasting the new value
to the new assumed values?