Or Statement

[Nefe1930]

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?

[#2 · Accepted solution]

@Nefe1930 

TRUE and FALSE are not text values, but Boolean values, You can use

=NOT(OR(H3=0,NOT(H3)))

or

=AND(H3<>0,H3)

[#3]

Awesome that did it!!! Thanks!