logical function problem

Originally Posted by meddington

Perfect. Thanks!

you're welcome.

Originally Posted by meddington

Ok, got another one.

I'm wondering how to alter the code to include a third possiblity..."pass", "fail" or "Data missing". An array formula?

Hi
Please make it more clear that when you want to return each of three possibilties.
1) return "Fail" if even a single fail is found
2) return "Pass" if all are pass
3) return "Data missing" when???

Originally Posted by meddington

"Data Missing" returned when an empty cell occurs...so its more than a question about the "=IF(COUNTIF(D7:D18,"fail"),"fail","pass")" formula being able to determine a third result, and also about the logical function determining a pass/fail to determine a third result as well. A logical test simply determines a true or false outcome, so I'm wondering if there's a way to determine a third result...rather than IF(logical_test,[value_if_true],[value_if_false]), I'm wondering if a formula can look at a numeric value and if it is above a set tolerance, report "fail", if it is below a certain tolerance, report "pass", and if the value if missing (a blank cell), result in a "data missing" response.

I suppose this isn't entirely necessary, as I can have conditional formatting detemine three different formats based on the value of one cell, so I can make a cell with missing data shaded red or something, but I was just wondering if I could actually get a different value for the cell. I hope that makes sense.

does this help

=IF(COUNTBLANK(D7:D18),"Data Missing",IF(COUNTIF(D7:D18,"fail"),"fail","pass"))

Originally Posted by meddington

Yes, that's it exactly. Thanks again!

you're welcome. good to see that it helped you.