ok, I'm stupid...I need basic math help...

[attgig]

I have 2 columns of numbers...
they are negative #s and positive #s ........

So, I need to get the difference of the 2, using the sign on the left column as it's base...

so, for example, let's say these are my 2 columns:


c1 c2
-6 5
4 -9
3 -1
-2 3
4 3
5 8
-2 -1
-10 -11
----------
-4 -3 (sums)


how can i get the difference of the 2 columns so that the sum of the differences would equal the difference of the sums?

[topane]

Make them both=0

0+0=0
0-0=0

I'm not really sure what you're asking :confused:

[attgig]

so if the left side is -6, and the right is +5...then, I need the difference (would it be 1 or -1), so that the difference of the sums(the last row) = the sum of the differences (if I had another column that had the differences of each row, get the sum of that.)

does that clarify?

[dbax791]

Looks like the sum of the differences and the difference of the sums already = -1

C1 C2 Diff
-6 5 -11
3.00 -9 12
4.00 -1 5
-2 3 -5
4 3 1
5 8 -3
-2 -1 -1
-10 -11 1
---- ---- ---
-4 -3 -1 (sum of diffs)

(-4 - -3) = -1 (diffs of sums)

Congrats! You solved it!

[Grimm]

Doesn't the sum of the difference have to be a positive number? You are basicaly looking for a distance between the points. Or am I out in left field here?

[Butch]

Wouldn't it work if you just had one of the sums as 0 and the other as any positive number? Clearly I'm not a math major here . . . but I did stay at a Holiday Inn Express last night . . .

[dbax791]

Originally posted by Grimm
Doesn't the sum of the difference have to be a positive number? You are basicaly looking for a distance between the points. Or am I out in left field here?

I didn't see any constraints that the sum of the difference had to be positive.

PS - High fly ball to left coming your way :D

[brainsmile]

duck~

[attgig]

Originally posted by dbax791
Looks like the sum of the differences and the difference of the sums already = -1
Congrats! You solved it!

thanks dbax..
I knew it was something obvious, but I couldn't quite put my finger on it :P

I hate that....feel so stupid

[Grimm]

Originally posted by attgig


I hate that....feel so stupid

Just go with it. :heh:

[coleslaw]

Originally posted by Butch
Clearly I'm not a math major here . . . but I did stay at a Holiday Inn Express last night . . . Classic :heh:

[ChrisMG187]

Originally posted by Butch
Wouldn't it work if you just had one of the sums as 0 and the other as any positive number? Clearly I'm not a math major here . . . but I did stay at a Holiday Inn Express last night . . . LOL!

[dbax791]

Originally posted by Butch
Wouldn't it work if you just had one of the sums as 0 and the other as any positive number? Clearly I'm not a math major here . . . but I did stay at a Holiday Inn Express last night . . .

Ditto. LMAO. Best line of the thread :heh:

[leemaj]

:confused: ok, so i guess im not in on this little inside joke:confused:

[attgig]

Originally posted by leemaj
:confused: ok, so i guess im not in on this little inside joke:confused:
it's a commercial..
u see a guy saving someone's life, performing an operation...or something crazy..
then someone asks them, you're a professional..
and he's like no, but i did stay in a holiday inn express last night...

pretty funny commercials...even funnier when used in this post :heh: