If one cell contains this text and another contains that text then do this

[spoogehead]

Hi all

Wrestling with the count IF function but I'm stuck in trying to get to check two cells at the same time and then put a value in another cell. Is Lookup the right function to use here?

So basically:
A1 contains the text H (or h)
A2 contains the day of the week (Mon-Sat)

So I am looking for a check that:
If A1 contains H (or h) AND A2 contains Sat or Sun then the value returned is a numerical 12
If A1 contains H (or h) AND A2 contains Mon through Friday then the value returned is a numerical 8

If neither of the above conditions are met, then the cell is left blank

Thanks in advance!

 

[mikerickson]

Is A2 an excel date or a text value like "Mon"

If the latter
=IF(a1="h", IF(OR(A2="Sat",A2="Sun"), 12, 8), "h not in A1")

 

[Fluff]

How about
=IF(A1="h",IF(OR(A2={"Sat","Sun"}),12,IF(OR(A2={"Mon","Tue","Wed","thu","fri"}),8,"")),"")

 

[spoogehead]

Both of those work perfectly!

Thank you so much mikerickson and Fluff for your prompt help

 

[Fluff]

Glad we could help & thanks for the feedback.