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.
    Advertisement
  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.
    8. Advertisement

You Might Also Like

How Do You Write an if then Formula in ExcelHow to Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More
Google Sheets How to Insert Time in Cell Automatically4 Easy Ways to Add the Time and Date Automatically in Sheets
Add the Same Value to Multiple Cells in Excel
How to
Add the Same Value to Multiple Cells in Excel
Add a Custom Field in Pivot TableHow to Add Custom Calculated Fields to Pivot Tables in Excel
Use Google SpreadsheetsHow to Use Google Sheets: The Ultimate Guide for Getting Started
Add Two Cells Containing the Sum of Other Formulas in Excel
How to
Add Two Cells Containing the Sum of Other Formulas in Excel
Show the Max Value in an Excel Graph
How to
Show the Max Value in an Excel Graph
Make a Google Spreadsheet
How to
Make a Google Spreadsheet
Add Rows to a Pivot Table
How to
Add Rows to a Pivot Table
Create a Form in a Spreadsheet
How to
Create a Form in a Spreadsheet
Sort by Number on Google Sheets on PC or Mac
How to
Sort by Number on Google Sheets on PC or Mac
Make a Shared Spreadsheet
How to
Make a Shared Spreadsheet
Change an Excel Sheet from Read Only
How to
Change an Excel Sheet from Read Only
Create a Formula to Increase a Date by 1 Month
How to
Create a Formula to Increase a Date by 1 Month
Advertisement

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 47,926 times.
How helpful is this?
Co-authors: 2
Updated: July 28, 2015
Views: 47,926
Categories: Spreadsheets
Advertisement