Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
View of x-axis values | Charts and Charting in Excel | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
Changing the values in a column | Excel Discussion (Misc queries) |