{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SpellNumber Function(Peso)","Combination of Various Formulas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SpellNumber Function(Peso)","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of SpellNumber Function"]
[]
[null,"Peso Number","In English Words(Peso)"]
[null,12345,{"$f":"SpellNumber(B5)","v":"Twelve Thousand Three Hundred Forty Five Pesos Only "}]
[null,67890,{"$f":"SpellNumber(B6)","v":"Sixty Seven Thousand Eight Hundred Ninety  Pesos Only "}]
[null,2458.6,"Two Thousand Four Hundred Fifty Eight & 60/100 Pesos Only"]
[null,3445.45,"Three Thousand Four Hundred Forty Five & 45/100 Pesos Only"]
[null,5974.88,"Five Thousand Nine Hundred Seventy Four & 88/100 Pesos Only"]
[null,2478.37,"Two Thousand Four Hundred Seventy Eight & 37/100 Pesos Only"]
[null,235.75,"Two Hundred Thirty Five & 75/100 Pesos Only"]
[null,7894.87,"Seven Thousand Eight Hundred Ninety Four & 87/100 Pesos Only"]

{"sheet":"Combination of Various Formulas","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Combination of Various Formulas"]
[]
[null,"Number","In English Words"]
[null,12345,{"$f":"CHOOSE(LEFT(TEXT(B5,\"000000000.00\"))+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--LEFT(TEXT(B5,\"000000000.00\"))=0,,IF(AND(--MID(TEXT(B5,\"000000000.00\"),2,1)=0,--MID(TEXT(B5,\"000000000.00\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&CHOOSE(MID(TEXT(B5,\"000000000.00\"),2,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B5,\"000000000.00\"),2,1)<>1,CHOOSE(MID(TEXT(B5,\"000000000.00\"),3,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),\nCHOOSE(MID(TEXT(B8,\"000000000.00\"),3,1)+1,\"Ten\",\"Eleven\",\"Twelve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"))\n&IF((--LEFT(TEXT(B5,\"000000000.00\"))+MID(TEXT(B5,\"000000000.00\"),2,1)+MID(TEXT(B5,\"000000000.00\"),3,1))=0,,IF(AND((--MID(TEXT(B5,\"000000000.00\"),4,1)+MID(TEXT(B5,\"000000000.00\"),5,1)+MID(TEXT(B5,\"000000000.00\"),6,1)+MID(TEXT(B5,\"000000000.00\"),7,1))=0,(--MID(TEXT(B5,\"000000000.00\"),8,1)+RIGHT(TEXT(B5,\"000000000.00\")))>0),\" Million and \",\" Million \"))\n&CHOOSE(MID(TEXT(B5,\"000000000.00\"),4,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B5,\"000000000.00\"),4,1)=0,,IF(AND(--MID(TEXT(B5,\"000000000.00\"),5,1)=0,--MID(TEXT(B5,\"000000000.00\"),6,1)=0),\" Hundred\",\" Hundred and\"))\n&CHOOSE(MID(TEXT(B5,\"000000000.00\"),5,1)+1,,,\" Twenty\",\" Thirty\",\" Forty\",\" Fifty\",\" Sixty\",\" Seventy\",\" Eighty\",\" Ninety\")\n&IF(--MID(TEXT(B5,\"000000000.00\"),5,1)<>1,CHOOSE(MID(TEXT(B5,\"000000000.00\"),6,1)+1,,\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\"),CHOOSE(MID(TEXT(B5,\"000000000.00\"),6,1)+1,\" Ten\",\" Eleven\",\" Twelve\",\" Thirteen\",\" Fourteen\",\" Fifteen\",\" Sixteen\",\" Seventeen\",\" Eighteen\",\" Nineteen\"))\n&IF((--MID(TEXT(B5,\"000000000.00\"),4,1)+MID(TEXT(B5,\"000000000.00\"),5,1)+MID(TEXT(B5,\"000000000.00\"),6,1))=0,,IF(OR((--MID(TEXT(B5,\"000000000.00\"),7,1)+MID(TEXT(B5,\"000000000.00\"),8,1)+MID(TEXT(B5,\"000000000.00\"),9,1))=0,--MID(TEXT(B5,\"000000000.00\"),7,1)<>0),\" Thousand \",\" Thousand and \"))\n&CHOOSE(MID(TEXT(B5,\"000000000.00\"),7,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B5,\"000000000.00\"),7,1)=0,,IF(AND(--MID(TEXT(B5,\"000000000.00\"),8,1)=0,--MID(TEXT(B5,\"000000000.00\"),9,1)=0),\" Hundred \",\" Hundred and \"))&\nCHOOSE(MID(TEXT(B5,\"000000000.00\"),8,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B5,\"000000000.00\"),8,1)<>1,CHOOSE(MID(TEXT(B5,\"000000000.00\"),9,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),CHOOSE(MID(TEXT(B5,\"000000000.00\"),9,1)+1,\"Ten\",\"Eleven\",\"Twelve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"))\n\n&\" & \"&RIGHT(TEXT(B5,\"000000000.00\"),2)&\"/100\"","v":" Twelve Thousand Three Hundred and Forty Five & 00/100"}]
[null,67890,{"$f":"CHOOSE(LEFT(TEXT(B6,\"000000000.00\"))+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--LEFT(TEXT(B6,\"000000000.00\"))=0,,IF(AND(--MID(TEXT(B6,\"000000000.00\"),2,1)=0,--MID(TEXT(B6,\"000000000.00\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&CHOOSE(MID(TEXT(B6,\"000000000.00\"),2,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B6,\"000000000.00\"),2,1)<>1,CHOOSE(MID(TEXT(B6,\"000000000.00\"),3,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),\nCHOOSE(MID(TEXT(B9,\"000000000.00\"),3,1)+1,\"Ten\",\"Eleven\",\"Twelve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"))\n&IF((--LEFT(TEXT(B6,\"000000000.00\"))+MID(TEXT(B6,\"000000000.00\"),2,1)+MID(TEXT(B6,\"000000000.00\"),3,1))=0,,IF(AND((--MID(TEXT(B6,\"000000000.00\"),4,1)+MID(TEXT(B6,\"000000000.00\"),5,1)+MID(TEXT(B6,\"000000000.00\"),6,1)+MID(TEXT(B6,\"000000000.00\"),7,1))=0,(--MID(TEXT(B6,\"000000000.00\"),8,1)+RIGHT(TEXT(B6,\"000000000.00\")))>0),\" Million and \",\" Million \"))\n&CHOOSE(MID(TEXT(B6,\"000000000.00\"),4,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B6,\"000000000.00\"),4,1)=0,,IF(AND(--MID(TEXT(B6,\"000000000.00\"),5,1)=0,--MID(TEXT(B6,\"000000000.00\"),6,1)=0),\" Hundred\",\" Hundred and\"))\n&CHOOSE(MID(TEXT(B6,\"000000000.00\"),5,1)+1,,,\" Twenty\",\" Thirty\",\" Forty\",\" Fifty\",\" Sixty\",\" Seventy\",\" Eighty\",\" Ninety\")\n&IF(--MID(TEXT(B6,\"000000000.00\"),5,1)<>1,CHOOSE(MID(TEXT(B6,\"000000000.00\"),6,1)+1,,\" One\",\" Two\",\" Three\",\" Four\",\" Five\",\" Six\",\" Seven\",\" Eight\",\" Nine\"),CHOOSE(MID(TEXT(B6,\"000000000.00\"),6,1)+1,\" Ten\",\" Eleven\",\" Twelve\",\" Thirteen\",\" Fourteen\",\" Fifteen\",\" Sixteen\",\" Seventeen\",\" Eighteen\",\" Nineteen\"))\n&IF((--MID(TEXT(B6,\"000000000.00\"),4,1)+MID(TEXT(B6,\"000000000.00\"),5,1)+MID(TEXT(B6,\"000000000.00\"),6,1))=0,,IF(OR((--MID(TEXT(B6,\"000000000.00\"),7,1)+MID(TEXT(B6,\"000000000.00\"),8,1)+MID(TEXT(B6,\"000000000.00\"),9,1))=0,--MID(TEXT(B6,\"000000000.00\"),7,1)<>0),\" Thousand \",\" Thousand and \"))\n&CHOOSE(MID(TEXT(B6,\"000000000.00\"),7,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\")\n&IF(--MID(TEXT(B6,\"000000000.00\"),7,1)=0,,IF(AND(--MID(TEXT(B6,\"000000000.00\"),8,1)=0,--MID(TEXT(B6,\"000000000.00\"),9,1)=0),\" Hundred \",\" Hundred and \"))&\nCHOOSE(MID(TEXT(B6,\"000000000.00\"),8,1)+1,,,\"Twenty \",\"Thirty \",\"Forty \",\"Fifty \",\"Sixty \",\"Seventy \",\"Eighty \",\"Ninety \")\n&IF(--MID(TEXT(B6,\"000000000.00\"),8,1)<>1,CHOOSE(MID(TEXT(B6,\"000000000.00\"),9,1)+1,,\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"),CHOOSE(MID(TEXT(B6,\"000000000.00\"),9,1)+1,\"Ten\",\"Eleven\",\"Twelve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"))\n\n&\" & \"&RIGHT(TEXT(B6,\"000000000.00\"),2)&\"/100\"","v":" Sixty Seven Thousand Eight Hundred and Ninety  & 00/100"}]
[null,2458.6," Two Thousand Four Hundred and Fifty Eight & 60/100"]
[null,3445.45," Three Thousand Four Hundred and Forty Five & 45/100"]
[null,5974.88," Five Thousand Nine Hundred and Seventy Four & 88/100"]
[null,2478.37," Two Thousand Four Hundred and Seventy Eight & 37/100"]
[null,235.75,"Two Hundred and Thirty Five & 75/100"]
[null,7894.87," Seven Thousand Eight Hundred and Ninety Four & 87/100"]