View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas[_2_] Bob Umlas[_2_] is offline
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")