Making #N/A zero or -

S

shikamikamoomoo

Below is an array formula that I am using, I just can't figure out ho
to make it return 0 or - if there is not a number that meets th
specified conditions. I've tried adding ISERROR in front of it an
various other places, but I haven't been able to get it t
work....perhaps I'm putting it in the wrong place or missing somethin
that should go with it. Any help is appreciated! Thanks

=(INDEX($Q$2:$Q$2000,MATCH(1,(4=$L$2:$L$2000)*(100%=$M$2:$M$2000)*("Publi
Opinion"=$J$2:$J$2000)*("x"=$R$2:$R$2000),0))
 
B

Bernard Liengme

Too complicated to get head around at this hour but in general one uses this
syntax
=IF(ISNA(your_formula, 0, your_formula)
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"shikamikamoomoo"
 
D

Dave Peterson

You could use this kind of technique:

=if(iserror(Match(1,....)),0,your existing formula)

Still array entered.
 
Top