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?

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?