IF function help - cant work it out!

[Lehany]

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!

[Lehany]

Ah, sorry, pelase ignore me. It now works. Not sure what I did but it works.

OOps. Sorry, dont know how to delete this thread.