Nested IF isnt working right..Why?

  • Thread starter Thread starter Curtis
  • Start date Start date
C

Curtis

=IF($C$5=1,-SUMPRODUCT(('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$A$3:$A$277=$B69)*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$1:$CI$1=E$7)*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$3:$CI$277)),0),IF($C$5=2,-SUMPRODUCT(('[YTDTB ACTUAL
''09-10.xls]YTDTB00'!$A$3:$A$277=$B69)*('[YTDTB ACTUAL
''09-10.xls]YTDTB00'!$D$1:$CI$1=E$7)*('[YTDTB ACTUAL
''09-10.xls]YTDTB00'!$D$3:$CI$277)),0)
 
Back
Top