Function Terbilang(n As Double) As String Dim satuan As Variant Dim t As String satuan = Array("", "Satu", "Dua", "Tiga", "Empat", "Lima", "Enam", "Tujuh", "Delapan", "Sembilan", "Sepuluh", "Sebelas") Select Case n Case 0 To 11: t = " " & satuan(Fix(n)) Case 12 To 19: t = Terbilang(n Mod 10) & " Belas" Case 20 To 99: t = Terbilang(Fix(n / 10)) & " Puluh" & Terbilang(n Mod 10) Case 100 To 199: t = " Seratus" & Terbilang(n Mod 100) Case 200 To 999: t = Terbilang(Fix(n / 100)) & " Ratus" & Terbilang(n Mod 100) Case 1000 To 1999: t = " Seribu" & Terbilang(n Mod 1000) Case 2000 To 999999: t = Terbilang(Fix(n / 1000)) & " Ribu" & Terbilang(n Mod 1000) Case 1000000 To 999999999: t = Terbilang(Fix(n / 1000000)) & " Juta" & Terbilang(n Mod 1000000) Case Else: t = Terbilang(Fix(n / 1000000000)) & " Milyar" & Terbilang(n Mod 1000000000) End Select Terbilang = Trim(t) End Function Use code with caution. Langkah Cara Memasang Add-in di WPS Office
If the formula above doesn't work or you need specific formatting (like adding "Rupiah"), you might need a VBA Macro.
Unduh file tersebut. Umumnya berbentuk file .xla atau .xlam .
: Use the & operator to join text: =terbilang(A1) & " rupiah" . download add in terbilang wps office
: If you want to append "Rupiah" at the end of the text, use the string concatenation operator ( & ): =TERBILANG(A1) & " Rupiah"
WPS Office adalah alternatif perkantoran populer yang ringan, kompatibel, dan gratis untuk fungsi dasar. Sayangnya, tidak semua versi WPS Office memiliki fungsi Terbilang secara bawaan. Kabar baiknya, Anda bisa secara gratis dan menginstalnya dalam hitungan menit. Artikel ini akan memandu Anda secara lengkap.
Because official Microsoft Excel .xlam add-ins work in WPS Spreadsheets , you can download any standard Indonesian "Terbilang" add-in file. Function Terbilang(n As Double) As String Dim satuan
If you have installed the add-in but the =terbilang() formula isn't working or returns a #NAME? error, here are some common steps:
Ensure the "Terbilang" option is checked in the list and click 4. How to Use the Formula
Navigate to the folder where you saved your terbilang.xla or terbilang.xlam file. Select the file and click . Umumnya berbentuk file
Complete Guide to Downloading and Installing the Terbilang Add-In for WPS Office
Note: You may need the "WPS VBA" component installed for this to work, which is sometimes a separate installation for certain WPS versions.
Berikut adalah panduan lengkap cara mengunduh, memasang, dan menggunakan add-in terbilang di WPS Office. Cara Download Add-In Terbilang WPS Office
Banyak situs menawarkan download add-in terbilang, namun tidak semuanya aman. Berikut risiko yang perlu diwaspadai: