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
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Number to words in excel - Guide
- Excel marksheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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
