View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dmiller Dmiller is offline
external usenet poster
 
Posts: 4
Default 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