Formula Help... PLEASE

  • Thread starter Thread starter stan
  • Start date Start date
S

stan

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?
 
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,"")
 
Back
Top