In this article, we will learn how to convert inches to decimal using Excel as Inches to decimal calculator. An inch is a commonly used term & is the universal unit of measurement. An inch is the name of a unit of length in a number of various systems.
In Excel, we use different conversion to compare results. Here we know the conversion rate from inches to decimal figures.
1 inch = (1/12) of a foot = 0.083
6 inch = (6/12) of a foot = 0.5
You must have seen this in size chart of school.
We will be using the above-mentioned conversion here..
Let’s take an example as shown below.
Here we have values of feet and inches. We will do it step by step as for everyone’s understanding.
Firstly inches will be converted into decimal and then we will add Feet with Feet(inches into decimal) to get Feet(in decimals).
Use the formula in cell C2.
Copy the formula in other cells, select the cells taking the first cell where the formula is already applied, use shortcut keys Ctrl + D
Now we just have to add Feet with Feet (inches into decimals) using the formula in cell D2
Formula in D2 cell:
We get the below result.
As you can see we got our results using the formula.
We can add directly using the formula below.
|=A2 + (B2/12)|
Frequently Asked Question
Q1. How to convert Decimal to Inches?
You can also Feet in decimals to inches in Excel by just multiplying the decimal part with 12, that would be inches.
You can perform these tasks in Excel 2016, 2013 and 2010.
Hope you understood simple addition and division in Excel. Explore more articles on Excel conversion functions here. Please tell us if there’s any doubt in the comment box below. We will definitely help you.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.