logical function problem

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.