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"