In this tutorial, I will show you how to convert kg to newtons and newtons to kg using the Microsoft Excel application.
Convert using simple multiplication
9.81 is the crucial number here. To convert kg to newtons, you need to just multiply by 9.81. Similarly, to convert newtons to kg, you need to divide by 9.81.
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,”unit1″,”unit2″)
Convert using VBA code
This VBA code will ask you how many kg you want to convert to newtons:
Function ConvertKgToNewtons(kg As Double) As Double
ConvertKgToNewtons = kg * 9.80665
End Function
Sub ConvertKgToNewtonsMain()
Dim kg As Double
Dim newtons As Double
kg = InputBox("Enter the number of kilograms (kg) to convert to newtons:")
If IsNumeric(kg) Then
newtons = ConvertKgToNewtons(kg)
MsgBox kg & " kilograms (kg) is equal to " & newtons & " newtons", vbInformation, "Kilograms to Newtons 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 newtons to kg and grams.
1 kg is equal to 1000 grams, making it easy to calculate. One newton is 0.10197 kg, making it more difficult to calculate. Luckily, there is an Excel formula which converts newtons to kg and grams.
=TRUNC(A1/9.81)&” kg “&ROUND(MOD(A1/9.81*1000,1000),0)&” g”
It will convert 100 N to 10 kg 197 g.
