Jan 30 2019 08:31 AM
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".
Jan 30 2019 10:13 AM
It could be like
=--(A1="Yes")
if assume you have only Yes or No