Previous Topic Next Topic

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 December 27, 2022 - 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?

Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 9, 2011 at 09:18 AM
Hi Charles,

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

Best regards,
Trowa
0

Similar discussions

How to get capital letter in Nokia 2700 model
ppn -
ruby -

2 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses