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

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

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
---------------
Jacob Skaria


"Dmiller" wrote:

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

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

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

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

got it thanks,
--
Debmil


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Dmiller" wrote:

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

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

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"

wrote in message
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