Calculate the distance between two 2d co-ordinates
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 |
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 |
Calculate the distance between two 2d co-ordinates
Hi Vlad,
=SQRT((X2-X1)^2+(Y1-Y2)^2) -- Cheers macropod [Microsoft MVP - Word] "Vlad" wrote in message ... 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 |
All times are GMT +1. The time now is 09:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com