| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help... PLEASE
Hello,
I'm entering the following formula: IF(COUNT(IF(YEAR(SCGU!$C$2:$C$160)=$A9,SCGU!D$2:D$ 160,""))=12,(PRODUCT(1+(IF(YEAR(SCGU!$C$2:$C$160)= $A9,SCGU!D$2:D$160,0))/100)-1)*100,"") But am getting zero's instead of a blanks. There are no contents in the cells that it is referencing so there should be blanks. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help... PLEASE
I found the problem. Replace the ***0*** with ""
IF(COUNT(IF(YEAR(SCGU!$C$2:$C$160)=$A9,SCGU!D$2:D$ 160,""))=12,(PRODUCT(1+(IF(YEAR(SCGU!$C$2:$C$160)= $A9,SCGU!D$2:D$160,***0***))/100)-1)*100,"") "stan" wrote: Hello, I'm entering the following formula: IF(COUNT(IF(YEAR(SCGU!$C$2:$C$160)=$A9,SCGU!D$2:D$ 160,""))=12,(PRODUCT(1+(IF(YEAR(SCGU!$C$2:$C$160)= $A9,SCGU!D$2:D$160,0))/100)-1)*100,"") But am getting zero's instead of a blanks. There are no contents in the cells that it is referencing so there should be blanks. What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
