View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cubbybear3 cubbybear3 is offline
external usenet poster
 
Posts: 40
Default Longtitude and Latitude Question

On Apr 20, 3:34*pm, cubbybear3 wrote:
Mastermind4real,

You have a couple of errors in the last line (as displayed) of your
formula.
It should be Longitude A (not Latitude A) also the constant should be
3440.065 not 3958.756.

-pb


Oop's, my mistake, 3958.756 is correct for Statute miles, 3440.065 is
for nautical miles.
-pb