Thread
:
IF Statement with two variables
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Glenn
external usenet poster
Posts: 1,240
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")
Reply With Quote
Glenn
View Public Profile
Find all posts by Glenn