Calculate the distance between two 2d co-ordinates

[Vlad]

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

 

[Charabeuh]

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" <[email protected]> a écrit dans le message de groupe de
discussion :
c07873f3-553e-4874-9778-50921ab5ac83@a21g2000yqc.googlegroups.com...

 

[macropod]

Hi Vlad,

=SQRT((X2-X1)^2+(Y1-Y2)^2)