Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Miles Calculation?
Is there anyway to find the miles between the 2 places that are inputted into
2 different cells? for instince if Los Angelas, CA is inputted into cell 1A and New York, NY is inputted into cell 1B it will automatically put into cell 1C the miles between them. Is there anyway to do this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Miles Calculation?
What distance do you want to measure? Driving distance? Great circle
distance? I have a workbook on my web site that lists the latitude and longitude of about 1200 cities in the US and it has code and formulas for calculating the great circle distance (shortest distance) between two cities. See http://www.cpearson.com/Excel/latlong.htm for details and download the workbook at http://www.cpearson.com/Zips/LATITU~1.ZIP . -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Ewing25" wrote in message ... Is there anyway to find the miles between the 2 places that are inputted into 2 different cells? for instince if Los Angelas, CA is inputted into cell 1A and New York, NY is inputted into cell 1B it will automatically put into cell 1C the miles between them. Is there anyway to do this? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Miles Calculation?
On 29 Apr, 14:06, Ewing25 wrote:
Is there anyway to find the miles between the 2 places that are inputted into 2 different cells? for instince if Los Angelas, CA is inputted into cell 1A and New York, NY is inputted into cell 1B it will automatically put into cell 1C the miles between them. Is there anyway to do this? Thanks Get a list of coordinates of your locations. Eg http://www.infoplease.com/ipa/A0001796.html Then look up the long and lat for each of your choices with a vlookup. Then use pythagorus to work out the diagonal distance between them. If cell D1 has the 'longtitude' difference (one minus the other), and D2 has the 'latitude' difference, then the formula to put in C1 is: =sqrt((D1*D1)+(D2*D2)) As to how to convert these figures to miles. Look online and find an established distance. Then divide your number by this number to get the constant ratio. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Miles Calculation?
I have a worksheet named Miles. I also have a Userform that asks the user
for Start Location and End Location then what i want it to do is have it query google maps for specific miles and import that finding into cell C2 then if they press New Location (Commandbutton1) it resets the form and puts the new data in C3. Any Idea how to do that? "Chip Pearson" wrote: What distance do you want to measure? Driving distance? Great circle distance? I have a workbook on my web site that lists the latitude and longitude of about 1200 cities in the US and it has code and formulas for calculating the great circle distance (shortest distance) between two cities. See http://www.cpearson.com/Excel/latlong.htm for details and download the workbook at http://www.cpearson.com/Zips/LATITU~1.ZIP . -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Ewing25" wrote in message ... Is there anyway to find the miles between the 2 places that are inputted into 2 different cells? for instince if Los Angelas, CA is inputted into cell 1A and New York, NY is inputted into cell 1B it will automatically put into cell 1C the miles between them. Is there anyway to do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cell - Miles | Excel Discussion (Misc queries) | |||
Miles per gallon spreadsheet | Excel Worksheet Functions | |||
Averaging miles per gallon | Excel Worksheet Functions | |||
Calculation: miles between two points using latitude & Longitude | Excel Discussion (Misc queries) | |||
Miles Per Hour | Excel Worksheet Functions |