It looks like a simple question but I can not find the answer anywhere. I have a spreadsheet that contains columns with TRUE or FALSE whose boolean values are visible in the formula area, they appear as = TRUE () or = FALSE (). If I convert them to text, they display as 1 or 0, but in the formula field they still appear as = TRUE () or = FALSE ().
What I want to do is text them all 1 or 0. so I can use an IF statement on them in another area.
Alternatively, how do I use the IF statement on boolean values?
The room you want to say is correct or false, should it:
= IF (ISNUMBER (FIND ("1", A1)), "TRUE", "FALSE") if cell in "A1" in 1 Is TRUE ... otherwise incorrect
Comments
Post a Comment