Adding different validations based on condition

S

Solis

How do I add two different validations based on the condition of another
cell? (i.e. If cell A1 has a value of "X", then cell A2 cannot exceed
$1000.00, but if cell A1 has a value of "Y", then cell A2 cannot exceed
$500.00)
 
J

JE McGimpsey

One way:

Allow: Custom
Formula: =IF(A1="X",A2<=1000,IF(A1="Y",A2<=500))

Note, this won't allow any entry if A1 is anything other than X or Y
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB code. If statement between two values 1
How to have conditional dropdown 1
Need help calculating probabilities 7
countif function 4
How to I set a limit on the value returned by a cell 3
validate date entered 3
error message "#VALUE!" due to blank cells 3
Conditional Formatting 2

Top