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 ...
I figured it out:
=IF(OR(CELL1=CELL3,CELL1=CELL4),TRUE,IF(OR(CELL2=CELL3,CELL2=CELL4),TRUE))