change value in a cell if other cell is changed

  • Thread starter Thread starter dreamer
  • Start date Start date
D

dreamer

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
 
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.
 
Back
Top