Hi,
I cant work out what I'm doing wrong! This should be a simple formula. I need to create a formula that says if either of G17 or H17 = N then type 'No'. If they both = Y then type 'Yes'. I have:
=IF(OR(G17="N",H17="N"),"No","Yes")
But it doesnt work. It just appears in the cell as text. What am I doing worng?
Thanks!
Bookmarks