Site icon Best Excel Tutorial

Stone to pounds and pounds to stones converter

I show you how to convert stone to pounds and pounds to stone using the Microsoft Excel application.

Convert using simple multiplication or division

14 is the crucial number here. To convert stone to pounds, you need to just multiply by 14. Similarly, to convert pounds to stone, you need to divide by 14.

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 using VBA code

This VBA code will ask you how many stone you want to convert to pounds:

Function ConvertStonesToPounds(stones As Double) As Double
ConvertStonesToPounds = stones * 14
End Function
Sub ConvertStonesToPoundsMain()
Dim stones As Double
Dim pounds As Double
stones = InputBox("Enter the number of stones to convert to pounds:")
If IsNumeric(stones) Then
pounds = ConvertStonesToPounds(stones)
MsgBox stones & " stones is equal to " & pounds & " pounds",
vbInformation, "Stones to Pounds Conversion"
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 pounds to stone and ounces

1 stone is equal to 14 pounds, making it easy to calculate. One pound is 16 ounces, making it more difficult to calculate. Luckily, there is an Excel formula which converts pounds to stone and ounces.

=TRUNC(A1/14)&”‘ “&ROUND(MOD(A1,14)*16,0)&””””

It will convert 200 pounds to 14’ 4″.

Exit mobile version