ivannamber
Reputation: 21
Convert TRUE or FALSE to Yes or No in REGEXMATCH
How to convert boolean True or False to "Yes" or "No" in Google Sheets?
=REGEXMATCH(A1;"word")
Upvotes: 2
Views: 1345
Answers (2)
player0
Reputation: 1
for a single cell:
=IF(A1="word"; "yes"; "no")
for a range of cells:
=ARRAYFORMULA(IF(A1:A10="word"; "yes"; "no"))
Upvotes: 1
Related Questions
- Logic Test to fins the True or false for set format
- "format" true/false to something like "yes/no" in Google Sheets
- Partial match between 2 column and output yes, no in another column
- Regex matching with yes/no
- MS Excel - How to format cell as Yes/No instead of TRUE/FALSE
- EXCEL replace "False" with the word "NO"
- VBA-Excel Converting "FALSE" string to "False"
- Get a yes, no, or nothing out of a cell in Excel
- Need Excel formula to return "Yes"/"No" instead of boolean
- Regex to match only two specific words, e.g. Yes or No