some negative, some positive. They are paired. I have 16 pair. I
neeId help with a formula that will give me the
difference between the two numbers.
4
-11 I need a total of 15

-10
2 I need a total of 12. Thanks in advance
for any assistance.

Assuming your data starts in A1, put this in B2:

=IF(MOD(ROW(A1),2)=0,"",ABS(A2-A1))

and copy down as far as required.

Hope this helps.

Pete

On Dec 2, 3:31*pm, Skip wrote:
some negative, some positive. *They are paired. I have 16 pair. I
neeId help with a formula that will give me the
difference between the two numbers.
4
-11 * *I need a total of 15

-10
2 * * * I need a total of 12. * * * * * * * * * * *Thanks in advance
for any assistance.

Hi,
let' say 4 is in A1 and -11 in A2 in b2 enter

+A1-A2



"Skip" wrote:

some negative, some positive. They are paired. I have 16 pair. I
neeId help with a formula that will give me the
difference between the two numbers.
4
-11 I need a total of 15

-10
2 I need a total of 12. Thanks in advance
for any assistance.
.