Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
Hi,
I have a dropdown list containing 6 values from (7 to 12) when I select value from the list 2 cells containing the IF function are checked to see if the value is true or false. What I need is that Excel automatically checks the 6 values in ascending order whichever value satisfies both IF function to be true than excel will stop at the first value that satisfy this logical IF functions. Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
What is the IF function that you are calling? Is the IF function in your list
of values? I am not sure I understand what you are asking. "Sherif" wrote: Hi, I have a dropdown list containing 6 values from (7 to 12) when I select value from the list 2 cells containing the IF function are checked to see if the value is true or false. What I need is that Excel automatically checks the 6 values in ascending order whichever value satisfies both IF function to be true than excel will stop at the first value that satisfy this logical IF functions. Thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
The first argument is =IF(AS4<=AR4,TRUE,FALSE)
The Second argument is =IF(AQ4<=200,TRUE,FALSE) What I want is whichever value from the drop down list that gives a True answer to both of the above arguments than this is the right answer. "Fleone" wrote: What is the IF function that you are calling? Is the IF function in your list of values? I am not sure I understand what you are asking. "Sherif" wrote: Hi, I have a dropdown list containing 6 values from (7 to 12) when I select value from the list 2 cells containing the IF function are checked to see if the value is true or false. What I need is that Excel automatically checks the 6 values in ascending order whichever value satisfies both IF function to be true than excel will stop at the first value that satisfy this logical IF functions. Thanks in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
I'm still not completely sure I understand what you are looking for, but this
what I came up with. A B C D E F List Dropdown True/false list 1 list 2 list 3 7 11 FALSE 1 7 8 8 TRUE 2 8 10 9 3 9 12 10 4 10 14 11 5 11 16 12 6 12 18 Column A contains the list from 7 to 12. Column B, Cell 1 is a Dropdown list validated by the list in Column A. Column C are the True/False statements that look at D, E, and F (I noticed that your if statements are comparing 3 columns of data) Column D and E are numbers, column F is the sum of Column D and E. If you select one of the numbers from the drop down list (7-12) Column C will show either true or false depending on the result. Is this what you are looking to accomplish? "Sherif" wrote: The first argument is =IF(AS4<=AR4,TRUE,FALSE) The Second argument is =IF(AQ4<=200,TRUE,FALSE) What I want is whichever value from the drop down list that gives a True answer to both of the above arguments than this is the right answer. "Fleone" wrote: What is the IF function that you are calling? Is the IF function in your list of values? I am not sure I understand what you are asking. "Sherif" wrote: Hi, I have a dropdown list containing 6 values from (7 to 12) when I select value from the list 2 cells containing the IF function are checked to see if the value is true or false. What I need is that Excel automatically checks the 6 values in ascending order whichever value satisfies both IF function to be true than excel will stop at the first value that satisfy this logical IF functions. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown List | New Users to Excel | |||
Dropdown list doesn't display from the top of the list | Excel Discussion (Misc queries) | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions |