Excel "if" for letters to equal values

Solved/Closed
Charles - Jun 9, 2011 at 08:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 9, 2011 at 09:18 AM
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

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Jun 9, 2011 at 09:18 AM
Hi Charles,

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

Best regards,
Trowa
0