Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex Data Validations
Hello...
I am trying to create a form spreadsheet with many different formulas and validations... My stumping point is the following: In Cells E43:E60 I have dropdown lists (each cell contains the same list). Cells E43:E60 - content: Validation - Dropdown list (exact same list in all of these cells) Cells N43:N60 - content: User entry cell for Qty. Cells P43:P60 - content: Units Cells S43:S60 - content: My problem (see below) Cells Z43:Z60 - content: Formula for total cost My problem: I need a validation in the "S" cells to do the following: When an item is selected in the dropdown list in E43 - I need S43 to be less than or equal to a $$ amount. Everything in the dropdown list has different MAX allowable amounts - so to just enter one amount is not going to work. I've been playing with the validation formulas - but can't seem to get any to work in the entire range needed. TIA, TC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex Data Validations
Nevermind - I figured it out.
-----Original Message----- Hello... I am trying to create a form spreadsheet with many different formulas and validations... My stumping point is the following: In Cells E43:E60 I have dropdown lists (each cell contains the same list). Cells E43:E60 - content: Validation - Dropdown list (exact same list in all of these cells) Cells N43:N60 - content: User entry cell for Qty. Cells P43:P60 - content: Units Cells S43:S60 - content: My problem (see below) Cells Z43:Z60 - content: Formula for total cost My problem: I need a validation in the "S" cells to do the following: When an item is selected in the dropdown list in E43 - I need S43 to be less than or equal to a $$ amount. Everything in the dropdown list has different MAX allowable amounts - so to just enter one amount is not going to work. I've been playing with the validation formulas - but can't seem to get any to work in the entire range needed. TIA, TC . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validations | Excel Worksheet Functions | |||
2 Data Validations Q | Excel Worksheet Functions | |||
data validations | Excel Discussion (Misc queries) | |||
3 data validations | Excel Worksheet Functions | |||
Combine 2 Data Validations Q | Excel Worksheet Functions |