ExcelBanter - how can avoid considering of blank cells in IF function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how can avoid considering of blank cells in IF function (https://www.excelbanter.com/excel-worksheet-functions/93407-how-can-avoid-considering-blank-cells-if-function.html)

Lika

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).

Aladin Akyurek

how can avoid considering of blank cells in IF function

=(COUNT(H8,J8)=2)*(H8=J8)+(COUNT(H10,J10)=2)*(H10= J10)+(COUNT(H12,J12)=2)*(H12=J12)

Lika wrote:
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).

All times are GMT +1. The time now is 11:48 AM.