Home

Associate a word with a number formula in Excel

daniela85
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

It could be like

=--(A1="Yes")

if assume you have only Yes or No

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies