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