I would like to calculate all possible results from a given set of numbers. I am wondering if there is a table that I can place numbers in to to see all possible scenarios calculated out (adding and subtracting). I use Excel to do bank recs, and something like this would be extremely useful for seeing what combination of numbers would help get to a zero balance.
For example, if I a set of numbers placed in cells A1:A10, and need to see all possible products from adding and subtracting the numbers (A2+A3-A1, A5-A1+A4, etc). What can I do?
Please let me know if this is not clear enough.
For example, if I a set of numbers placed in cells A1:A10, and need to see all possible products from adding and subtracting the numbers (A2+A3-A1, A5-A1+A4, etc). What can I do?
Please let me know if this is not clear enough.