Kod percuma - hanya C&P ke cell goolesheet - Untuk kod javascript, Number to Word conversion hingga 16 digit dengan symbol currency dan cent/sen, inbox
Ini adalah kod / function yang saya reka untuk Google sheet - number to word conversion yg pada asalnya saya buat dalam tahun 1994/95 (sebelum ada googlesheet agaknya) dan di guna dalam msexcel dengan memecahkan kod kedalam beberapa cell dan di 'concatenate' kan kerana cell hanya dapat memuatkan tidak lebih dari 255 karektor/aksara
Cell Googlesheet boleh memuatkan 5000 karektor / aksara maksima.
Diubahsuai dan dicantum untuk/dlm satu cell dalam Google sheet.
Ini hanya untuk integer. Boleh di tambah & sesuai ke 2 decimal dan ditambah ungkapan Ringgit dan sen supaya ia boleh digunakan untuk invoice, cheque/check writer & legal document.
Saya Tak Tau bagaimana orang lain buat. Yang saya Tau kod ini berfungsi untuk tujuan yang saya maksudkan.
Yang nak kod dalam JavaSscript inbox sy.
Sila Cut and paste
'=(TRIM(IF(OR(B2>999999,B2<1),"This version is limited to 6 digit (integer only)",(IF(AND(VALUE(RIGHT(B2,6))>99999,VALUE(RIGHT(B2,6))<1000000),INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},1,VALUE(LEFT(RIGHT(B2,6),1))+1)&" "&"Hundred"&" "&IF(VALUE(INDEX({"100000","200000","300000","400000","500000","600000","700000","800000","900000"},1,VALUE(LEFT(RIGHT(B2,6),1))))/1000=VALUE(LEFT(RIGHT(B2,6),3)),"Thousand",""),"")&" "&IF(AND(VALUE(RIGHT(B2,5))>19999,VALUE(RIGHT(B2,5))<100000),INDEX({"Twenty","Thirty","Fourty","Fifty","Sixty","Seventy","Eighty","Ninety"},1,VALUE(LEFT(RIGHT(B2,5),1)-1)),"")&" "&IF(AND(VALUE(RIGHT(B2,5))>19999,VALUE(RIGHT(B2,5))<100000),INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},1,RIGHT(LEFT(RIGHT(B2,5),2),1)+1)&" "&"Thousand","")&" "&IF(AND(VALUE(RIGHT(B2,5))>9999,VALUE(RIGHT(B2,5))<20000),INDEX({"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},1,VALUE(LEFT(RIGHT(B2,5),2))-9)&" "&"Thousand","")&" "&IF(AND(VALUE(RIGHT(B2,5))>999,VALUE(RIGHT(B2,5))<10000),CONCATENATE(INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},1,VALUE(LEFT(RIGHT(B2,4),1))+1)," ","Thousand"),"")&" "&IF(AND(VALUE(RIGHT(B2,3))>99, VALUE(RIGHT(B2,3))<1000), CONCATENATE(INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},1,VALUE(LEFT(RIGHT(B2,3),1))+1)," ","Hundred"),"")&" "&IF(AND(VALUE(RIGHT(B2,2))>19,VALUE(RIGHT(B2,2))<100),INDEX({"","Twenty","Thirty","Fourty","Fifty","Sixty","Seventy","Eighty","Ninety"},1, (VALUE(LEFT(RIGHT(B2,2),1)))),"")&" "&IF(AND(VALUE(RIGHT(B2,2))>9,VALUE(RIGHT(B2,2))<20),INDEX({"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},1,RIGHT(B2,1)+1),"")&" "&IF(OR(VALUE(RIGHT(B2,2))>20,VALUE(RIGHT(B2,2))<10),INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},1,RIGHT(B2,1)+1),""))))
Selamat mencuba
Dan ini kod dalam Bahasa Malayu, kenyah, Kayan& Miriek.
Struktur kod tidak Sama dengan B.Inggeris
MALAY
-----
=TRIM(IF(OR(B2>999999,B2<1),"Versi ini di hadkan kepada 6 digit integer sahaja", IF(AND(VALUE(RIGHT(B2,6))>99999,VALUE(RIGHT(B2,6))<1000000),INDEX({"","Satu","Dua","Tiga","Empat","Lima","Enam","Tujuh","Lapan","Sembilan"},1,VALUE(LEFT(RIGHT(B2,6),1))+1)&" "&"Ratus"&" "&IF(VALUE(INDEX({"100000","200000","300000","400000","500000","600000","700000","800000","900000"},1,VALUE(LEFT(RIGHT(B2,6),1))))/1000=VALUE(LEFT(RIGHT(B2,6),3)),"Ribu",""),"")&" "&IF(AND(VALUE(RIGHT(B2,5))>19999,VALUE(RIGHT(B2,5))<100000),INDEX({"Dua Puluh","Tiga Puluh","Empat Puluh","Lima Puluh","Enam Puluh","Tujuh Puluh","Lapan Puluh","Sembilan Puluh"},1,VALUE(LEFT(RIGHT(B2,5),1)-1)),"")&" "&IF(AND(VALUE(RIGHT(B2,5))>19999,VALUE(RIGHT(B2,5))<100000),INDEX({"","Satu","Dua","Tiga","Empat","Lima","Enam","Tujuh","Lapan","Sembilan"},1,RIGHT(LEFT(RIGHT(B2,5),2),1)+1)&" "&"Ribu","")&" "&IF(AND(VALUE(RIGHT(B2,5))>9999,VALUE(RIGHT(B2,5))<20000),INDEX({"Sepuluh","Sebelas","Dua Belas","Tiga Belas","Empat Belas","Lima Belas","Enam Belas","Tujuh Belas","Lapan Belas","Sembilan Belas"},1,VALUE(LEFT(RIGHT(B2,5),2))-9)&" "&"Ribu","")&" "&IF(AND(VALUE(RIGHT(B2,5))>999,VALUE(RIGHT(B2,5))<10000),CONCATENATE(INDEX({"","Satu","Dua","Tiga","Empat","Lima","Enam","Tujuh","Lapan","Sembilan"},1,VALUE(LEFT(RIGHT(B2,4),1))+1)," ","Ribu"),"")&" "&IF(AND(VALUE(RIGHT(B2,3))>99, VALUE(RIGHT(B2,3))<1000), CONCATENATE(INDEX({"","Satu","Dua","Tiga","Empat","Lima","Enam","Tujuh","Lapan","Sembilan"},1,VALUE(LEFT(RIGHT(B2,3),1))+1)," ","Ratus"),"")&" "&IF(AND(VALUE(RIGHT(B2,2))>19,VALUE(RIGHT(B2,2))<100),INDEX({"","Dua Puluh","Tiga Puluh","Empat Puluh","Lima Puluh","Enam Puluh","Tujuh Puluh","Lapan Puluh","Sembilan Puluh"},1, (VALUE(LEFT(RIGHT(B2,2),1)))),"")&" "&IF(AND(VALUE(RIGHT(B2,2))>9,VALUE(RIGHT(B2,2))<20),INDEX({"Sepuluh","Sebelas","Dua Belas","Tiga Belas","Empat Belas","Lima Belas","Enam Belas","Tujuh Belas","Lapan Belas","Sembilan Belas"},1,RIGHT(B2,1)+1),"")&" "&IF(OR(VALUE(RIGHT(B2,2))>20,VALUE(RIGHT(B2,2))<10),INDEX({"","Satu","Dua","Tiga","Empat","Lima","Enam","Tujuh","Lapan","Sembilan"},1,RIGHT(B2,1)+1),"")))
MIRIEK
------
=TRIM(IF(OR(B2>999999,B2<1),"Versi itoi muat nam digit ajek",(IF(AND(VALUE(LEFT(RIGHT(B2,6),6))>99999,VALUE(LEFT(RIGHT(B2,6),6))<1000000),INDEX({"","Seh","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madi'","Supiek"},1,VALUE(LEFT(RIGHT(B2,6),1))+1)&" "&"Ratau"&" "&IF(VALUE(LEFT(RIGHT(B2,5),2))=0,"Ribow"," ")," ")&""&IF(AND(VALUE(LEFT(RIGHT(B2,5),5))>9999,VALUE(LEFT(RIGHT(B2,5),5))<100000),INDEX({"","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madik","Supiek"},1,VALUE(LEFT(RIGHT(B2,5),1))) &" "&"Fuluk"&" "&IF(VALUE(LEFT(RIGHT(B2,4),1))=0,"Ribow"," ")," ") &" "&IF(AND(VALUE(LEFT(RIGHT(B2,4),4))>999,VALUE(LEFT(RIGHT(B2,4),4))<10000),INDEX({"","Seh","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madi'","Supiek"},1,VALUE(LEFT(RIGHT(B2,4),1))+1)&" "&"Ribow"," ")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,3),3))>99,VALUE(LEFT(RIGHT(B2,3),3))<1000), INDEX({"","Seh","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madi'","Supiek"},1,VALUE(LEFT(RIGHT(B2,3),1))+1)&" "&"Ratau"," ")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,2),2))>9,VALUE(LEFT(RIGHT(B2,2),2))<100),INDEX({"","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madik","Supiek"},1,VALUE(LEFT(RIGHT(B2,2),1))) &" "&"Fuluk"," ")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,1),1))>0,VALUE(LEFT(RIGHT(B2,1),1))<10),INDEX({"","Seh","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madi'","Supiek"},1,VALUE(LEFT(RIGHT(B2,1)))+1),""))))
KENYAH
------
=TRIM(IF(OR(B2>999999,B2<1),"Versi itou anun nem lubun bah keh",(IF(AND(VALUE(LEFT(RIGHT(B2,6),6))>99999,VALUE(LEFT(RIGHT(B2,6),6))<1000000),INDEX({"","Jah","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,6),1))+1)&" "&"Ato"&" "&IF(VALUE(LEFT(RIGHT(B2,5),2))=0,"Evou",""),"")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,5),5))>9999,VALUE(LEFT(RIGHT(B2,5),5))<100000),INDEX({"","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,5),1))) &" "&"Nyap"&" "&IF(VALUE(LEFT(RIGHT(B2,4),1))=0,"Evou",""),"")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,4),4))>999,VALUE(LEFT(RIGHT(B2,4),4))<10000),INDEX({"","Jah","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,4),1))+1)&" "&"Evou","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,3),3))>99,VALUE(LEFT(RIGHT(B2,3),3))<1000), INDEX({"","Jah","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,3),1))+1)&" "&"Ato","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,2),2))>9,VALUE(LEFT(RIGHT(B2,2),2))<100),INDEX({"","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,2),1))) &" "&"Nyap","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,1),1))>0,VALUE(LEFT(RIGHT(B2,1),1))<10),INDEX({"","Jah","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,1)))+1),""))))
KAYAN
-----
=TRIM(IF(OR(B2>999999,B2<1),"Versi anih deng ateng nem lubun tua",(IF(AND(VALUE(LEFT(RIGHT(B2,6),6))>99999,VALUE(LEFT(RIGHT(B2,6),6))<1000000),INDEX({"","Ji","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,6),1))+1)&" "&"Ato"&" "&IF(VALUE(LEFT(RIGHT(B2,5),2))=0,"Libu",""),"")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,5),5))>9999,VALUE(LEFT(RIGHT(B2,5),5))<100000),INDEX({"","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,5),1))) &" "&"Pulu"&" "&IF(VALUE(LEFT(RIGHT(B2,4),1))=0,"Libu",""),"")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,4),4))>999,VALUE(LEFT(RIGHT(B2,4),4))<10000),INDEX({"","Ji","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,4),1))+1)&" "&"Libu","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,3),3))>99,VALUE(LEFT(RIGHT(B2,3),3))<1000), INDEX({"","Ji","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,3),1))+1)&" "&"Atuh","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,2),2))>9,VALUE(LEFT(RIGHT(B2,2),2))<100),INDEX({"","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,2),1))) &" "&"Pulu","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,1),1))>0,VALUE(LEFT(RIGHT(B2,1),1))<10),INDEX({"","Ji","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,1)))+1),""))))
Ini adalah kod / function yang saya reka untuk Google sheet - number to word conversion yg pada asalnya saya buat dalam tahun 1994/95 (sebelum ada googlesheet agaknya) dan di guna dalam msexcel dengan memecahkan kod kedalam beberapa cell dan di 'concatenate' kan kerana cell hanya dapat memuatkan tidak lebih dari 255 karektor/aksara
Cell Googlesheet boleh memuatkan 5000 karektor / aksara maksima.
Diubahsuai dan dicantum untuk/dlm satu cell dalam Google sheet.
Ini hanya untuk integer. Boleh di tambah & sesuai ke 2 decimal dan ditambah ungkapan Ringgit dan sen supaya ia boleh digunakan untuk invoice, cheque/check writer & legal document.
Saya Tak Tau bagaimana orang lain buat. Yang saya Tau kod ini berfungsi untuk tujuan yang saya maksudkan.
Yang nak kod dalam JavaSscript inbox sy.
Sila Cut and paste
'=(TRIM(IF(OR(B2>999999,B2<1),"This version is limited to 6 digit (integer only)",(IF(AND(VALUE(RIGHT(B2,6))>99999,VALUE(RIGHT(B2,6))<1000000),INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},1,VALUE(LEFT(RIGHT(B2,6),1))+1)&" "&"Hundred"&" "&IF(VALUE(INDEX({"100000","200000","300000","400000","500000","600000","700000","800000","900000"},1,VALUE(LEFT(RIGHT(B2,6),1))))/1000=VALUE(LEFT(RIGHT(B2,6),3)),"Thousand",""),"")&" "&IF(AND(VALUE(RIGHT(B2,5))>19999,VALUE(RIGHT(B2,5))<100000),INDEX({"Twenty","Thirty","Fourty","Fifty","Sixty","Seventy","Eighty","Ninety"},1,VALUE(LEFT(RIGHT(B2,5),1)-1)),"")&" "&IF(AND(VALUE(RIGHT(B2,5))>19999,VALUE(RIGHT(B2,5))<100000),INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},1,RIGHT(LEFT(RIGHT(B2,5),2),1)+1)&" "&"Thousand","")&" "&IF(AND(VALUE(RIGHT(B2,5))>9999,VALUE(RIGHT(B2,5))<20000),INDEX({"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},1,VALUE(LEFT(RIGHT(B2,5),2))-9)&" "&"Thousand","")&" "&IF(AND(VALUE(RIGHT(B2,5))>999,VALUE(RIGHT(B2,5))<10000),CONCATENATE(INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},1,VALUE(LEFT(RIGHT(B2,4),1))+1)," ","Thousand"),"")&" "&IF(AND(VALUE(RIGHT(B2,3))>99, VALUE(RIGHT(B2,3))<1000), CONCATENATE(INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},1,VALUE(LEFT(RIGHT(B2,3),1))+1)," ","Hundred"),"")&" "&IF(AND(VALUE(RIGHT(B2,2))>19,VALUE(RIGHT(B2,2))<100),INDEX({"","Twenty","Thirty","Fourty","Fifty","Sixty","Seventy","Eighty","Ninety"},1, (VALUE(LEFT(RIGHT(B2,2),1)))),"")&" "&IF(AND(VALUE(RIGHT(B2,2))>9,VALUE(RIGHT(B2,2))<20),INDEX({"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},1,RIGHT(B2,1)+1),"")&" "&IF(OR(VALUE(RIGHT(B2,2))>20,VALUE(RIGHT(B2,2))<10),INDEX({"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},1,RIGHT(B2,1)+1),""))))
Selamat mencuba
Dan ini kod dalam Bahasa Malayu, kenyah, Kayan& Miriek.
Struktur kod tidak Sama dengan B.Inggeris
MALAY
-----
=TRIM(IF(OR(B2>999999,B2<1),"Versi ini di hadkan kepada 6 digit integer sahaja", IF(AND(VALUE(RIGHT(B2,6))>99999,VALUE(RIGHT(B2,6))<1000000),INDEX({"","Satu","Dua","Tiga","Empat","Lima","Enam","Tujuh","Lapan","Sembilan"},1,VALUE(LEFT(RIGHT(B2,6),1))+1)&" "&"Ratus"&" "&IF(VALUE(INDEX({"100000","200000","300000","400000","500000","600000","700000","800000","900000"},1,VALUE(LEFT(RIGHT(B2,6),1))))/1000=VALUE(LEFT(RIGHT(B2,6),3)),"Ribu",""),"")&" "&IF(AND(VALUE(RIGHT(B2,5))>19999,VALUE(RIGHT(B2,5))<100000),INDEX({"Dua Puluh","Tiga Puluh","Empat Puluh","Lima Puluh","Enam Puluh","Tujuh Puluh","Lapan Puluh","Sembilan Puluh"},1,VALUE(LEFT(RIGHT(B2,5),1)-1)),"")&" "&IF(AND(VALUE(RIGHT(B2,5))>19999,VALUE(RIGHT(B2,5))<100000),INDEX({"","Satu","Dua","Tiga","Empat","Lima","Enam","Tujuh","Lapan","Sembilan"},1,RIGHT(LEFT(RIGHT(B2,5),2),1)+1)&" "&"Ribu","")&" "&IF(AND(VALUE(RIGHT(B2,5))>9999,VALUE(RIGHT(B2,5))<20000),INDEX({"Sepuluh","Sebelas","Dua Belas","Tiga Belas","Empat Belas","Lima Belas","Enam Belas","Tujuh Belas","Lapan Belas","Sembilan Belas"},1,VALUE(LEFT(RIGHT(B2,5),2))-9)&" "&"Ribu","")&" "&IF(AND(VALUE(RIGHT(B2,5))>999,VALUE(RIGHT(B2,5))<10000),CONCATENATE(INDEX({"","Satu","Dua","Tiga","Empat","Lima","Enam","Tujuh","Lapan","Sembilan"},1,VALUE(LEFT(RIGHT(B2,4),1))+1)," ","Ribu"),"")&" "&IF(AND(VALUE(RIGHT(B2,3))>99, VALUE(RIGHT(B2,3))<1000), CONCATENATE(INDEX({"","Satu","Dua","Tiga","Empat","Lima","Enam","Tujuh","Lapan","Sembilan"},1,VALUE(LEFT(RIGHT(B2,3),1))+1)," ","Ratus"),"")&" "&IF(AND(VALUE(RIGHT(B2,2))>19,VALUE(RIGHT(B2,2))<100),INDEX({"","Dua Puluh","Tiga Puluh","Empat Puluh","Lima Puluh","Enam Puluh","Tujuh Puluh","Lapan Puluh","Sembilan Puluh"},1, (VALUE(LEFT(RIGHT(B2,2),1)))),"")&" "&IF(AND(VALUE(RIGHT(B2,2))>9,VALUE(RIGHT(B2,2))<20),INDEX({"Sepuluh","Sebelas","Dua Belas","Tiga Belas","Empat Belas","Lima Belas","Enam Belas","Tujuh Belas","Lapan Belas","Sembilan Belas"},1,RIGHT(B2,1)+1),"")&" "&IF(OR(VALUE(RIGHT(B2,2))>20,VALUE(RIGHT(B2,2))<10),INDEX({"","Satu","Dua","Tiga","Empat","Lima","Enam","Tujuh","Lapan","Sembilan"},1,RIGHT(B2,1)+1),"")))
MIRIEK
------
=TRIM(IF(OR(B2>999999,B2<1),"Versi itoi muat nam digit ajek",(IF(AND(VALUE(LEFT(RIGHT(B2,6),6))>99999,VALUE(LEFT(RIGHT(B2,6),6))<1000000),INDEX({"","Seh","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madi'","Supiek"},1,VALUE(LEFT(RIGHT(B2,6),1))+1)&" "&"Ratau"&" "&IF(VALUE(LEFT(RIGHT(B2,5),2))=0,"Ribow"," ")," ")&""&IF(AND(VALUE(LEFT(RIGHT(B2,5),5))>9999,VALUE(LEFT(RIGHT(B2,5),5))<100000),INDEX({"","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madik","Supiek"},1,VALUE(LEFT(RIGHT(B2,5),1))) &" "&"Fuluk"&" "&IF(VALUE(LEFT(RIGHT(B2,4),1))=0,"Ribow"," ")," ") &" "&IF(AND(VALUE(LEFT(RIGHT(B2,4),4))>999,VALUE(LEFT(RIGHT(B2,4),4))<10000),INDEX({"","Seh","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madi'","Supiek"},1,VALUE(LEFT(RIGHT(B2,4),1))+1)&" "&"Ribow"," ")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,3),3))>99,VALUE(LEFT(RIGHT(B2,3),3))<1000), INDEX({"","Seh","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madi'","Supiek"},1,VALUE(LEFT(RIGHT(B2,3),1))+1)&" "&"Ratau"," ")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,2),2))>9,VALUE(LEFT(RIGHT(B2,2),2))<100),INDEX({"","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madik","Supiek"},1,VALUE(LEFT(RIGHT(B2,2),1))) &" "&"Fuluk"," ")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,1),1))>0,VALUE(LEFT(RIGHT(B2,1),1))<10),INDEX({"","Seh","Debeh","Telouh","Pat","Limah","Nam","Tujuk","Madi'","Supiek"},1,VALUE(LEFT(RIGHT(B2,1)))+1),""))))
KENYAH
------
=TRIM(IF(OR(B2>999999,B2<1),"Versi itou anun nem lubun bah keh",(IF(AND(VALUE(LEFT(RIGHT(B2,6),6))>99999,VALUE(LEFT(RIGHT(B2,6),6))<1000000),INDEX({"","Jah","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,6),1))+1)&" "&"Ato"&" "&IF(VALUE(LEFT(RIGHT(B2,5),2))=0,"Evou",""),"")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,5),5))>9999,VALUE(LEFT(RIGHT(B2,5),5))<100000),INDEX({"","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,5),1))) &" "&"Nyap"&" "&IF(VALUE(LEFT(RIGHT(B2,4),1))=0,"Evou",""),"")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,4),4))>999,VALUE(LEFT(RIGHT(B2,4),4))<10000),INDEX({"","Jah","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,4),1))+1)&" "&"Evou","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,3),3))>99,VALUE(LEFT(RIGHT(B2,3),3))<1000), INDEX({"","Jah","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,3),1))+1)&" "&"Ato","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,2),2))>9,VALUE(LEFT(RIGHT(B2,2),2))<100),INDEX({"","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,2),1))) &" "&"Nyap","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,1),1))>0,VALUE(LEFT(RIGHT(B2,1),1))<10),INDEX({"","Jah","Luwah","Telou","Pat","Lemeh","Nem","Tujek","Ayah","Pien"},1,VALUE(LEFT(RIGHT(B2,1)))+1),""))))
KAYAN
-----
=TRIM(IF(OR(B2>999999,B2<1),"Versi anih deng ateng nem lubun tua",(IF(AND(VALUE(LEFT(RIGHT(B2,6),6))>99999,VALUE(LEFT(RIGHT(B2,6),6))<1000000),INDEX({"","Ji","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,6),1))+1)&" "&"Ato"&" "&IF(VALUE(LEFT(RIGHT(B2,5),2))=0,"Libu",""),"")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,5),5))>9999,VALUE(LEFT(RIGHT(B2,5),5))<100000),INDEX({"","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,5),1))) &" "&"Pulu"&" "&IF(VALUE(LEFT(RIGHT(B2,4),1))=0,"Libu",""),"")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,4),4))>999,VALUE(LEFT(RIGHT(B2,4),4))<10000),INDEX({"","Ji","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,4),1))+1)&" "&"Libu","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,3),3))>99,VALUE(LEFT(RIGHT(B2,3),3))<1000), INDEX({"","Ji","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,3),1))+1)&" "&"Atuh","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,2),2))>9,VALUE(LEFT(RIGHT(B2,2),2))<100),INDEX({"","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,2),1))) &" "&"Pulu","")&" "&IF(AND(VALUE(LEFT(RIGHT(B2,1),1))>0,VALUE(LEFT(RIGHT(B2,1),1))<10),INDEX({"","Ji","Duak","Telok","Pat","Lima","Nem","Tusu","Saya'","Pitan"},1,VALUE(LEFT(RIGHT(B2,1)))+1),""))))
No comments:
Post a Comment