This gives you the low bidder only, not whether it is <= to the limit...
=IF(AND(S2<W2,S2<AA2),P2,IF(AND(W2<S2,W2<AA2),T2,I F(AND(AA2<S2,AA2<W2),X2,"Tie")))
--
Jim Cone
Portland, Oregon USA



"Dmiller"

wrote in message

I am trying to create formula in cell L2 that reflectes 3 bids. The formula
I am use works at 2 levels not 3. This is the formula I am using
=if(s2<=J2,p2)=if(w2<=j2,t2)=if(aa2<=j2,x2). Steps 1 & 2 are false, 3 is
ture but I get a #vaule in the field. What am I missing in the multiple step
formula?
I want to be able to select the contractor that is less than or equal to my
approved dollar amount.
thanks,
--
Debmil