Hello, I am trying to build a macro to solve an accounting issue. Basically I have a column of numbers, some positive some negative that need to sum to 0. However, some of the signs maybe wrong on these numbers so that they do not sum to 0. I want to build a program that will create all the possible combinations of the positive and negative versions of each number so that I can find which ones sum to 0. For example: I put in 1,2,3 into cells of column A. It gives out in column B

1+2+3
1+2-3
1-2-3
-1-2-3
1-2+3
-1+2-3
-1+2+3
-1-2+3

I don't care if the macro gives out a ton of useless results, as long as the possible sum to 0 results are all there. In the case above for example only 2 cases sum to 0.