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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 9, 2011 at 09:18 AM
Related:
- Excel "if" for letters to equal values
- Keyboard won't type letters - Guide
- Keyboard letters not working but numbers are - Guide
- 1,000 business letters pdf free download - Download - Other
- Number to words in excel - Guide
- Excel date format dd.mm.yyyy - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 9, 2011 at 09:18 AM
Jun 9, 2011 at 09:18 AM
Hi Charles,
Try this:
=IF(A1="yes",1,IF(B1="no",0,""))
Best regards,
Trowa
Try this:
=IF(A1="yes",1,IF(B1="no",0,""))
Best regards,
Trowa
