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?

Excel "if" for letters to equal values
Keyboard not typing letters - Guide
Excel date format dd.mm.yyyy - Guide
Transfer data from one excel worksheet to another automatically - Guide
Number to words in excel - Guide
Kernel for excel - Download - Backup and recovery

1 reply

Answer 1 / 1

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

Subscribe To Our Newsletter!