Buzz
Currently, Google Sheets is widely used due to its quick accessibility, allowing you to use it without any installations. Google Sheets is a web application where you can use it instead of Excel installed on your computer. As we know, 12 inches equals 1 foot. It's straightforward for us if we calculate using a computer, right? However, if the conversion quantity is large, it will take a lot of time to do so.
CONVERT is a conversion function in Google Sheets, capable of converting various objects such as distance, time, energy, volume, speed, etc. In the following article, Mytour will guide you on using Google Sheets to convert Feet to Inches
CONVERTING FEET TO INCHES USING CONVERT FUNCTION
The structure of this function is: CONVERT(value, start_unit, end_unit). Where Value is the number to be converted, start_unit is the unit to convert from, end_unit is the unit to convert to.
Take an example:
You select the cell at position B7 in the spreadsheet on Google Sheets. Then you enter into the fx bar: =CONVERT(3,'ft','in') and press Enter . Cell B7 will return the result as 36 for you. In this calculation: 3 is the value, ft (Feet) is the start_unit, in (inches) is the end_unit. This is the formula to convert from Feet to Inches.
This function can also involve area units. It allows you to convert square Feet to square Inches. This is very simple, you just need to replace 'ft' and 'in' in the formula bar with 'ft^2' and 'in^2'.
Take an example:
You modify the calculation formula in cell B7 above to =CONVERT(3,'ft^2','in^2') and press Enter. The result returned at this time will be 432 square Inches. You can see it in the image below
Furthermore, you can also add another Sheet to the CONVERT function. This allows you to add another sheet containing the number you want to convert from feet to inches to a sheet you are working on.
Take an example:
You add another Sheet on the spreadsheet by clicking the '+' sign below. You take the result 36 into cell B7 on Sheet 4 then switch to Sheet 2 where you select cell B6. Here you enter into the fx bar as follows: =CONVERT(Sheet4!B7,'ft','in'). Cell B will return the result 432, which is the conversion result of 36 feet on Sheet 4 to 432 inches on Sheet 5.
CREATE A CONVERSION TABLE FROM FEET TO INCHES
Now you can create a spreadsheet to convert from feet to inches. Open a new spreadsheet on Google Sheets, then draw a table, this table will include 2 columns to fill in 2 units of feet and inches. The number of rows depends on your choice. After making your selections, click on the Border button on the toolbar and choose to create borders for all as shown in the image below. Your table has been successfully created.
Enter 'Feet ' in cell B7 and 'Inches ' in cell C7. Enter the formula in the fx bar as follows: =CONVERT(B8,'ft','in') in cell C8. You can copy this formula to the cells below by holding down the left mouse button and dragging it down to the last cell of the table. From here, every time you enter a number in a cell in column B, the corresponding cell in column C will return the calculated result.
Here is the guide to convert units from Feet to Inches using Google Sheets. Hopefully with this article, you can proficiently use the CONVERT formula on Google Sheets. In addition to the two units, feet and inches, this formula also helps convert other units, with the same method as above. To do this, first, you need to know how to create an online Google Sheets page. With just a Gmail account, access to Drive, you can quickly create a Google Sheets page.
