He Used The Scale 5 Inches = 3 Feet. What Is The Scale Factor Of The Drawing?

How to Do Feet & Inches in Microsoft Excel

By Kenrick Callwood

i number background image by kuhar from Fotolia.com

Microsoft Excel comes equipped with a "Convert" function that allows users to specify any quantity and have it automatically converted to a unlike unit of measurement of measure. The spreadsheet tin easily exist configured to automatically convert the values in ane cavalcade that are expressed in feet into the equivalent corporeality of inches in some other column. However, the program does not support expressions of answers in feet and inches by default. A simple add-in fixes that problem in seconds.

Step ane

Download the InchCalc add-in file to your difficult drive.

Step 2

Open up Microsoft Excel and load the add-in file. In Excel 2000 and 2003, click "Tools," then "Add together-Ins" and click on "Browse." In 2007, click the Office symbol and click "Excel Options," then the "Add-Ins" heading. Click the "Go" button with "Manage Excel Add together-Ins" selected, so click "Browse."

Pace three

Select the location where the add together-in file was downloaded and click "Open."

Step 4

Use the new function to convert inches to feet and inches. Put any number into cell A1 and type "=i2s(A1)" without the quotation marks in prison cell B1. For case, a value of 81 inches (entered 81) in cell A1 will exist shown every bit 6 feet 9 inches (displayed as six' - 9") in cell B1.

Step v

Employ the new role to convert anxiety and inches to inches. Put any number into cell A2 and type "=s2i(A2)" without the quotation marks in jail cell B2. For example, a value of six feet 11 inches (entered equally 6'-eleven") in prison cell A2 will be shown as 83 inches (displayed as 83) in cell B2.

Writer Bio