Hi
I would like to have the formula return the cell as blank when both Sheet1 & 2 cells H2 are both empty (if one or the other has data it should return false or true)
=IF(OR(AND(Sheet1!H2="Sell", Sheet2!H2="Buy"), AND(Sheet1!H2="Buy", Sheet2!H2="Sell")),"TRUE", "FALSE")
Thanks
Bookmarks