Problem with an If( or ...statement

[still learning]

Hi

I’m trying to write an If(or …. Statement

The statement is going to be put in D1

What I need is if A1 has a date or B1 has a date then return blank (“”)

If A1 is blank and B1 is blank. Return 1

=if(or(A1=””,B1=””,””,+1)

Mike

 

[Michael M]

Try this way

=IF(AND(A1="",B1=""),1,"")

 

[still learning]

Try this way

=IF(AND(A1="",B1=""),1,"")

Yep it works perfect
Thank you Mke

mike

 

[Michael M]

Pleasure...glad to help..