Multiple IF formulas

[Dmiller]

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,

 

[Charabeuh]

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))

 

[Jacob Skaria]

Hi "Dmiller"

I am not sure I understood what you are looking at..If your conditions are
as below

If S2<=J2 then result is P2
else
If W2<=J2 then result is T2
else
If AA2<=J2 then result is X2

then try the below formula

=IF(S2<=J2,P2,IF(W2<=J2,T2,IF(AA2<=J2,X2)))


If this post helps click Yes

 

[Jim Cone]

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,IF(AND(AA2<S2,AA2<W2),X2,"Tie")))
--
Jim Cone
Portland, Oregon USA



"Dmiller"
<[email protected]>
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,

 

[Jim Cone]

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")

 

[Dmiller]

thanks, got if figured out.
--
Debmil

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]

got it thanks,
--
Debmil

Hi "Dmiller"

I am not sure I understood what you are looking at..If your conditions are
as below

If S2<=J2 then result is P2
else
If W2<=J2 then result is T2
else
If AA2<=J2 then result is X2

then try the below formula

=IF(S2<=J2,P2,IF(W2<=J2,T2,IF(AA2<=J2,X2)))


If this post helps click Yes

 

[Dmiller]

this works... thank you very much.

 

[Jim Cone]

You are welcome.
I've spent more time then most analyzing bid proposals.
I don't know whether Excel now makes it easier or not.

I do have a overwrought and never used Purchase
Analysis Program (workbook) that I wrote years ago.
It includes the cost of carrying inventory in making the buy decision.
Maybe somebody reading this would like to fight with it. <g>
--
Jim Cone
Portland, Oregon USA



"Dmiller"
<[email protected]>
wrote in message
this works... thank you very much.