Simple "IF/AND" Formula Error

[CDSnyder]

I would greatly appreciate some help with this formula! It seems simple, but just doesn't work. I am comparing 2 cells - A2 and A3. Cell A2="FALSE" and cell A3="Built in OT"

I am using the formula =IF(AND(A2="FALSE",A3="Built In OT"),"ERROR","OK")


The formula should be returning a value of "ERROR" but it says "OK", which is not correct.



What am I doing wrong?

[alansidman]

Are there any leading or trailing spaces in either A2 or A3? That is the only thing I can think of without actually seeing the file. Read the yellow banner at the top of this page on how to attach your file.

[CDSnyder]

Here is the file. I think I uploaded it correctly, but if not, I'll try again

[Pete_UK]

A2 could contain the text value "FALSE", or the Boolean value FALSE, so try it without the quotes around FALSE in your formula as we don't have a sample file to check this out on.

Hope this helps.

Pete

[Pete_UK]

I can see that you have attached a file, and my guess was correct - use this in cell A5:

=IF(AND(A2=FALSE,A3="Built In OT"),"ERROR","OK")

Hope this helps.

Pete

[CDSnyder]

That fixed it! Thank you very much!

[Pete_UK]

Glad to help. If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete