R
Redland
What formula would I use to find the total distance between two points on an
x,y scatter chart containing both positive and negative numbers? For example
if one point is (-100,0) and another point is (100, 0) then the distance
would be 200 or 201 if you count zero. My data would be as follows:
Column B Column C
-9 -78
-326 -110
-130 50
-52 -318
146 91
160 150
-22 -90
348 222
-30 170
342 342
-394 -396
114 -37
I am not a proficient programmer for VB, but am always willing to try if
that is what it takes. Thanks for the help.
x,y scatter chart containing both positive and negative numbers? For example
if one point is (-100,0) and another point is (100, 0) then the distance
would be 200 or 201 if you count zero. My data would be as follows:
Column B Column C
-9 -78
-326 -110
-130 50
-52 -318
146 91
160 150
-22 -90
348 222
-30 170
342 342
-394 -396
114 -37
I am not a proficient programmer for VB, but am always willing to try if
that is what it takes. Thanks for the help.