Checking values match where one cell may be empty

Topic Labels: Formulas
Solved
872 2
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hi!

I am building some QA into my Base, and have x4 date columns that I want to check all equal each other.

To ensure the first x3 dates equal each other I have used:

IF(AND({Date 1}={Date 2},{Date 2}={Date 3}),“Match”,“Not match”)

I think that is right and seems to work well.

This all works fine, but the issue I have is that the {Date 4} column doesn’t always have a value (intentionally), and hence I want to ignore it in the date comparison if not populated.

i.e. if {date 1}={date 2}={date 3} but {date 4} is empty, the formula should still return “Match” to signify that all dates match.

I’m sure this is very simple, but I’ve tried multiple different IF statements and quite simply can’t get it to work!

Any help would be greatly appreciated :slightly_smiling_face:
Thanks.

1 Solution

Accepted Solutions
9 - Sun

Hello @Luke_Branford1!

I believe the following should do the trick:

``````IF(NOT({Date 4}),
IF(
AND({Date 1}={Date 2},{Date 2}={Date 3}),
"Match",
"Not match"
),
IF(
AND({Date 1}={Date 2},{Date 2}={Date 3}, {Date 3} = {Date 4}),
"Match",
"Not match"
)
)
``````

2 Replies 2
9 - Sun

Hello @Luke_Branford1!

I believe the following should do the trick:

``````IF(NOT({Date 4}),
IF(
AND({Date 1}={Date 2},{Date 2}={Date 3}),
"Match",
"Not match"
),
IF(
AND({Date 1}={Date 2},{Date 2}={Date 3}, {Date 3} = {Date 4}),
"Match",
"Not match"
)
)
``````