Table of Contents
This guide is about Guide: Convert Feet to Inches in Excel. So read this free guide, Guide: Convert Feet to Inches in Excel. If you have query related to same article you may contact us.
Guide: Convert Feet to Inches in Excel – Guide
Suppose you need to convert feet to inches in Excel, feet to miles, feet to meters, feet to centimeters or vice versa in Excel, so how can you quickly convert between these units of measure? This article presents some tricky ways to quickly convert units of measurement between feet to inches, feet to miles, and feet to meters in Excel.
manual approach
The first approach we’ll show you is to do the conversion manually. You can convert feet to inches using a simple mathematical calculation. 1 foot equals 12 inches. Therefore, you need to multiply the foot value by 12 to get the same inch value. Let’s say that cell C2 contains the foot value. Use the formula below to find the inch value.
Similarly, you can convert feet to inches. As you can see in the example above, dividing an inch value by 12 returns the feet value. If we assume that cell C5 contains the value in inches, the conversion formula would be something like,
Using the CONVERT function
Another way to convert feet to inches is to use the CONVERT function. The CONVERT function can convert a number from one measurement system to another. The best part is that the function is not just limited to units of length. You can convert weight, distance, temperature and more measurement units to each other.
Briefly, you need to provide the value and both types of measurement in the function. Excel accepts string abbreviations for measurement types. In this example you can use,
As a result, to convert the value in cell B5, you can use a formula like the one below:
= CONVERT (B5, ”ft”, ”in”)
To convert in the opposite direction, simply swap the measurement arguments. The following formula converts the value from inches to feet.
Another dynamic method
You can define cell references for unit arguments. This app allows you to control unit types from and to. We combine the CONVERTER and VLOOKUP functions to create a master formula that gets units to convert from a list or any other type of input. With the help of the VLOOKUP function, we can use friendly names for unit type codes. For example, “feet” to “feet” and “inches” to “inches”.
The VLOOKUP function returns the corresponding unit type to the CONVERT function. This is what the formula looks like:
= CONVERT (B11, VLOOKUP (B12, Length.Table, 2.0), VLOOKUP (D12, Length.Table, 2.0))
Cells B12 and D12 contain a drop-down list that contains the type and length of measurement units, such as strings “Feet” and “Inches”. The VLOOKUP function searches for them in the range named Length.Table and returns the corresponding value.
Final note
I hope you like the guide Guide: Convert Feet to Inches in Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.