| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Function for BLANK cells | Excel Worksheet Functions | |||
| Sumif function does not add up cells, even when criteria is blank | Excel Worksheet Functions | |||
| Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
| Omit blank cells from function results | Excel Worksheet Functions | |||
| IF function to blank without getting #value in sum function | Excel Worksheet Functions | |||
Hybrid Mode
