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

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]a[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Within Limits[/TD]
[TD]Reference[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Must Pass[/TD]
[TD]Report[/TD]
[/TR]
</tbody>[/TABLE]


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.