ExcelBanter - Validation Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Validation Formula (https://www.excelbanter.com/excel-discussion-misc-queries/174015-validation-formula.html)

Teddy-B

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!

J. Sperry[_2_]

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!

All times are GMT +1. The time now is 03:15 PM.