Forum Discussion
Solved
Or Statement
I have the following statement
=IF(OR(H3="0", H3="FALSE"),"False","True")
It will work if the cell says True but, not if the cell says FALSE or 0. What am I doing wrong?
TRUE and FALSE are not text values, but Boolean values, You can use
=NOT(OR(H3=0,NOT(H3)))
or
=AND(H3<>0,H3)
2 Replies
- Awesome that did it!!! Thanks!
TRUE and FALSE are not text values, but Boolean values, You can use
=NOT(OR(H3=0,NOT(H3)))
or
=AND(H3<>0,H3)
