Setelah berhasil diinstal, Anda dapat langsung menggunakannya seperti rumus biasa. Langkah-langkah:
While WPS Office is a powerful and free alternative to Microsoft Office, it does not include the TERBILANG formula natively in its Spreadsheet tool. If you attempt to type =TERBILANG() into a cell on a fresh installation of WPS, it will simply return a #NAME? error, indicating that the formula name is not recognized.
In WPS Spreadsheets, click the button (top-left) and select Options . Go to the Add-ins tab. download add in terbilang wps office
Cara Download Add-In Terbilang WPS Office dan Menggunakannya
| Fungsi | Hasil yang dihasilkan | | ------------------------------ | -------------------------------------- | | =UPPER(terbilang(A1)) | | | =LOWER(terbilang(A1)) | satu juta lima ratus ribu | | =PROPER(terbilang(A1)) | Satu Juta Lima Ratus Ribu | | =PROPER(terbilang(A1)&" rupiah") | Satu Juta Lima Ratus Ribu Rupiah | | =UPPER(terbilang(A1)&" rupiah") | SATU JUTA LIMA RATUS RIBU RUPIAH | error, indicating that the formula name is not recognized
Secara bawaan, rumus hanya menghasilkan teks angka saja. Untuk menambahkan satuan mata uang di akhir kalimat, gabungkan dengan fungsi teks: =TERBILANG(A1) & " Rupiah" Mengatur Huruf Kapital (Proper Case)
💡 If you cannot get the VBA add-in to work, you can copy and paste a long custom "Terbilang" formula directly into your cell, or use the WPS Office file sharing and scripts to map custom text. Cara Download Add-In Terbilang WPS Office dan Menggunakannya
Have you already downloaded a , or do you need help finding a safe source?
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.