Excel "if" for letters to equal values

[Solved/Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hello,

I have a yes or no sheet, one column for yes and one column for no. I want the end column to calculate a 1 for yes, and 0 for no, and in some cases have them reversed for negative questions. How do I perform this function?

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Charles,

Try this:
=IF(A1="yes",1,IF(B1="no",0,""))

Best regards,
Trowa