You will need to reverse the position of x and y in my previous post.
--
Gary''s Student - gsnu200733


"Scott" wrote:

I need to check cells F11 to F24 and F42 to see if any are blank, and if so
return answer X and if not answer Y. This is what I got so far
=IF(COUNTBLANK(F11:F24)=1,"X","Y") but it only checks cells F11:F24. I
cannot not figure out how to check for F42.