|
seanreay1986
|
posted on 1st Mar 05 at 22:53 |
the first two cells will have dates in them and when i put a date in the third cell i automatically want it to delete the first two cells. Could anyone do a quick example for me please.
|
Ian
|
posted on 1st Mar 05 at 22:43 |
In the cell you want clearing:
=IF (A1<>"","","hello")
ie. if A1 not equal to nothing then cell you're in is set to "" else its set to say hello.
|
Swiftie
|
posted on 1st Mar 05 at 22:41 |
Believe you may need to dable in VB coding for this.
But I could be proven wrong.
|
seanreay1986
|
posted on 1st Mar 05 at 22:38 |
in excel i am making a spreadsheet and i want to put a formula in so that when one of the cells is populated another 2 cells are cleared.
Thanks
|