Forum Discussion
Need Formula: IF (CELL1 or CELL2) = (CELL3 or CELL 4) then TRUE.
Hello! I'm just getting my feet wet with formulas in Excel and I think I need a nested IF/OR formula. Basically I want to compare two sets of cells. If there are any matches between the cells, I ...
Hi Troy,
You can expand the OR function with two more logical tests as follow:
=IF(OR(A1=A3, A1=A4, A2=A3, A2=A4),TRUE,FALSE)
Update:
You don't have to nest another IF as you did in your reply above.
I hope this helps you
Regards
Thank you! Your formula is much less complicated. Cheers!