Matching Values to Zero
 

I have sorted a spreadsheet by absolute value to match the exact
positives and negatives together. But the information is too large. So
I created nested if statements incorporating "and" and "or" statements
to help match the positive values and negative values.

Here is a sample (x's mean a row matches with another row):

37 10650-4 1,100.90 1100.9_37 x
37 10650-4 (1,100.90) 1100.9_37 x
42 10650-4 (1,100.90) 1100.9_42 x
5 10650-4 1,100.90 1100.9_50 x
5 10650-4 1,100.90 1100.9_50

As you can see, these match correctly and show the last line +1,100.90
does not have a match. This works great, throughout some of the
spreadsheet, but not everything.

Can anyone help? I can email you the spreadsheet.

Thanks...