The error is on the first line of the if statement.
Absolute value calculation in the column. So the column its checking for values > 3 (rm.column), has a formula in each cell that says =Abs((S2-AG2)/S2). So what I want the code to do is check if that value is > 3, and if so put a 4 in the exclude column. The reason I think it has something to do with absolute value is because I have a similar check on the cell next to it that works fine and the cells it is checking are a simp
Bookmarks