terbilang excel

IF(--INT(H16)=0,"Nol ",IF(--(LEFT(TEXT(INT(H16),"000")))=1,"Seratus ",IF(-- (LEFT(TEXT(INT(H16),"000")))>1,INDEX(N,--(LEFT(TEXT(INT( H16),"000"))))&"Ratus ","")))&IF(-- (ID(TEXT(INT(H16),"000"),!,1))=0,"",IF(--(ID(TEXT(INT( H16),"000"),!,1))=1,H##SE((-- (RI$HT(TEXT(INT(H16),"0")))=0)%1((--(RI$HT(TEXT(INT( H16),"0")))=1)%!)((-- (RI$HT(TEXT(INT(H16),"0")))>1)%'),"Seulu ","Se*elas ",INDEX(N,-- (RI$HT(TEXT(INT(H16),"0"))))&"+elas "),IF(--(ID(TEXT(INT( H16),"000"),!,1))>1,INDEX(N,-- (ID(TEXT(INT(H16),"000"),!,1)))&"ulu ")))&IF(#R(--(ID(TE XT(INT( H16),"000"),!,1))=1,-- (RI$HT(TEXT(INT(H16),"0")))=0),"",INDEX(N,--(RI$HT(TEXT(INT( H16),"0"))))

Upload: pudan-asin

Post on 04-Nov-2015

218 views

Category:

Documents

0 download

Report

Download

Embed Size (px):

DESCRIPTION

algo

TRANSCRIPT

IF(--INT(H16)=0,"Nol ",IF(--(LEFT(TEXT(INT(H16),"000")))=1,"Seratus ",IF(--(LEFT(TEXT(INT(H16),"000")))>1,INDEX(N,--(LEFT(TEXT(INT(H16),"000"))))&"Ratus ","")))&IF(--(MID(TEXT(INT(H16),"000"),2,1))=0,"",IF(--(MID(TEXT(INT(H16),"000"),2,1))=1,CHOOSE((--(RIGHT(TEXT(INT(H16),"0")))=0)*1+((--(RIGHT(TEXT(INT(H16),"0")))=1)*2)+((--(RIGHT(TEXT(INT(H16),"0")))>1)*3),"Sepuluh ","Sebelas ",INDEX(N,--(RIGHT(TEXT(INT(H16),"0"))))&"Belas "),IF(--(MID(TEXT(INT(H16),"000"),2,1))>1,INDEX(N,--(MID(TEXT(INT(H16),"000"),2,1)))&"Puluh ")))&IF(OR(--(MID(TEXT(INT(H16),"000"),2,1))=1,--(RIGHT(TEXT(INT(H16),"0")))=0),"",INDEX(N,--(RIGHT(TEXT(INT(H16),"0"))))

Rumus Excel

Excel Makalah

Latihan Excel

Modul Excel – Jurusan Kesehatan Lingkungan MODUL EXCEL

Panduan Excel

Temario excel

Microsoft Excel (sutikno, [email protected], sutikno.blog ... · Microsoft Excel (sutikno, [email protected], sutikno.blog.undip.ac.id) A. Pengenalan Microsoft Excel Microsoft Excel atau

Microsoft Excel

Materi Excel

Modul Microsoft Excel - · PDF fileExit Keluar dari Microsoft Excel ... Options Pilihan untuk pengaturan Excel ... Semua keterangan cara menggunakan Microsoft Excel terdapat pada

Excel 2003

ETIKA DAN MORAL DALAM MENGGUNAKAN PERANGKAT TIK … · Teknologi Informasi & Komunikasi (TIK) – MICROSOFT EXCEL 1 MICROSOFT EXCEL PENGENALAN MICROSOFT EXCEL Microsoft Excel merupakan