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