Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES | Excel Worksheet Functions | |||
Is there a way to calculate distance between 2 zipcodes? | Excel Programming | |||
How do I calculate the distance between 2 postcodes? | Excel Programming | |||
calculate time/distance | Excel Programming | |||
CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS | Excel Worksheet Functions |