Thread: Nested IF isnt working right..Why?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curtis Curtis is offline
external usenet poster
  
Posts: 181
Default Nested IF isnt working right..Why?
=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)
Reply With QuoteReply With Quote