Hi there,
I'm trying to set up a formula that refers to 3 other cells, to display "1" where if one of the other cells (A4, B4, C4) shows "1".
I've tried this:
=IF(OR(A4=1,B4=1,C4=1), "1", "")
but nothing doing!?
Not sure if this has anything to do with it, but the contents of cells A4, B4, C4 are all as a result of single IF formulas.
Help please!
Bookmarks