I’m trying to simply my variance analysis of five columns (Q and total 11 compared to Q and total 2010) using IF, ABS and MAX functions. I wrote this formula (=IF(ABS(MAX(N4:R4))>99999.99,"Material:","")), but the negatives changes are not appearing because the max of a neg. is the closest to zero.

I’m working with variances in five columns (Q1, Q2, Q3, QW4 and total) and trying to identify if change any one quarter or the year total was greater than $100k. Any ideas on how to clean this up?