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

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/