IF Function testing a range and a cell
 

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.

IF Function testing a range and a cell
 

=IF(OR((F11=""),(F24=""),(F42="")),"Y","X")
--
Gary''s Student - gsnu200733

IF Function testing a range and a cell
 

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.

IF Function testing a range and a cell
 

Regarding (F11=""),(F24="") ..... will this work for the range of cells
between F11 and F24, or just F11 and F24? I need it to check the range F11
to F24.

Scott

"Gary''s Student" wrote:

=IF(OR((F11=""),(F24=""),(F42="")),"Y","X")
--
Gary''s Student - gsnu200733