View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme
 
Posts: n/a
Default Distance calculations

Since you are squaring the order is unimportant.
3-5 = -2 and -2^2 =4
5-3 = 2 and 2^2 =
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"not bright" wrote in message
...
Thanks alot

does it matter which one is first (x1-x2 or x2-x1)

"Gary''s Student" wrote:

I am sure that you are very bright, maybe a little forgetful:

Remember Pythagoras

D=sqrt((x1-x2)^2+(y1-y2)^2))
--
Gary's Student


"not bright" wrote:

I am trying to get a formula to produce a distance in feet
Example:
A B C
X corrd y corrd
1 6806.9 1680.62
2 7243.67 1509.92 (Dist. Between a1 & a2)
3 6751.07 1319.53 (Dist. Between a2 & a3)

The numbers are X & Y Coordinates for devices in a CAD program.

I have a formula that I was trying: (ABS(A1-A2)+ABS(B3-B2))/12)
But the results don't match to the distance in the CAD drawing. Or, are
my
math skills that bad???