Results 1 to 4 of 4

shortest distance between a point and a line

Threaded View

  1. #1
    Forum Contributor stockgoblin42's Avatar
    Join Date
    05-26-2011
    Location
    vancouver, canada
    MS-Off Ver
    Excel 2010
    Posts
    222

    shortest distance between a point and a line

    Hi,

    I'm trying to formulate the shortest distance between a line and a point.

    Please see attahced picture for the formula.

    To translate it into Excel I'm having great difficulties and only getting #REF! as an outcome. Here's my attempt.

    =SQRT((((TinyTri!I4+(Paras!A1*TinyTri!J4)-(Paras!A1*Paras!C1))/((Paras!A1)^2+1))-TinyTri!I4)^2)+((Paras!A1((TinyTri!I4+(Paras!A1*TinyTri!J4)-(Paras!A1*Paras!C1))/(Paras!A1^2+1))+Paras!C1-TinyTri!J4)^2)

    TinyTri!I4 = Px
    TinyTri!J4 = Py
    Paras!A1 = m
    Paras!C1 = c


    Does anyone have an eagle eye for bracket placement?
    Attached Images Attached Images
    live logic & long prosper

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