I want to use Excel to evaluate the results of a psychometric test.
The test produces pairs of figures.
Each figure can be positive or negative

If both are positive or both are negative I want the absolute difference

If one is positive and the other negative I want to sum them
If the first is positive and the second negative then I want to maket he
figure produced above positive
If the first is negative and the second positive I want to make the figure
produced above negtive

Any ideas?