Thread
:
Calculate the distance between two 2d co-ordinates
View Single Post
#
2
Posted to microsoft.public.excel.programming
Charabeuh[_4_]
external usenet poster
Posts: 62
Calculate the distance between two 2d co-ordinates
Hello,
if 1,1 are in A2,B2
if 1,5 are in A3,B3
A distance could be : =((A2-A3)^2+(B2-B3)^2)^0.5
"Vlad" a écrit dans le message de groupe de
discussion :
...
I have two co-ordinates that are given in x,y format.
E.g.
x , y
1 , 1
1 , 5
Is there an excel function or vba function that can be used to
calculate the distance between the two co-ordinates?
Cheers
Reply With Quote
Charabeuh[_4_]
View Public Profile
Find all posts by Charabeuh[_4_]