Ignoring positive values on graph.

[rickblunt]

Greetings, I have been staring at this for an hour, trying a few things and I can't seem to figure it out. I am using the formula below on a line graph so that I can ignore the outliers from the data that is being shown on the graph. (J1 is where I enter the outlier limit number) It works fine but I would like to tweak the formula so that I can also ignore the positive values, I only want the negative values to be shown on my chart.

I know that I could just set my graph axis range to ignore >0, but I would kind of like to have any positive value also display "NA". Can this code be tweaked to only allow negative values? I appreciate any input.

=IF(AND(ABS(C98-C97)>$J$1,ABS(C98-C99)>$J$1),NA(),C98)

 

[JGordon11]

Maybe

IF(OR(C98>0,AND(ABS(C98-C97)>$J$1,ABS(C98-C99)>$J$1)),NA(),C98)

or

IF((C98>0)+(ABS(C98-C97)>$J$1)*(ABS(C98-C99)>$J$1),NA(),C98)

 

[rickblunt]

Thanks JGordon, that first one worked perfect.