IR Web

Generator Rumus Terbilang Rupiah

Alat bantu gratis untuk membuat formula Excel & Google Sheets.

1. Pengaturan

Masukkan angka, atur referensi sel, dan pilih opsi format.

Opsi Format Universal

Panduan Penggunaan

  1. Atur opsi format sesuai kebutuhan Anda.
  2. Pastikan Referensi Sel sudah benar (misal: `C2` jika angka Anda ada di sel C2).
  3. Pilih dan salin formula yang sesuai dengan pengaturan regional Excel/Sheets Anda (versi Titik Koma atau Koma).
  4. Buka file Excel atau Google Sheets Anda.
  5. Pilih sel tempat Anda ingin menampilkan hasil terbilang (misal: sel D2).
  6. Tempel (Paste) formula yang sudah disalin ke dalam sel tersebut.

Formula akan secara otomatis membaca nilai dari sel referensi dan menampilkannya dalam format terbilang.

Contoh penerapan formula terbilang di Excel

Pratinjau Hasil

Teks ini akan berubah secara otomatis saat Anda mengubah pengaturan.

Rp 1.234.567,00 (Satu Juta Dua Ratus Tiga Puluh Empat Ribu Lima Ratus Enam Puluh Tujuh rupiah)

2. Formula Siap Pakai

Pilih dan salin formula yang sesuai dengan pengaturan Excel/Sheets Anda.

Umumnya untuk Excel/Sheets regional Indonesia.

=TEXT(A1;"Rp "#.##0,00)&" ("&PROPER((IF(A1=0;"nol";_IF(A1<0;"minus ";"")&SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(--MID(TEXT(ABS(A1);"000000000000000");1;3)=0;"";_MID(TEXT(ABS(A1);"000000000000000");1;1)&" ratus "&MID(TEXT(ABS(A1);"000000000000000");2;1)&" puluh "&MID(TEXT(ABS(A1);"000000000000000");3;1)&" triliun ")&IF(--MID(TEXT(ABS(A1);"000000000000000");4;3)=0;"";_MID(TEXT(ABS(A1);"000000000000000");4;1)&" ratus "&MID(TEXT(ABS(A1);"000000000000000");5;1)&" puluh "&MID(TEXT(ABS(A1);"000000000000000");6;1)&" miliar ")&IF(--MID(TEXT(ABS(A1);"000000000000000");7;3)=0;"";_MID(TEXT(ABS(A1);"000000000000000");7;1)&" ratus "&MID(TEXT(ABS(A1);"000000000000000");8;1)&" puluh "&MID(TEXT(ABS(A1);"000000000000000");9;1)&" juta ")&IF(--MID(TEXT(ABS(A1);"000000000000000");10;3)=0;"";_IF(--MID(TEXT(ABS(A1);"000000000000000");10;3)=1;"*";_MID(TEXT(ABS(A1);"000000000000000");10;1)&" ratus "&MID(TEXT(ABS(A1);"000000000000000");11;1)&" puluh ")&MID(TEXT(ABS(A1);"000000000000000");12;1)&" ribu ")&IF(--MID(TEXT(ABS(A1);"000000000000000");13;3)=0;"";_MID(TEXT(ABS(A1);"000000000000000");13;1)&" ratus "&MID(TEXT(ABS(A1);"000000000000000");14;1)&" puluh "&MID(TEXT(ABS(A1);"000000000000000");15;1)));1;"satu");2;"dua");3;"tiga");4;"empat");5;"lima");6;"enam");7;"tujuh");8;"delapan");9;"sembilan");"0 ratus";"");"0 puluh";"");"satu puluh 0";"sepuluh");"satu puluh satu";"sebelas");"satu puluh dua";"dua belas");"satu puluh tiga";"tiga belas");"satu puluh empat";"empat belas");"satu puluh lima";"lima belas");"satu puluh enam";"enam belas");"satu puluh tujuh";"tujuh belas");"satu puluh delapan";"delapan belas");"satu puluh sembilan";"sembilan belas");"satu ratus";"seratus");"*satu ribu";"seribu");0;""));" ";" "))))&" rupiah"&")"

Umumnya untuk Excel/Sheets regional English (US).

=TEXT(A1,"Rp "#,##0.00)&" ("&PROPER((IF(A1=0,"nol",_IF(A1<0,"minus ","")&SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(--MID(TEXT(ABS(A1),"000000000000000"),1,3)=0,"",_MID(TEXT(ABS(A1),"000000000000000"),1,1)&" ratus "&MID(TEXT(ABS(A1),"000000000000000"),2,1)&" puluh "&MID(TEXT(ABS(A1),"000000000000000"),3,1)&" triliun ")&IF(--MID(TEXT(ABS(A1),"000000000000000"),4,3)=0,"",_MID(TEXT(ABS(A1),"000000000000000"),4,1)&" ratus "&MID(TEXT(ABS(A1),"000000000000000"),5,1)&" puluh "&MID(TEXT(ABS(A1),"000000000000000"),6,1)&" miliar ")&IF(--MID(TEXT(ABS(A1),"000000000000000"),7,3)=0,"",_MID(TEXT(ABS(A1),"000000000000000"),7,1)&" ratus "&MID(TEXT(ABS(A1),"000000000000000"),8,1)&" puluh "&MID(TEXT(ABS(A1),"000000000000000"),9,1)&" juta ")&IF(--MID(TEXT(ABS(A1),"000000000000000"),10,3)=0,"",_IF(--MID(TEXT(ABS(A1),"000000000000000"),10,3)=1,"*",_MID(TEXT(ABS(A1),"000000000000000"),10,1)&" ratus "&MID(TEXT(ABS(A1),"000000000000000"),11,1)&" puluh ")&MID(TEXT(ABS(A1),"000000000000000"),12,1)&" ribu ")&IF(--MID(TEXT(ABS(A1),"000000000000000"),13,3)=0,"",_MID(TEXT(ABS(A1),"000000000000000"),13,1)&" ratus "&MID(TEXT(ABS(A1),"000000000000000"),14,1)&" puluh "&MID(TEXT(ABS(A1),"000000000000000"),15,1))),1,"satu"),2,"dua"),3,"tiga"),4,"empat"),5,"lima"),6,"enam"),7,"tujuh"),8,"delapan"),9,"sembilan"),"0 ratus",""),"0 puluh",""),"satu puluh 0","sepuluh"),"satu puluh satu","sebelas"),"satu puluh dua","dua belas"),"satu puluh tiga","tiga belas"),"satu puluh empat","empat belas"),"satu puluh lima","lima belas"),"satu puluh enam","enam belas"),"satu puluh tujuh","tujuh belas"),"satu puluh delapan","delapan belas"),"satu puluh sembilan","sembilan belas"),"satu ratus","seratus"),"*satu ribu","seribu"),0,""))," "," "))))&" rupiah"&")"

Formula raksasa di atas akan secara otomatis menyesuaikan diri berdasarkan referensi sel dan opsi format yang Anda pilih. Cukup salin dan tempel.