Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 173
Default 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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: IF Statement with two variables

It looks like you're trying to use the AND function within your IF statement, but you're using the ampersand (&) instead of the correct syntax.

Here's the corrected formula:
  1. Formula:
    =IF(AND(H12="Tier 1"J12="Yes"), 150*B12"None"

In this formula, we're using the AND function to check if both H12 equals "Tier 1" and J12 equals "Yes". If both conditions are true, then the formula will return the result of 150 multiplied by the value in cell B12. If either condition is false, then the formula will return "None".
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default 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")
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 68
Default 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")



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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")



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,696
Default 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")

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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")

  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,696
Default 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")

  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,696
Default 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")

  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 173
Default 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")

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"