IF formula

[Nemeo]

I’m trying to formulate an IF function but I am having trouble the conditions are as follows: IF five cells e.g. C1:C5 contain the numbers 1,2 & 3 then condition “C” IF five cells do not contain one of the 3 numbers then condition “B”. I would also like to know if this can be done with 7 cells e.g. D1:D7 the conditions are IF cells contain letters L, M & H then condition “C” IF cells do not contain one of the three letters then condition “B” The source from the five and seven cells are VLOOKUPS, I hope this is clear can anybody help me?

Thanks in advance.

[BigBas]

You can try something like this:

=IF(AND(COUNTIF(C1:C5,1)>=1,COUNTIF(C1:C5,2)>=1,COUNTIF(C1:C5,3)>=1),"C","B")

Try that and let me know if it works.

[Nemeo]

Thanks for the reply, the 5 cell count works but I'm having difficulty trying to configure formula for the 7 cell count, I've tried replacing the letters with numbers but it hasn't worked. If you could offer any further assistance I would be grateful. But thank you for your help so far.