Thread: I need an If statement for Excel that excludes empty cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nascar2000a nascar2000a is offline
external usenet poster
  
Posts: 2
Default I need an If statement for Excel that excludes empty cells
I have a column of data (B11:B36) with a Min (B9) and Max (B10). I need an IF
statement that says pass if all data is within the Min/Max and fail if
outside the Min/Max but excludes blank cells.
Reply With QuoteReply With Quote