Hello,
I have an excel sheet with column "A" stating miles per hour and column "B" stating KM per hour. i want to convert convert miles per hour to kilometers per hour. but have no idea about the formula. please help me.
Hello,
I have an excel sheet with column "A" stating miles per hour and column "B" stating KM per hour. i want to convert convert miles per hour to kilometers per hour. but have no idea about the formula. please help me.
Convert miles per hour to kilometers per hour
- Open the Microsoft Excel program.
- Install the Convert function if it is not already installed. The Convert function is not installed by default. It is part of the "Analysis Add-in" tool pack. To install add-ins, click on the "Tools" menu, and click on "Add-ins".
- Put a checkmark beside "Analysis Toolpak".
- Depending on how Microsoft Office was installed, you may be asked to provide the install CD.
- The other add-ins are worth installing, most notably Solver, but they are beyond the scope of this article.
- Use the Convert function. You enter the formula by typing CONVERT(x,"y","z"), where "y" is the original unit of measurement, "x" is the quantity of that unit, and "z" is the unit of measurement you want to convert to. Note that there are no spaces in the command, and the commas and quotation marks are necessary.
- Examine this example. Suppose we wanted to convert 60 miles to kilometers:
- Type =CONVERT(60,"mi","km"). You should get 96.56064. You may get another number that is close to that, depending on how many significant digits your spreadsheet is set to display.
To convert miles per hour to kilometers per hour, you must follow the next steps.
- Open your excel sheet
- Fill out the conversion rate, somewhere in the spreadsheet. in your case C1.
- Now select cells B2: B9 and enter the following formula = A2 / $ C $ 1. And vice versa is = A2 * $ C $ 1
- And press Ctrl + Enter
- All you need to do now is to select cells B2: B9 again, right click and select Properties. Now you have the number because you may want to get the digits in a 2 decimal number.
Bookmarks