Need to add more formula
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.
|