If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




IF Statement with two variables
I've gone brain dead on this.
Here is my formula, what am I doing wrong? Thanks =IF(H12="Tier 1" & J12="Yes",(150*B12),"None") 
Ads 
#2




IF Statement with two variables
RoadKill wrote:
> I've gone brain dead on this. > > Here is my formula, what am I doing wrong? > > Thanks > > =IF(H12="Tier 1" & J12="Yes",(150*B12),"None") =IF(AND(H12="Tier 1",J12="Yes"),(150*B12),"None") 
#3




IF Statement with two variables
=IF(AND(H12="Tier 1",J12="Yes"),150*B12,"None")
Bob Umlas Excel MVP "RoadKill" > wrote in message ... > I've gone brain dead on this. > > Here is my formula, what am I doing wrong? > > Thanks > > =IF(H12="Tier 1" & J12="Yes",(150*B12),"None") 
#4




IF Statement with two variables
Hi
& is the concatenate symbol yo want AND =IF(AND(H12="Tier 1",J12="Yes"),(150*B12),"None") Mike "RoadKill" wrote: > I've gone brain dead on this. > > Here is my formula, what am I doing wrong? > > Thanks > > =IF(H12="Tier 1" & J12="Yes",(150*B12),"None") 
#5




IF Statement with two variables
Or if you want to be fancy:
=IF(H12&J12="Tier 1Yes",150*B12,"None") "Glenn" wrote: > RoadKill wrote: > > I've gone brain dead on this. > > > > Here is my formula, what am I doing wrong? > > > > Thanks > > > > =IF(H12="Tier 1" & J12="Yes",(150*B12),"None") > > > > =IF(AND(H12="Tier 1",J12="Yes"),(150*B12),"None") > 
#6




IF Statement with two variables
Fancy is fine if having "T" in H12 and "ier 1Yes" in J12 or any other of the multiple other combinations is OK. I prefer evaluating the 2 conditions set out by the OP "Sean Timmons" wrote: > Or if you want to be fancy: > > =IF(H12&J12="Tier 1Yes",150*B12,"None") > > "Glenn" wrote: > > > RoadKill wrote: > > > I've gone brain dead on this. > > > > > > Here is my formula, what am I doing wrong? > > > > > > Thanks > > > > > > =IF(H12="Tier 1" & J12="Yes",(150*B12),"None") > > > > > > > > =IF(AND(H12="Tier 1",J12="Yes"),(150*B12),"None") > > 
#7




IF Statement with two variables
Well, sure, though the likelihood of that error would be relatively low, it
also would allow for such things as matching full names where middle may be in one of two cells. Guess it all depends on the goal of the formula... "Mike H" wrote: > > Fancy is fine if having "T" in H12 and "ier 1Yes" in J12 or any other of the > multiple other combinations is OK. I prefer evaluating the 2 conditions set > out by the OP > > > > "Sean Timmons" wrote: > > > Or if you want to be fancy: > > > > =IF(H12&J12="Tier 1Yes",150*B12,"None") > > > > "Glenn" wrote: > > > > > RoadKill wrote: > > > > I've gone brain dead on this. > > > > > > > > Here is my formula, what am I doing wrong? > > > > > > > > Thanks > > > > > > > > =IF(H12="Tier 1" & J12="Yes",(150*B12),"None") > > > > > > > > > > > > =IF(AND(H12="Tier 1",J12="Yes"),(150*B12),"None") > > > 
#8




IF Statement with two variables
Please see myriad responses to your post from a couple minutes ago. Should
cover you. "RoadKill" wrote: > I've gone brain dead on this. > > Here is my formula, what am I doing wrong? > > Thanks > > =IF(H12="Tier 1" & J12="Yes",(150*B12),"None") 
#9




IF Statement with two variables
Works great, thanks Sean.
"Sean Timmons" wrote: > Or if you want to be fancy: > > =IF(H12&J12="Tier 1Yes",150*B12,"None") > > "Glenn" wrote: > > > RoadKill wrote: > > > I've gone brain dead on this. > > > > > > Here is my formula, what am I doing wrong? > > > > > > Thanks > > > > > > =IF(H12="Tier 1" & J12="Yes",(150*B12),"None") > > > > > > > > =IF(AND(H12="Tier 1",J12="Yes"),(150*B12),"None") > > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Not at all clear on use of variables and/or object variables  JMayRke  Excel Discussion (Misc queries)  11  July 4th 08 06:36 PM 
how do i if statement for 3 variables  wheefus  Excel Worksheet Functions  7  December 17th 07 08:26 PM 
Conditional Statement with many variables  Krista  Excel Discussion (Misc queries)  3  May 12th 06 10:58 PM 
Too many variables for an if than statement?  repke  New Users to Excel  3  May 2nd 06 05:01 PM 
Using variables as first and last cells in range statement  Tom from Ga  Excel Worksheet Functions  2  February 6th 06 10:08 PM 