Help

Checking values match where one cell may be empty

Topic Labels: Formulas
Solved
Jump to Solution
664 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Luke_Branford1
5 - Automation Enthusiast
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
Rose_K
9 - Sun
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"    
    )
)

Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .

See Solution in Thread

2 Replies 2
Rose_K
9 - Sun
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"    
    )
)

Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .

Luke_Branford1
5 - Automation Enthusiast
5 - Automation Enthusiast

@Rose_K This worked like a charm, thank you so much, hugely appreciated :slightly_smiling_face: