IF statement with 2 or more text cells

[ohmedic88]

Having trouble writing an IF formula. I'm unsure how to reference a 2nd cell with text in my first logic statement. I'll try to recreate it below

	a	b
1	Within Limits	Reference
2	Must Pass	Report

<tbody>
</tbody>

This is one of the formulas I tried =IF(B2="Report" and A2="Must Pass","Must Pass","")

Been digging into the internet to find a solution, but not finding what I need.

Can anyone help?

Eric

 

[mumps]

Try: =IF(AND(B2="Report",A2="Must Pass"),"Must Pass","")

 

[ohmedic88]

Works great... I think I was missing a comma when I tried this way myself. Just kills when you're so close but can't see the problem.

Eric

 

[mumps]

Glad it worked out.