Dropdown list

[Sherif]

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

 

[Fleone]

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]

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]

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?