Hi!

Ok, let's see what we have here.........

Which set of conditions has precedence?

Since each set returns different values one set has to be evaluated first
and your explanation doesn't really give any clue as to which set that is.

The formula could be written 2 ways:

=IF(COUNT(AD1),"Ber",IF(COUNT(AE1),"Cancel",IF(COU NT(W1),IF(AND(COUNT(J1,K1)=2,J1<=K1),"Yes","No")," ")))

=IF(COUNT(W1),IF(AND(COUNT(J1,K1)=2,J1<=K1),"Yes", "No"),IF(COUNT(AD1),"Ber",IF(COUNT(AE1),"Cancel"," ")))

In the first formula, the dates in cells AD1, AE1 have precedence.
In the second formula numbers in cells W1, J1 and K1 have precedence.

Biff

"roy.okinawa" wrote in message
...
I have this formula:
=IF(ISNUMBER(W1),IF(AND(ISNUMBER(J1),ISNUMBER(K1), J1<=K1),"Yes","No"),"")

Just as W, J and K must meet a criteria or it gives a "Yes" or "No", I
need
cells AD1 and AE1 added to this formula so it also gives a "BER" or
"Canceled" when a date is entered in to cells AD or AE.

W, J, K have the criteria of a Yes or No. AD will have the criteria of
BER
and AE is Canceled.