| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Can Cell X modify Cell Y?
Example:
If cell A1 equals 1, then cell B1 should have the value 5, otherwise B1 should be 6. A condition in cell A1 is changing the value of cell B1... is that possible? |
|
#2
|
|||
|
|||
|
Yes, of course. B1 contains this formula: =IF(A1=1,5,6)
On Tue, 8 Feb 2005 12:03:02 -0800, "alMandragor" wrote: Example: If cell A1 equals 1, then cell B1 should have the value 5, otherwise B1 should be 6. A condition in cell A1 is changing the value of cell B1... is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| GET.CELL | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
| Modify Row based upon cell value | Excel Worksheet Functions | |||
Hybrid Mode
