Results 1 to 8 of 8

Rounding Vectors based on length of line

Threaded View

  1. #1
    Registered User
    Join Date
    06-18-2012
    Location
    New Zealand
    MS-Off Ver
    Excel 2002
    Posts
    7

    Rounding Vectors based on length of line

    I am seeking a function that can round the angle of a vector based on the length of line of that vector.

    The parameters I require are as follows:

    1. If the length of the vector is less than 250 then round the respective angle to the nearest 10 seconds
    2. If the length of the vector is between 251 to 500 then round the respective angle to the nearest 5 seconds
    3. If the length of the vector is greater than 501m do not round the respective angle

    The vectors are in the following format:

    295° 41' 17" 949.393

    Note there is a space after the ° and ‘ symbols and furthermore the angle and distance values are in separate cells.

    Currently I am using the substitute function to format the angle without symbols i.e. 295.4117.

    See below.

    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"° ","."),"' ",""),"""","")
    I then round these values using the MROUND function which requires individual analysis of each vector and therefore is time consuming.

    Any advice or assistance to speed up this process would be much appreciated.

    Thanks in advance.
    Last edited by jeffreybrown; 06-19-2012 at 06:40 PM.

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