| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Cell X be modified by Cell Y?
For example:
If cell A1 equals 1, then cell B1 should have the value 5, otherwise B1 should be 6. By setting a condition in A1, I am affecting B1. Is that possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can Cell X be modified by Cell Y?
Hi,
Do you mean programmatically using vba? If not, In Cell B1 enter the formula: =IF(A1=1,5,6) Regards, Sebastien "alMandragor" wrote: For example: If cell A1 equals 1, then cell B1 should have the value 5, otherwise B1 should be 6. By setting a condition in A1, I am affecting B1. Is that possible? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can Cell X be modified by Cell Y?
In b1 you would need to put a formula
=if(A1=1,5,6) The formula will go in the cell that displays the results - the cell that will be affected. -- Regards, Tom Ogilvy "alMandragor" wrote in message ... For example: If cell A1 equals 1, then cell B1 should have the value 5, otherwise B1 should be 6. By setting a condition in A1, I am affecting B1. Is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Last Modified date on cell or column | Excel Discussion (Misc queries) | |||
| Display a Date when a cell is Modified | Excel Worksheet Functions | |||
| Show date cell modified | Excel Worksheet Functions | |||
| In adjacent cell, show last date modified of target cell. | Excel Discussion (Misc queries) | |||
| Sheet Modified date in a cell.. ? | Excel Worksheet Functions | |||
Hybrid Mode
