Formula is not working, What is wrong?

[Tympos]

Hello all, have a happy new year!!!
I have created this formula:
=IF(OR(AND(K9="A";P9<>"");AND(K9<>"A";P9="");AND(N9="A";P9<>"");AND(N9<>"A";P9=""));"✓";"X")

Please note that in my country settings we use ";" insteaf of ","

What I am trying to do is have a "✓" at a specifi cell, when the following is true:
K9="A" AND P9 is not empty
OR
K9 is anything else than "A" AND P9 is empty
OR
N9="A" AND P9 is not empty
OR
N9 is anything else than "A" AND P9 is empty

and when none of the above 4 rules is true, I want to get the "X" value.

However, it seems there is a problem, because it's not working as I want.
Do you find an obvious mistake I have made that I can not see? Somethin else?

Thank you very much

[etaf]

looks ok to me
perhaps we need an example to see where its not working

with no entry you will get a Tick
as K9 does not = A and P is blank

Do you want to test to see if K9 <> A - it is not blank ? as a blank is NOT an A and so if P is blank and K is blank - will return a TRUE
same for other AND()

Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet.

A sample sheet would help here

The forum does allow for spreadsheets to be uploaded direct to the forum -

Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[Tympos]

Ok, I think I found something. The cells K9, P9 an N9 are populated from a list, as validated data.
This list contains an empty cell at the begining. So these 3 cells seem "null" since they take the first empty cell of the list, but they are not "null" according to excel.
Is there a workaround for this problem?

I don't think there is a need to post the spreadsheet at the moment, which by the way has some confidential data. If needed I will modify it and upload it.
Thank you again.

[TMS]

If needed I will modify it and upload it.

If it wasn’t needed, it wouldn’t be asked for. Without it, it is pretty much guesswork. Delete or replace the confidential data.

[etaf]

as stated need to see whats in the sheet -

So these 3 cells seem "null" since they take the first empty cell of the list, but they are not "null" according to excel.

we wont know what maybe in the list
K9, P9 an N9
when P9 is showing a null
if you just use in a cell
=P9=""
do you get TRUE or FALSE
same for
=ISBLANK(P9)

Also where the Data validation list - check the source list
it maybe as simple as a space - which you can tell in the formula bar when in the list


otherwise - you will need to show a sample here

just a mock up with data validation list
as you can see
NULL or blank in K9 - is TRUE for Isblank(k9) and =K9=""

so something else is going on in your file

[Tympos]

Thank you guys, problem solved. Indeed the list contained some cells with spaces.
Thank you again, etaf you are great!!!

[etaf]

you are welcome
Space may have been used to appear in the dropdown list , if still needed then , you could just add an OR()
(AND(K9="A";OR(P9<>"",P9<>" "))