IF Statement

[jimmyaja123]

Hello,

I have made a formula to check if two columns are true then it should return as ok or not ok.

=IF+(OR(A3="TRUE",B3="TRUE"),"OK","Not OK")

However everything is returning as not ok even when both columns are 'True'

Can someone help?

 

[maabadi]

Because of True & False Destinguish as Boolean Parameter you don't need " at the first & end
Then Try this:

=IF((A3=TRUE)*(B3=TRUE),"OK", "Not OK")

 

[jimmyaja123]

Thanks!

 

[maabadi]

You're Welcome & Thanks for Feedback.