changing values in speadsheet

R

Roni

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?
 
G

Gord Dibben

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 Special>Add or Multiply
or Divide>OK>Esc

Delete the 10 from the cell.


Gord Dibben Excel MVP
 
K

Ken Johnson

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
 
Top