How to Make a Spreadsheet to Do the Distance Formula

Are you tired of doing the distance formula by hand? Make a spreadsheet to do it for you!

Steps

  1. Image titled Make a Spreadsheet to Do the Distance Formula Step 1
    1
    Open up a new spreadsheet. Any one will do, Excel is good for this.
  2. Image titled Make a Spreadsheet to Do the Distance Formula Step 2
    2
    In the cell A1, type X Coordinates. In B1, type Y Coordinates.
  3. Image titled Make a Spreadsheet to Do the Distance Formula Step 3
    3
    In the cell C2, type Pair 1. In C4, type Pair 2. This is to help you remember which number goes where.
  4. Image titled Make a Spreadsheet to Do the Distance Formula Step 4
    4
    In the cell D2, type in the following formula:=SQRT(((B2-B3)^2)+(A2-A3)^2)
  5. Image titled Make a Spreadsheet to Do the Distance Formula Step 5
    5
    In A2, type the first X coordinate. In B2, type the first Y coordinate.
  6. Image titled Make a Spreadsheet to Do the Distance Formula Step 6
    6
    In A3, type the second X coordinate. In B3, type the second Y coordinate.
  7. Image titled Make a Spreadsheet to Do the Distance Formula Step 7
    7
    The distance will come up in D2.

You Might Also Like

Sort by Number on Google Sheets on PC or Mac
How to
Sort by Number on Google Sheets on PC or Mac
Add a Custom Field in Pivot Table
How to
Add a Custom Field in Pivot Table
Create a Form in a Spreadsheet
How to
Create a Form in a Spreadsheet
Change an Excel Sheet from Read Only
How to
Change an Excel Sheet from Read Only
Add Two Cells Containing the Sum of Other Formulas in Excel
How to
Add Two Cells Containing the Sum of Other Formulas in Excel
Run a Script on Google Sheets
How to
Run a Script on Google Sheets
Copy Formulas on Google Sheets on PC or Mac
How to
Copy Formulas on Google Sheets on PC or Mac
Add Rows to a Pivot Table
How to
Add Rows to a Pivot Table
Show the Max Value in an Excel Graph
How to
Show the Max Value in an Excel Graph
Embed Documents in Excel
How to
Embed Documents in Excel
Freeze More than One Column in Excel
How to
Freeze More than One Column in Excel
Create a Chart from a Pivot Table
How to
Create a Chart from a Pivot Table
Make a Google Spreadsheet
How to
Make a Google Spreadsheet
Make a Shared Spreadsheet
How to
Make a Shared Spreadsheet

About This Article

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 44,546 times.
How helpful is this?
Co-authors: 2
Updated: July 28, 2015
Views: 44,546
Categories: Spreadsheets