CONVERT

Excel Functions 🇮🇩 Bahasa Indonesia

Konversi satuan pengukuran

Syntax

EXCEL

=CONVERT(number, from_unit, to_unit)

Arguments

Parameter	Deskripsi
`number`	The numeric value to convert.
`from_unit`	The starting units for number.
`to_unit`	The ending units for the result.

Return Value

Angka dalam sistem pengukuran baru

Details

Fungsi CONVERT mengubah angka dalam satu sistem pengukuran ke sistem pengukuran lainnya. Misalnya, Anda dapat menggunakan CONVERT untuk mengubah kaki menjadi meter, pon menjadi kilogram, galon menjadi liter, dan banyak konversi satuan lainnya. Rumus di bawah ini menggunakan fungsi CONVERT untuk mengonversi yard ke meter, Celsius ke Fahrenheit, galon ke liter, dan meter persegi ke yard persegi: Untuk membulatkan hasil yang dikembalikan oleh CONVERT, masukkan CONVERT ke dalam fungsi ROUND: Tabel di bawah menunjukkan satuan yang tersedia untuk fungsi CONVERT di setiap kategori. Dalam semua kasus, Unit dapat digunakan untuk from_unit atau to_unit dalam kategori yang sama. Gunakan satuan-satuan ini untuk mengonversi berbagai ukuran berat dan massa. Ini berguna untuk resep, perhitungan pengiriman, dan aplikasi ilmiah. Misalnya:

Contoh

Examples

The formulas below use the CONVERT function to convert yards to meters, Celsius to Fahrenheit, gallons to liters, and square meters to square yards:

EXCEL

=CONVERT(100,"yd","m") // returns 91.44
=CONVERT(22,"C","F") // returns 71.6
=CONVERT(1,"gal","l") // returns 3.79
=CONVERT(100,"m2","ft2") // returns 1076.39

Examples

To round the results returned by CONVERT, nest CONVERT inside the ROUND function:

EXCEL

=ROUND(CONVERT(100,"yd","m"),0) // yards to meters, returns 91
=ROUND(CONVERT(5,"mi","km"),1) // miles to kilometers, returns 8.0
=ROUND(CONVERT(150,"lbm","kg"),1) // pounds to kilograms, returns 68.0

Mass

Use these units to convert between different measures of weight and mass. This is useful for recipes, shipping calculations, and scientific applicatio

EXCEL

=CONVERT(150,"lbm","kg") // pounds to kilograms, returns 68.04
=CONVERT(500,"g","ozm") // grams to ounces, returns 17.64
=CONVERT(1,"stone","lbm") // stone to pounds, returns 14

Distance

These units allow you to perform conversions related to length and distance. For example:

EXCEL

=CONVERT(5,"mi","km") // miles to kilometers, returns 8.05
=CONVERT(6,"ft","m") // feet to meters, returns 1.83
=CONVERT(100,"cm","in") // centimeters to inches, returns 39.37

Time

Convert between different units of time with these options. For example:

EXCEL

=CONVERT(2.5,"hr","min") // hours to minutes, returns 150
=CONVERT(90,"mn","hr") // minutes to hours, returns 1.5
=CONVERT(1,"day","sec") // days to seconds, returns 86400

Pressure

Use these units for pressure-related conversions, commonly needed in engineering and scientific contexts. For example:

EXCEL

=CONVERT(1,"atm","psi") // atmospheres to PSI, returns 14.70
=CONVERT(30,"psi","Pa") // PSI to pascals, returns 206842.7188
=CONVERT(760,"mmHg","atm") // mmHg to atmospheres, returns 1