IF And Boolean True / text true

[Cervani]

Hi guys,

I have Excel file to check.
If and value = true and this value = ""

Problem is that my spreadsheet has true as a text and TRUE Boolean values.

IF doesn't work with later.

Is there a way to sort it please

 

[Siddharth Rout]

Is this what you are trying?

=IF(OR(A1,A1="TRUE"),TRUE,FALSE)

 

[Cervani]

If(and(A1="TRUE",C1=""),"Change","Correct")

A1 is Boolean True in my case. I want to get "change" but it's showing me "correct"

 

[Siddharth Rout]

If(and(A1="TRUE",C1=""),"Change","Correct")

A1 is Boolean True in my case. I want to get "change" but it's showing me "correct"

If A1 is Boolean True then you do not need quotes.

=IF(AND(A1=TRUE,C1=""),"Change","Correct")

And if it is Text, then try this

=IF(AND(OR(A1,A1="TRUE"),C1=""),"Change","Correct")

 

[Cervani]

=IF(AND(OR(A1,A1="TRUE"),C1=""),"Change","Correct")

That works for me. Thank You

If anyone needs that I can tell that having 100k rows this works only if I activate specific cell.
Creating that in row 1 and dragging/double click down doesn't work.
I solved it by

find-replace = into =