21. Convert miles per hour to km per hour
A worksheet contains speed in miles per hour. To convert the data to kilometers per hour, use the following calculation.
To convert miles per hour to kilometers per hour:
1. In a worksheet, enter the data shown in Figure 1-21, or use your own data.
2. Select cell D1 and enter the conversion value 0.621371.
3. Select cells B2:B8 and type the following formula: =A2/$D$1.
4. Press <-Ctrl+Enter->.
Note: To convert the other way around, from kilometers per hour to miles per hour, use the formula =B2*$D$1.
Watch the Video Tutorial - https://www.youtube.com/watch?v=EPb-zHmHJ4A
Hope You Like This Tutorial - Give Comments
