{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sample Dataset","Using VBA","Using Formula"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Sample Dataset","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Converting Currency to Words in Excel"]
[]
[null,"Input","Output"]
[null,250]
[null,159.75]
[null,35.25]
[null,78.5]
[null,145.6]

{"sheet":"Using VBA","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Using VBA",null,null,null,">>> Do Yourself >>>"]
[]
[null,"Input","Output",null,null,"Input","Output"]
[null,250,{"$f":"ConvertCurrencytoWords(B5)","v":"Two Hundred Fifty  Dollars and No Cents"},null,null,250]
[null,159.75,{"$f":"ConvertCurrencytoWords(B6)","v":"One Hundred Fifty Nine Dollars and Seventy Five Cents"},null,null,159.75]
[null,35.25,{"$f":"ConvertCurrencytoWords(B7)","v":"Thirty Five Dollars and Twenty Five Cents"},null,null,35.25]
[null,78.5,{"$f":"ConvertCurrencytoWords(B8)","v":"Seventy Eight Dollars and Fifty  Cents"},null,null,78.5]
[null,145.6,{"$f":"ConvertCurrencytoWords(B9)","v":"One Hundred Forty Five Dollars and Sixty  Cents"},null,null,145.6]

{"sheet":"Using Formula","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Using Formula",null,null,null,">>> Do Yourself >>>"]
[]
[null,"Input","Output",null,null,"Input","Output"]
[null,250,{"$f":"IF(OR(LEN(FLOOR(B5,1))=13,FLOOR(B5,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B5>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B5,1)>1,\"\",\"\"))&IF(ISERROR(FIND(\".\",B5,1)),\"\",\" \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B5,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B5,\".\",REPT(\" \",255)),255,200)),2),\"ten\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\")&\"\",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B5,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B5,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\")&\"\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B5,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B5,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\")&\"\",IF(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B5,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one cent\",IF(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B5,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B5,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\")&\"\",\"\")))))))","v":"Two Hundred Fifty"},null,null,250]
[null,159,{"$f":"IF(OR(LEN(FLOOR(B6,1))=13,FLOOR(B6,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B6>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B6),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B6),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B6,1)>1,\"\",\"\"))&IF(ISERROR(FIND(\".\",B6,1)),\"\",\" \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B6,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B6,\".\",REPT(\" \",255)),255,200)),2),\"ten\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\")&\"\",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B6,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B6,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\")&\"\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B6,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B6,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\")&\"\",IF(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B6,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one cent\",IF(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B6,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B6,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\")&\"\",\"\")))))))","v":"One Hundred Fifty-Nine"},null,null,159]
[null,35,{"$f":"IF(OR(LEN(FLOOR(B7,1))=13,FLOOR(B7,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B7>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B7),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B7),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B7,1)>1,\"\",\"\"))&IF(ISERROR(FIND(\".\",B7,1)),\"\",\" \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B7,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B7,\".\",REPT(\" \",255)),255,200)),2),\"ten\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\")&\"\",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B7,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B7,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\")&\"\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B7,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B7,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\")&\"\",IF(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B7,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one cent\",IF(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B7,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B7,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\")&\"\",\"\")))))))","v":"Thirty-Five"},null,null,35]
[null,78,{"$f":"IF(OR(LEN(FLOOR(B8,1))=13,FLOOR(B8,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B8>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B8),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B8),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B8,1)>1,\"\",\"\"))&IF(ISERROR(FIND(\".\",B8,1)),\"\",\" \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B8,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B8,\".\",REPT(\" \",255)),255,200)),2),\"ten\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\")&\"\",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B8,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B8,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\")&\"\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B8,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B8,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\")&\"\",IF(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B8,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one cent\",IF(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B8,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B8,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\")&\"\",\"\")))))))","v":"Seventy-Eight"},null,null,78]
[null,145,{"$f":"IF(OR(LEN(FLOOR(B9,1))=13,FLOOR(B9,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(B9>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(B9),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B9),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(B9,1)>1,\"\",\"\"))&IF(ISERROR(FIND(\".\",B9,1)),\"\",\" \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B9,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B9,\".\",REPT(\" \",255)),255,200)),2),\"ten\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\")&\"\",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B9,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B9,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\")&\"\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B9,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B9,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\")&\"\",IF(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B9,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one cent\",IF(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B9,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[1]Using Formula'!B9,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\")&\"\",\"\")))))))","v":"One Hundred Forty-Five"},null,null,145]