Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change value in a cell if other cell is changed
I have columns A and B that look like this:
5 80 5 79 5 81 etc... Now, what I want is to delete the value in column B if th corresponding value in column A is not 5. This doesn't seem to b difficult, but the problem is that I want the value in column B t return to default value if it's corresponding value in column A i changed back to 5. Is this possible -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
change value in a cell if other cell is changed
Hi
A cel can either contain a value OR a frmula, not both. So the cell can't contain a number, you need a formula like this =IF(A1=5,79,"") ... or you could use a third column with formulas in it and keep all values in B. -- HTH. Best wishes Harald Followup to newsgroup only please "dreamer " skrev i melding ... I have columns A and B that look like this: 5 80 5 79 5 81 etc... Now, what I want is to delete the value in column B if the corresponding value in column A is not 5. This doesn't seem to be difficult, but the problem is that I want the value in column B to return to default value if it's corresponding value in column A is changed back to 5. Is this possible? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to clear cell values, when a different cell is changed. | Excel Discussion (Misc queries) | |||
Format changed when the details in cell changed | Excel Worksheet Functions | |||
Change Colour on a Cell after another cell has been changed | Excel Discussion (Misc queries) | |||
in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
Cell comment boxes shouldn't change size/shape unless changed by u | Excel Discussion (Misc queries) |