Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I include a "validation drop down" in a conditional statement?
I'm using Excel 2003 and trying to set up a situation where an "If" statement
would allow me to place a "validation drop down list" in the cell if the conditions of the if statement return a logical "true". That is, if I'm in cell B2, and my conditional is "=if(A20,XYZ,0), and cell A2 equals 1, I want to substitute a validation drop down for XYZ in the statement. Does anyone know if this is possible? Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I include a "validation drop down" in a conditional statement?
What are you really trying to do?
A validation dropdown isn't appropriate here, since it won't give the user a chance to change it while the cell is calculated... You could put the dropdown in another cell (say, C2) and use *that*: B2: =IF(A20,C2,0) In article , JanW wrote: I'm using Excel 2003 and trying to set up a situation where an "If" statement would allow me to place a "validation drop down list" in the cell if the conditions of the if statement return a logical "true". That is, if I'm in cell B2, and my conditional is "=if(A20,XYZ,0), and cell A2 equals 1, I want to substitute a validation drop down for XYZ in the statement. Does anyone know if this is possible? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions | |||
conditional formula to show "open" or "closed" | Excel Worksheet Functions |