Rafael de Jesus Silva Monteiro rafaeldjsm

## geo-distance-calc.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                rafaeldjsm
                / geo-distance-calc.md
            
            
              Created
              October 26, 2021 18:21
                — forked from richard512/geo-distance-calc.md
            
              
                Calculate distance between lat long coordinates in excel / libre calc
              
          
    Using variables

=ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) *6371
Using Cell References

=ACOS(COS(RADIANS(90-A2)) *COS(RADIANS(90-A3)) +SIN(RADIANS(90-A2)) *SIN(RADIANS(90-A3)) *COS(RADIANS(B2-B3))) *6371
That'll work for a table set up like this:


Name
Lat
Long