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"