LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 4
Default Longtitude and Latitude Question

I am currently working on this project at work and I need help. I have about 100 different variables with lats and long assigned to them. I used the equation below to find the distance from point a to point b, but now I am trying to come up with an additional equation that when I pick one of the variables, I can enter whatever miles I want and it will return all variables with lats and long within that circumference of the distance that I've entered. The equation I used for finding the miles is below:

=ACOS(COS(RADIANS(90- LATITUDE OF A)) *COS(RADIANS(90- LATITUDE OF B)) +SIN(RADIANS(90- LATITUDE OF A)) *SIN(RADIANS(90- LATITUDE OF B)) *COS(RADIANS(LATITUDE OF A- LONGTITUDE OF B))) *3958.756

Last edited by Mastermind4real : April 17th 12 at 11:35 PM
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Latitude/Longitude Mike and Cheryl Tindall Excel Discussion (Misc queries) 1 October 15th 09 12:39 AM
Formating Longitude and Latitude Mark Excel Worksheet Functions 0 February 13th 08 06:22 PM
Latitude and Longitde problem Francois Ashton Excel Discussion (Misc queries) 3 December 27th 05 03:33 PM
formula for longitude/latitude Leo Excel Discussion (Misc queries) 2 June 3rd 05 06:40 PM
Help with Latitude and Longitude. LadiFireBug New Users to Excel 1 January 22nd 05 08:54 AM


All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"