Nested if with isNA formula help

[ariel20029]

Hi all,
I have a nested if statement and I am trying to add in if there is a #N/A to put a zero, but I am having trouble getting the formula to work. Any help please


=IF($Y7="RevPro",SUMIFS('Q4-18 DRR'!$DX$4:$DX$50000,'Q4-18 DRR'!$K$4:$K$50000,$A7,'Q4-18 DRR'!$DR$4:$DR$50000,F$6),IF($Y7="RevStream",VLOOKUP($A7,'R RevStream'!$A:$G,5,0)*-1))

thanks,
Sharon

 

[Joe4]

How about:

[COLOR=#ff0000]=IFERROR([/COLOR][COLOR=#333333]IF($Y7="RevPro",SUMIFS('Q4-18 DRR'!$DX$4:$DX$50000,'Q4-18 DRR'!$K$4:$K$50000,$A7,'Q4-18 DRR'!$DR$4:$DR$50000,F$6),IF($Y7="RevStream",VLOOKUP($A7,'R RevStream'!$A:$G,5,0)*-1))[/COLOR][COLOR=#ff0000],0)[/COLOR]

 

[ariel20029]

So simple-- thank you so much.. sorry for the delay in responding
Sharon