Validation Formula

T

Teddy-B

Hi Everyone:

I need a validation formula that will allow (only) the word "Chips" in
cell M10 if K10<>"MB". If K10="MB" then allow (only) the words "Cash",
"Check" or "Chips".

Thanks for your help!
 
J

J. Sperry

For cell M10's data validation, allow values in a List, and the list's Source
(wherever you put it) can be the following:
1st cell, =IF(K10="MB","Cash","")
2nd cell, =IF(K10="MB","Check","")
3rd cell, Chips
 
Top