Formula Help... PLEASE

[stan]

Hello,

I'm entering the following formula:


IF(COUNT(IF(YEAR(SCGU!$C$2:$C$160)=$A9,SCGU!D$2$160,""))=12,(PRODUCT(1+(IF(YEAR(SCGU!$C$2:$C$160)=$A9,SCGU!D$2$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?

 

[Joel]

I found the problem. Replace the ***0*** with ""

IF(COUNT(IF(YEAR(SCGU!$C$2:$C$160)=$A9,SCGU!D$2$160,""))=12,(PRODUCT(1+(IF(YEAR(SCGU!$C$2:$C$160)=$A9,SCGU!D$2$160,***0***))/100)-1)*100,"")