Funtion IF, AND, OR

[girlyg]

Hello people,

I'm trying to make a list:
M
L
B
D
C

But what I want is that If I try to put M, L or B in the same column, it will show me and error like "Incorrect, Try again". And for example if i try to put M, D, C or any of the other combination it will send "OK", it doesn't have to be necessary in a message box, but it would be better.

I was using this:
=IF(OR(AND(A9:A11="M"),AND(A9:A11="L"),AND(A9:A11="B")), "Incorrect, Try Again","OK")

But when I try this it shows me Value!, what I want to know if this is right or do I have to use VBA (which I don't exactly remember how to use).

I don't think it's complicated, I just think I'm not sure how to write it

Thanks for your help.

 

[syntaxed]

This might work, however I am sure there's a more elegant / compact solution that I can't think of.

=IF(OR(AND(COUNTIF(A9:A11,"M"),COUNTIF(A9:A11,"L")),AND(COUNTIF(A9:A11,"M"),COUNTIF(A9:A11,"B")),AND(COUNTIF(A9:A11,"B"),COUNTIF(A9:A11,"L"))),"Incorrect, Try Again","OK")

 

[pgc01]

Hi

Your question is not clear. You don't say what you want in case a letter is repeated, or even if that's possible. For ex, the combination {"L","J","L"}, is it valid?

Please clarify.

Assuming letters do not repeat, try:

=IF(SUM(COUNTIF(A9:A11,{"M","L","B"}))>1,"Incorrect, Try Again","OK")