View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teddy-B Teddy-B is offline
external usenet poster
 
Posts: 76
Default Validation Formula

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!