Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |