View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roadkill roadkill is offline
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")