Create a Converter Using Excel

For this activity you must use Excel to create a converter. 

Your converter can look like the example supplied click here or you can change it to look however you want.

  1. Choose the type of measure you wish to convert, such as miles to kilometres etc.

  2. Find out the correct conversion rate for your measurement (the links below will help).

  3. Create a spreadsheet to allow someone to convert measurements click here for step by step instructions

  4. Solve My Problem.

 

You can set your page to convert any number of measures, such as:

LENGTH

AREA

VOLUME

WEIGHT

CAPACITY

TEMPERATURE

(click the headings above for conversion information)

 

 

 

 

 

 

length

 Back to Top of Page

FROM TO MULTIPLY BY
millimetres inches 0.03937
inches millimetres 25.4
centimetres inches 0.3937
inches centimetres 2.54
metres feet 3.281
feet metres 0.3048
metres yards 1.094
yards metres 0.9144
kilometres miles 0.6214
miles kilometres 1.609
metres fathoms 1.8288
fathoms metres 3.2808

 

 

 

 

area

 Back to Top of Page

FROM TO MULTIPLY BY
sq. millimetres sq. inches 0.00155
sq. inches sq. millimetres 645.16
sq. centimetres sq. inches 0.155
sq. inches sq. centimetres 6.452
sq. metres sq. feet 10.76
sq. feet sq. metres 0.0929
sq. metres sq. yards 1.196
sq. yards sq. metres 0.835
sq. kilometres sq. miles 0.3861
sq. miles sq. kilometres 2.59
hectacres acres 2.471
acres hectacres 0.4047

 

 

 

 

volume

  Back to Top of Page

FROM TO MULTIPLY BY
cu. centimetres cu. inches 0.06102
cu. inches cu. centimetres 16.39
cu. metres cu. feet 35.31
cu. feet cu. metres 0.02832
cu. metres cu. yards 1.308
cu. yards cu. metres 0.7646

 

 

 

 

weight

  Back to Top of Page

FROM TO MULTIPLY BY
grams grains 15.43
grains grams 0.0648
grams ounces 0.03527
ounces grams 28.35
grams pounds 0.002205
pounds grams 453.6
kilograms pounds 2.205
pounds kilograms 0.4536
kilograms tons 0.0009842
tons kilograms 1016
tonnes tons 0.9842
tons tonnes 1.016

 

 

 

 

capacity

  Back to Top of Page

FROM TO MULTIPLY BY
litres pints 1.76
pints litres 0.5682
litres gallons 0.22
gallons litres 4.546
litres US gallons 0.2642
US gallons litres 3.7878
litres cu. inches 61.03
cu. inches litres 0.01639
 
gallons US gallons 1.2009
US gallons gallons 0.832674

 

 

 

 

 

temperature

 Back to Top of Page

FROM TO MULTIPLY BY
centigrade fahrenheit 1.8 (then +32)
fahrenheit centigrade (-32 then) 0.5555