If Cell is blank, then blank, and if another cell is not blank then blank

[chrisbottomley1981]

Hello,

I was wondering if you could help

I have Cell E4 with

=IF('Start Here'!AE6="","",'Start Here'!AE6)

and also F4 with

=IF('Start Here'!AF6="","",'Start Here'!AF6)

This pulls through dates

I would also like E4 to become blank if F4 pulls through a date .. so F4 will cancel out the content of E4 if F4 is not blank

I know I needs to add extra to =IF('Start Here'!AE6="","",'Start Here'!AE6) but I can't seem to find anything I understand on the web

Any assistance would be very gratefully appreciated

 

[Fluff]

Hi & welcome to MrExcel.
How about

 =IF(OR('Start Here'!AE6="",F4<>""),"",'Start Here'!AE6)

 

[chrisbottomley1981]

thank you!

I've realised a mistake on my part though .. I thought I could be clever by copying the formula to a third and fourth cell hoping that each would cancel out the last .. but when I get to the third cell, the first cell show's the date again ..

So I have one more than two date cells now,

E4, F4, G4 and H4

So I'm hoping that I could have

E4 shows a date to begin with
a new date is entered for the next stage of my process, and now If F4 is not blank, then E4 goes blank
a new date is entered for the next stage of my process, and now If G4 is not blank, then F4 and E4 goes blank
a new date is entered for the next stage of my process, and now If H4 is not blank, then G4, F4 and E4 go blank

 

[Fluff]

Ok, how about

 =IF(OR('Start Here'!AE6="",F4<>"",G4<>"",H4<>""),"",'Start Here'!AE6)
=IF(OR('Start Here'!AF6="",G4<>"",H4<>""),"",'Start Here'!AF6)

and similar for the other cells