Maaf, memang sebelumnya belum saya set jika pemisah angka decimal adalah: , “koma”
Coba buka Name Manager Rubah name des yang semula refer to =”0.00” menjadi “0,00” (tanda titik diganti koma) From: Syamsul Abidin Ibnu Miftahuddin [mailto:[email protected]] Sent: Wednesday, December 05, 2012 8:07 PM To: [email protected] Cc: [email protected] Subject: Re: ]] XL-mania [[ Merubah Mega Formula ribuan _____ Mas kayaknya ada kesalahan rumus.... mohon bantuan revisinya ya... file sdh saya sertakan From: zainul_ulum[at]yahoo[dot]com <[email protected]> To: [email protected] Sent: Wednesday, December 5, 2012 7:16 AM Subject: RE: ]] XL-mania [[ Merubah Mega Formula ribuan Coba rumus terlampir. Belum saya coba kalo setting regionalnya Indonesia. Formula ini maksimal 999999999.99 Jadi selain untuk isi raport, juga bisa untuk kwitansi From: [email protected] <mailto:XL-mania%40yahoogroups.com> [mailto:[email protected] <mailto:XL-mania%40yahoogroups.com> ] On Behalf Of Syamsul Abidin Ibnu Miftahuddin Sent: Tuesday, December 04, 2012 2:25 PM To: [email protected] <mailto:XL-mania%40yahoogroups.com> Subject: ]] XL-mania [[ Merubah Mega Formula ribuan Mohon bantuannya pada teman-teman XL mania, gmn cara merubah mega formula berikut (formula ini maksimal 999,99): =IF(--INT(B11)=0;"Nol ";IF(--(LEFT(TEXT(INT(B11);"000")))=1;"Seratus ";IF(--(LEFT(TEXT(INT(B11);"000")))>1;INDEX(N;--(LEFT(TEXT(INT(B11);"000"))) )&"Ratus ";"")))&IF(--(MID(TEXT(INT(B11);"000");2;1))=0;"";IF(--(MID(TEXT(INT(B11);"0 00");2;1))=1;CHOOSE((--(RIGHT(TEXT(INT(B11);"0")))=0)*1+((--(RIGHT(TEXT(INT( B11);"0")))=1)*2)+((--(RIGHT(TEXT(INT(B11);"0")))>1)*3);"Sepuluh ";"Sebelas ";INDEX(N;--(RIGHT(TEXT(INT(B11);"0"))))&"Belas ");IF(--(MID(TEXT(INT(B11);"000");2;1))>1;INDEX(N;--(MID(TEXT(INT(B11);"000" );2;1)))&"Puluh ")))&IF(OR(--(MID(TEXT(INT(B11);"000");2;1))=1;--(RIGHT(TEXT(INT(B11);"0"))) =0);"";INDEX(N;--(RIGHT(TEXT(INT(B11);"0")))))&"Koma "&IF(--LEFT(TEXT(MOD(B11;1)*100;"00"))=0;"Nol ";INDEX(N;LEFT(TEXT(MOD(B11;1)*100;"00"))))&IF(--RIGHT(TEXT(MOD(B11;1)*100;" 00"))=0;"Nol ";INDEX(N;RIGHT(TEXT(MOD(B11;1)*100;"00")))) Menjadi ribuan, misal 1.500,56 (Seribu lima ratus koma lima enam) mohon bantuannya, untuk saya gunakan mengisi rapot.
<<image001.jpg>>
<<image002.jpg>>
