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
<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
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