I'm sure this is pretty basic... didn't seem to find an answer that's already posted though.
'Need some assistance with creating an IF statement that looks at two criteria.
Cell A1 = 5
Cell B1 = Mike
Cell A2 = 7
Cell B1 = Jack
if not example # 1 or #2, then 3
If (A1 <= 5 AND B1 = "Mike", then 1); Ifelse (A1 >5 AND B1 = "Jack", then 2; else 3)
Does anyone know how to construct the above formula?