Associate a word with a number formula in Excel

Highlighted
Occasional Visitor

Hi, I am trying to create a formula wherein if someone enters "YES", it is associated with the number "1". If they enter "NO", then "0". 

1 Reply
Highlighted

It could be like

=--(A1="Yes")

if assume you have only Yes or No