Formula Help (IF ?)

[lowdonl]

Hello

I'm looking for some support please.

In cell D3, I want it to show the current, overall status of testing.

If all results (or all so far) in F14:F25 show passed, the status should say "Pass" but any failure in F14:F25 should show the overal status as "Fail".

I assume this is an IF formula but I'm a novice in this area.

screenshot 1.PNG

Could someone please help?

Many Thanks

Lloyd

[JohnTopley]

Try

=IF (COUNTIF($F$14:$F$25",Failed")>0,"Fail","Pass")

[lowdonl]

Try

=IF (COUNTIF($F$14:$F$25",Failed")>0,"Fail","Pass")

Brilliant, that worked a treat. Thanks John!

[Pepe Le Mokko]

FYI as counts cannot be negative you can drop the ">0" part