
1. Re: Formula to calculate distance in yards between two locations?
dburnham Apr 2, 2016 10:15 AM (in response to jjfcpa)If you look in Brian Dunning's custom function web site, you will find several custom functions that calculate distance between points. I've used them to calculate distance in miles between zip codes, and I suspect that if you know the geocoordinates from the location function then it would work for you. Worst case would be that if the custom function returns a result in miles, you just divide by 1760

3. Re: Formula to calculate distance in yards between two locations?
jjfcpa Apr 2, 2016 6:18 PM (in response to dburnham)I found one that works perfectly. Thanks.
BTW, you meant multiple (rather than divide) by 1760.

4. Re: Formula to calculate distance in yards between two locations?
bigtom Apr 2, 2016 7:33 PM (in response to jjfcpa)jjfcpa wrote:
I found one that works perfectly. Thanks.
BTW, you meant multiple (rather than divide) by 1760.
Which one did you settle on using.

6. Re: Formula to calculate distance in yards between two locations?
jjfcpa Apr 3, 2016 8:52 AM (in response to bigtom)I opted for this one because it was the easiest to modify. I only wanted it to calculate yards  it's for a golf app that I'm working on. Still need to test it on the course to make sure it's accurate.

7. Re: Formula to calculate distance in yards between two locations?
dburnham Apr 4, 2016 6:16 AM (in response to jjfcpa)mea culpa