Awesome site, thanks.
I have 4 columns of numbers. Column 1 minus column 2 = answer(col3). Then I add column 4 to col 3.
Sometimes the answer between col1 and col2 is a negative number. This will throw off everything. Is it possible to have excel subtract col2 from col1 or vice versa which ever way will always give a positive?

25 32 col1-col2=-7
I hope it can be;
25 32 col1-col2=7 without having to change the forumla around or the columns. sometimmes I have over 1500 cells in a column and the way i do it nopw is go through manually and change it when i get negative.

Cheers, looking forwRD to help.
Martin.