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