IF statement help

Khari Shiver

Hello,

I'm trying to write an IF statement that checks three cells to determine if the values are equal and excluded blank cells. Below are the scenarios:

cell 1, cell 2, and cell 3 all have the same value (not blank) = Yes

cell 1 and cell 2 have the same value (not blank) = Yes

I thought I could use: =IF(OR([cell 1]@row = [cell 2]@row, (AND([cell 1]@row = [cell 2]@row = [cell 3]@row, [cell 2]@row <> ""))), "Yes", "No")

where the OR portion compares cell 1 and cell 2 and the AND portion evaluates all three together. I feel like I'm chasing my tail a bit here. Any help would be greatly appreciated.

Thank you.

Kelly Moore

Hey @Khari Shiver

Try this

=IF(OR([cell 1]@row = [cell 2]@row, AND([cell 1]@row = [cell 2]@row = [cell 3]@row, [cell 2]@row <> "")), "Yes", "No")

Kelly