My IF/OR formula isn't working and I don't know why. If either column says TRUE in it, I want a third column to say TRUE.
Here's my formula:
=IF((OR(I3="TRUE",J3="TRUE")),"TRUE","FALSE")
But it will only return FALSE even when one of the columns says TRUE.
What am I doing wrong?
Bookmarks