Remember Me?

#1
October 16th 08, 07:41 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 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
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 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
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 68
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
October 16th 08, 07:51 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
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
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 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
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
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
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 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
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 1,696
IF Statement with two variables

Please see myriad responses to your post from a couple minutes ago. Should
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
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 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 Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post JMay-Rke Excel Discussion (Misc queries) 11 July 4th 08 06:36 PM wheefus Excel Worksheet Functions 7 December 17th 07 07:26 PM Krista Excel Discussion (Misc queries) 3 May 12th 06 10:58 PM repke New Users to Excel 3 May 2nd 06 05:01 PM Tom from Ga Excel Worksheet Functions 2 February 6th 06 09:08 PM

All times are GMT +1. The time now is 04:47 AM.