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