What did you enter in K10, and what did you try to enter in M10?

In what way do you think that T Valko's formula differs from your
requirement? It seems to do exactly what you asked for. Perhaps you'd
better check that you've entered the formula correctly. Did you copy and
paste, or did you try to retype it?

Note that if you enter a valid entry in M10 but then change K10, the M10
validation condition will not be checked again until you try to edit M10
again, so you may wish to impose a validation condition on K10 too.
--
David Biddulph

"Teddy-B" wrote in message
...
Thanks T.Valko, but this did not work. I am setting custom validation for
cell M10. when I entered your formula as validation, excel would not allow
me
to enter anything into the cell (M10).
I need to set the following validation requirements in cell (M10):

IF K10 = "MB" then M10 can only be Cash,Chips,or Check.
and
If K10 <"MB" then M10 can only be Chips.

"T. Valko" wrote:

Try this:

=OR(AND(K10<"MB",M10="Chips"),AND(K10="MB",OR(M10 ="Cash",M10="Check",M10="Chips")))

--
Biff
Microsoft Excel MVP


"Teddy-B" wrote in message
...
Hi everyone. I need a validation formula that will allow (only) the
word
"CHIPS" in the validation cell if cell A1<"MB". If Cell A1="MB", then
the
words "CASH, CHIPS, or CHECK" (only) may be entered.

Please help- "Thanks"