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.

 IF Statement with two variables
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## IF Statement with two variables

#1
October 16th 08, 07:41 PM posted to microsoft.public.excel.worksheet.functions
 roadkill external usenet poster Posts: 173
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")
#2
October 16th 08, 07:46 PM posted to microsoft.public.excel.worksheet.functions
 Glenn external usenet poster Posts: 1,240
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")

=IF(AND(H12="Tier 1",J12="Yes"),(150*B12),"None")
#3
October 16th 08, 07:47 PM posted to microsoft.public.excel.worksheet.functions
 Bob Umlas[_2_] external usenet poster Posts: 68
IF Statement with two variables

=IF(AND(H12="Tier 1",J12="Yes"),150*B12,"None")
Bob Umlas
Excel MVP

...
> 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
October 16th 08, 07:51 PM posted to microsoft.public.excel.worksheet.functions
 Mike H external usenet poster Posts: 11,504
IF Statement with two variables

Hi

& is the concatenate symbol yo want AND

=IF(AND(H12="Tier 1",J12="Yes"),(150*B12),"None")

Mike

> 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
October 16th 08, 07:53 PM posted to microsoft.public.excel.worksheet.functions
 Sean Timmons external usenet poster Posts: 1,696
IF Statement with two variables

Or if you want to be fancy:

=IF(H12&J12="Tier 1Yes",150*B12,"None")

"Glenn" 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
October 16th 08, 08:06 PM posted to microsoft.public.excel.worksheet.functions
 Mike H external usenet poster Posts: 11,504
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:
>
> > > 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
October 16th 08, 08:11 PM posted to microsoft.public.excel.worksheet.functions
 Sean Timmons external usenet poster Posts: 1,696
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:
> >
> > > > 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
October 16th 08, 08:13 PM posted to microsoft.public.excel.worksheet.functions
 Sean Timmons external usenet poster Posts: 1,696
IF Statement with two variables

cover you.

> 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
October 16th 08, 09:01 PM posted to microsoft.public.excel.worksheet.functions
 roadkill external usenet poster Posts: 173
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:
>
> > > 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 Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Not at all clear on use of variables and/or object variables JMay-Rke 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 07: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 09:08 PM

All times are GMT +1. The time now is 10:00 PM.