thanks, got if figured out.
--
Debmil


"Charabeuh" wrote:

Don't understand what you really want to do.

perhaps:
=and (if(s2<=J2,p2)=if(w2<=j2,t2),if(w2<=j2,t2)=if(aa2< =j2,x2))




"Dmiller" a écrit dans le message de
...
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