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.

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.
Excel Formula:
=IF(AND(ABS(C98-C97)>$J$1,ABS(C98-C99)>$J$1),NA(),C98)