Formula to write the value depending upon the all other cell values

[jayexcelexlplorer]

I have a table which has different test scenarios and Results Column which says PASS,FAIL or PENDING.
I have a Master sheet in the same workbook which has consolidated results from all other sheets.
How can i write a formula for each sheet in such a way that if all tests has result "PASS" then the value in the master sheet should be updated automatically to "PASS",even if a single value is "PENDING" or "FAIL" then auto populate as "PENDING" or "FAIL" in Master Sheet.This is my first post so please bare with me if i am not very clear.Let me know if you have any questions regarding this.

Please help in this regard - i thought of putting sample excel cell data here to give complete idea but it was not pasted with format correctly.

 

[Rijnsent]

Hi Jay,
something like:
=IF(COUNTIF(B2:B200,"FAIL")>0,"FAIL","NO FAILS FOUND")
Cheers,
Koen

 

[Aladin Akyurek]

Try something like...

=IF(COUNTIFS(ResultsColumn,"?*"),IF(SUM(COUNTIFS(ResultsColumn,{"PENDING","FAIL"})),"PENDING/FAIL","PASS"),"")