Pass/Fail of two cells

[PSI94]

Happy friday all!!

I think this may be one of my favourite websites, you have all been so helpful - so, thankyou!

I think I've maybe looked at this to long and the answer may be obvious.

I've created two pass/fail formulas for two seperate columns. I now need an overall pass/fail of the data. The issue is that some of the data is returning a pass (highlighted red), whereas part of the validation actually failed. Is there a formula that will populate 'Pass'(so would populate a pass for the two cells highlighted green) when both columns ONLY show pass, and not a fail/pass or pass/fail?

I hope that makes sense - my heads fried!

 

[KRice]

If I understand correctly, you want an AND function
=IF(AND(F2="Pass",G2="Pass"),"Pass","Fail")
substitute for F2 and G2 depending on what your actual cell locations are.

 

[PSI94]

If I understand correctly, you want an AND function
=IF(AND(F2="Pass",G2="Pass"),"Pass","Fail")
substitute for F2 and G2 depending on what your actual cell locations are.

That worked a treat! Thanks so much

 

[KRice]

That's good to hear...I'm happy to help.