Problem with an IF formula

[gillmcc]

Hi Folks,

Sorry for the stupidity of this question, I'm a complete noob to formulas in Excel!

I am looking for a formula that says "If cell D20 contains the letter Y then return the number 1, if the cell contains the letter N then return 0"
Or it could be written along the lines of "If cell D20 contains Y, Yes, yes or YES then return 1, otherwise return 0."

Can anyone help me?

Thanks!

[Kevin UK]

Hi gillmcc

Try:
=IF(D20="Y",1,IF(D20="N",0,""))

[gillmcc]

Thanks Kevin! That worked perfectly!

Much appreciated! :-)