Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding different validations based on condition
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) |
#2
|
|||
|
|||
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 In article , "Solis" wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel problem with web based spreadsheets | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
Cannot sum values based on condition | Excel Worksheet Functions | |||
Add condition to formula | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |