Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Formula
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 "Teddy-B" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Formula | Excel Discussion (Misc queries) | |||
data validation with a formula | Excel Worksheet Functions | |||
Validation Formula | Excel Discussion (Misc queries) | |||
Validation Formula | Excel Discussion (Misc queries) | |||
data validation formula | Excel Discussion (Misc queries) |