Meter to Feet and Feet to Meters Converter
I show you how to convert meters to feet and feet to meters using the Microsoft Excel application.
Convert using simple multiplication or division
3.28 is the key number here. To convert meters to feet, you need to just multiply by 3.28. Similarly, to convert feet to meters, you need to divide by 3.28.
Conversion using CONVERT Excel function
The CONVERT function automatically converts the value based on the specified input and output units, which eliminates the need for a separate conversion factor or formula. This method is more efficient and less prone to errors, as the conversion is handled by the built-in function in Excel.
=CONVERT(cell, “ft”, “m”)
Convert using VBA code
This VBA code will ask you how many feet you want to convert to meters:
Function ConvertFeetToMeters(feet As Double) As Double
ConvertFeetToMeters = feet * 0.3048
End Function
Sub ConvertFeetToMetersMain()
Dim feet As Double
Dim meters As Double
feet = InputBox("Enter the number of feet to convert to meters:")
If IsNumeric(feet) Then
meters = ConvertFeetToMeters(feet)
MsgBox feet & " feet is equal to " & meters & " meters",
vbInformation, "Feet to Meters Conversion"
Else
MsgBox "Invalid input! Please enter a valid number.",
vbExclamation, "Error"
End If
End Sub
The custom functions in the Visual Basic module handle the conversion by applying the appropriate formula, which makes the conversion process easier and more efficient. This method also allows you to modify the conversion formulas if needed, by simply editing the code in the module.
Convert feet and inches to meters
1 foot is equal to 12 inches, making it easy to calculate. One meter is 100 cm, making it more difficult to calculate. Luckily, there is an Excel formula which converts feet and inches to meters.
=(A1*12+A2)/39.37
It will convert 5′ 11″ to 1.8 meters.
Leave a Reply