Multiple IF formulas
this works... :) thank you very much.
--
Debmil
"Jim Cone" wrote:
Further:
And maybe this is what you wanted ?...
=IF(MIN(S2,W2,AA2)<=J2,IF(AND(S2<W2,S2<AA2),P2,IF( AND(W2<S2,W2<AA2),T2,IF(AND(AA2<S2,AA2<W2),X2,"Tie "))),"None")
--
Jim Cone
Portland, Oregon USA
|