How to Generate a Conversion Calculator for Meters Per Second Into Excel

Written by william nagel
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Generate a Conversion Calculator for Meters Per Second Into Excel
Program a conversion calculator in Excel. (calculator image by L. Shat from Fotolia.com)

Microsoft Excel is an excellent spreadsheet application that has a large number of built-in mathematical and data functions that can be used to program tables and conversion calculators. Entering functions into an Excel spreadsheet can be performed manually or with the function wizard, which helps you format the function properly. If you need to convert different rates of speed into meters per second, you can set up a series of functions in Excel to make the calculations automatically.

Skill level:
Moderate

Other People Are Reading

Things you need

  • Microsoft Excel

Show MoreHide

Instructions

  1. 1

    Create a new spreadsheet in Excel.

  2. 2

    Create labels for your conversion calculator. Type "mph" into cell "A1." Type "km/h" into cell "A2." Type "m/s" into cells "C1" and "C2."

  3. 3

    Select cell "D1" and press the "Fx" button next to the "Formula bar." Search for the "PRODUCT" function under the "Math and Trig" list of functions. Highlight "PRODUCT" and press "OK."

  4. 4

    Type "B1" into the "Number 1" text box. Type "1.609344" into the "Number 2" box and click "OK;" this number is the miles per hour to meters per second conversion factor. Cell D1 will convert any number entered in cell B1 from miles per hour into meters per second.

  5. 5

    Select cell "D2" and press the "Fx" button. Highlight the "PRODUCT" function and press "OK."

  6. 6

    Type "B2" into the "Number 1" text box. Type "0.277777778" into the "Number 2" box and click "OK;" this number is the kilometres per hour to meters per second conversion factor. Cell D2 will convert any number entered in cell B2 from kilometres per hour into meters per second.

  7. 7

    Save your spreadsheet.

Tips and warnings

  • If you need to convert less common rates of speed such as feet per minute or centimetres per hour, use a search engine to find the conversion factor, then create an entry in your calculator by multiplying the rate of speed by the conversion factor.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.