How to determine test,fail observations based on the scripts outcome. (Manual testing)
Here i ve Step Result with Pass , Fail and Not run. In the "TEST RESULT" i am looking for the final value based on the "STEP RESULT" Column.
If all the steps are pass,then TEST RESULT --> pass
if any one step is fail then TEST RESULT----> fail.
if any one step is failed or not run -------> fail.
Kindly appreciate ur Help.
Thanks in advance
Change I6:I9 in both places to the correct range for each test.
posted by: don (rep: 1989) on Mon Nov 14, 2016 at 8:26 am
Answer
Discuss
no
Discussion
Hi,
First of all Thanks for ur help.
Yr formula is NOT WORKING any test Result (=IF(COUNTIF(6:9,"pass")=COUNTA(6:9),"Pass","Fail"). ichecked with this below formula for first test results . Its showing as 0 . Hey i need some kind of logical formula which keep generating the results bydefault for rest of the cells . Not looking for editing formula (cell no ) everytime for test result . Either even on color based also will work for me. IF all the step result are green in Color---> test result = Pass If any one step result is either yellow/red--> test result= fail.
Plz help me with this how to proceed further.
Thanks alot for ur Help in advance
the formula that you included will not work because you reference entire rows instead of a specific cell range. Put my formula into cell K6 and try it out for that first section of 4. I just tried it again and it works for me. Once you get that working, you can apply it to the other sections with only a change of the cell reference.