Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Determine Test /fail for an test template design
0
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
Answers
0
Here is a formula that will do it:
=IF(COUNTIF(I6:I9,"pass")=COUNTA(I6:I9),"Pass","Fail")Change I6:I9 in both places to the correct range for each test.
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
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
mishti Nov 14, '16 at 11:49 pm
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.
don (rep: 1989) Nov 15, '16 at 9:26 am