Hi gillmcc

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