=RUPIAH(amount) – "Rp 1.250.000" as text
Apps Script recipes › Sheet formulas
Formats a number as rupiah text with dots between thousands, for labels, emails and documents made from the Sheet.
Use it in a Google Sheet
After saving the code in a script bound to the spreadsheet, type =RUPIAH(A2) in a cell. It works on one cell or a range.
File Code.gs
/**
* Formats a number as rupiah text.
* @param {number} amount The number, or a range of numbers.
* @param {number} [decimals] Digits after the comma (default 0).
* @return Text like "Rp 1.250.000".
* @customfunction
*/
function RUPIAH(amount, decimals) {
if (Array.isArray(amount)) return amount.map(row => row.map(v => RUPIAH(v, decimals)));
if (amount === '' || amount === null || isNaN(Number(amount))) return '';
const d = Math.max(0, Math.min(4, Number(decimals) || 0));
const n = Number(amount);
const [whole, frac] = Math.abs(n).toFixed(d).split('.');
const dotted = whole.replace(/\B(?=(\d{3})+(?!\d))/g, '.');
return (n < 0 ? '-' : '') + 'Rp ' + dotted + (frac ? ',' + frac : '');
}
Good to know
- For numbers you still calculate with, a number format (Format › Number › Custom) is better: the cell stays a number.
Let the AI put it in your appGAS AI Builder knows every recipe here. Describe your app and it uses this code where it fits, in a Google Apps Script project in your own Drive.
Use it in a projectMore in Sheet formulas
=EMAIL_VALID(text) – check email addressesTRUE when the text looks like an email address; catches spaces, missing @ and common typos like gmial.com.
=EMAIL_VALID()=HARI_KERJA_LIBUR(start; end; holidays) – working days with a holiday tabCounts working days between two dates, skipping the holidays listed in a range; =HARI_KERJA_LIBUR(B2; C2; Libur!A:A; 6) counts Saturdays as work days.=HARI_KERJA_LIBUR()=JSON_GET(json; path) – read a value from JSON in a cell=JSON_GET(A2; "customer.name") or "items.0.price" pulls one value out of JSON stored in a cell.=JSON_GET()=NOMOR_HP(phone) – one format for phone numbers"0812-3456-7890" and "+62 812 3456 7890" both become 6281234567890, the form WhatsApp links need.=NOMOR_HP()=SLUG(text) – short ids from names"Kopi Susu Gula Aren (Large)" becomes "kopi-susu-gula-aren-large", for codes, file names and links.=SLUG()=TANGGAL_INDO(date) – "Selasa, 3 November 2026"Writes a date with Indonesian day and month names; =TANGGAL_INDO(A2; FALSE) leaves out the day name.=TANGGAL_INDO()