Multiple IF formulas
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 |
Multiple IF formulas
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 |
Multiple IF formulas
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 |
Multiple IF formulas
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 |
Multiple IF formulas
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 |
Multiple IF formulas
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 |
Multiple IF formulas
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 |
Multiple IF formulas
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 |
Multiple IF formulas
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 |
All times are GMT +1. The time now is 03:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com