Thread: how can avoid considering of blank cells in IF function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lika
 
Posts: n/a
Default how can avoid considering of blank cells in IF function
I am using the following formulas:
=IF(H8=J8,"1","0")+IF(H10=J10,"1","0")+IF(H12=J12, "1","0")
but is counting also the blank cells. I would like to compar the cells when
there are numbers (including zero) inside (not blank).
Reply With QuoteReply With Quote