Excel "if" for letters to equal values

Question

Excel "if" for letters to equal values

[Solved/Closed]

Report

Charles - Jun 9, 2011 at 08:52 AM
TrowaD

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

- 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
Excel change column letters to numbers - How-To - Excel
Excel, IF fuction with cell text values? ✓ - Forum - Excel
Automate Excel to shift data so the values in two rows match? ✓ - Forum - Excel
Excel vba find and copy cell values ✓ - Forum - Programming
Excel macro to copy and paste values if criteria are met ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2011-06-09T09:18:47-0400

Answer 1 / 1

TrowaD

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

486
Jun 9, 2011 at 09:18 AM

Hi Charles,

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

Best regards,
Trowa

Excel "if" for letters to equal values

1 reply

Your reply

Subscribe To Our Newsletter!