+ Reply to Thread
Results 1 to 4 of 4

Coordinates and Distance formula

  1. #1
    Registered User
    Join Date
    01-21-2010
    Location
    Akron Ohio
    MS-Off Ver
    Excel 2007
    Posts
    16

    Coordinates and Distance formula

    Okay first of all i want to thank all the people who have helped me before... what i am trying to do now, is use the standard distance formula .... Im hoping that in cell A1 there can be a pair of coordinates, in an (X,Y) format ... Then in cell B1 hopefully there will be a second pair of coordinates in an (X,Y) format .... Cell C1 would then use the standard distance formula to give me the distance. I know i could do this using 5 cells, A1 having the first pair X, B1 having the first par Y, C1 having the second Pair X, D1 having the second pair Y, and then E1 having the equation .... if anyone can help me make it so it only uses 3 cells ... Thank you


    C. M. Porter

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: Coordinates and Distane formula

    Do you look on distance over sphere or over plane?

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Coordinates and Distane formula

    It can be done, but why? Putting multiple values in one cell is not what Excel was designed for.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Coordinates and Distance formula

    You could use complex numbers:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1