Thread: IF Function testing a range and a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scott scott is offline
external usenet poster
  
Posts: 577
Default 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
Reply With QuoteReply With Quote