EXACT formula help with blank cells

[Joshua_Cooper]

Hi,

I had some help earlier with this one, but I have missed something that I need to have changed.

The current formula;

=IF(OR($A$1="",B1=""),"",EXACT($A$1,B1))

The EXACT part of the formula works as it should.
If A1 is blank the formula works as it should.

Where I get stuck is that if A1 has a date and B1 is blank I don't get a "FALSE" statement.

Can someone help me out here?

Thanks in advance.

[Brumbot]

Hi Josh,

The start of your formula states that if either A1 or B1 is blank, return blank, and since you're saying B1 is blank, your formula will return blank, not false. It doesn't even get to the 'EXACT' part of the formula since the first half is true. If you're expecting a different result then you will need to give some more information about your expected results.

[sandy666]

you can try this one:
=IF(AND($A$1="",B1=""),"",IF(AND($A$1<>"",B1=""),FALSE,EXACT($A$1,B1)))

or just for fun:
=IF(AND($A$1="",B1=""),"",IF(XOR($A$1<>"",B1=""),EXACT($A$1,B1),FALSE))
XOR() - Excel 2013 and above
or
=IFERROR(IF(AND($A$1,B1),EXACT($A$1,B1)),"")

[Joshua_Cooper]

Thanks again sandy666

had to use the top line due to this company using excel 2007.

[sandy666]

You are welcome
third option is shortest

and as usual...
If that takes care of your.... etc....