{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dataset","Formula","Code"],"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":"Dataset","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Sales Records in Dirham"]
[]
[null,"Product","Sales","Sales in Word"]
[null,"Apple",29484.09]
[null,"Orange",25676]
[null,"Kiwi",2839]
[null,"Raspberry",20911]
[null,"Blackberry",17810]
[null,"Guava",24817]
[null,"Mango",27771]
[null,"Cherries",9331.98]

{"sheet":"Formula","index":1,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,10,0,12]]}
[null,"Using Formula",null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Sales","Sales in Word",null,null,null,null,null,null,"Product","Sales","Sales in Word"]
[null,"Apple",29484.09,{"$f":"_xlfn.SWITCH((LEFT(TEXT(ROUND(C4,0),\"000000000\"))+1),1,\" \",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--LEFT(TEXT(ROUND(C4,0),\"000000000\"))=0,,IF(AND(--MID(TEXT(ROUND(C4,0),\"000000000\"),2,1)=0,--MID(TEXT(ROUND(C4,0),\"000000000\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&_xlfn.SWITCH((MID(TEXT(ROUND(C4,0),\"000000000\"),2,1)+1),1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C4,0),\"000000000\"),2,1)<>1,_xlfn.SWITCH((MID(TEXT(ROUND(C4,0),\"000000000\"),3,1)+1),1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH((MID(TEXT(ROUND(C4,0),\"000000000\"),3,1)+1),1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))&IF((--LEFT(TEXT(ROUND(C4,0),\"000000000\"))+MID(TEXT(ROUND(C4,0),\"000000000\"),2,1)+MID(TEXT(ROUND(C4,0),\"000000000\"),3,1))=0,,IF(AND((--MID(TEXT(ROUND(C4,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C4,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C4,0),\"000000000\"),6,1)+MID(TEXT(ROUND(C4,0),\"000000000\"),7,1))=0,(--MID(TEXT(ROUND(C4,0),\"000000000\"),8,1)+RIGHT(TEXT(ROUND(C4,0),\"000000000\")))>0),\" Million and \",\" Million \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C4,0),\"000000000\"),4,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C4,0),\"000000000\"),4,1)=0,,IF(AND(--MID(TEXT(ROUND(C4,0),\"000000000\"),5,1)=0,--MID(TEXT(ROUND(C4,0),\"000000000\"),6,1)=0),\" Hundred\",\" Hundred and\"))&_xlfn.SWITCH(MID(TEXT(ROUND(C4,0),\"000000000\"),5,1)+1,1,\"\",2,\"\",3,\" Twenty\",4,\" Thirty\",5,\" Forty\",6,\" Fifty\",7,\" Sixty\",8,\" Seventy\",9,\" Eighty\",10,\" Ninety\")&IF(--MID(TEXT(ROUND(C4,0),\"000000000\"),5,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C4,0),\"000000000\"),6,1)+1,1,\"\",2,\" One\",3,\" Two\",4,\" Three\",5,\" Four\",6,\" Five\",7,\" Six\",8,\" Seven\",9,\" Eight\",10,\" Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C4,0),\"000000000\"),6,1)+1,1,\" Ten\",2,\" Eleven\",3,\" Twelve\",4,\" Thirteen\",5,\" Fourteen\",6,\" Fifteen\",7,\" Sixteen\",8,\" Seventeen\",9,\" Eighteen\",10,\" Nineteen\"))&IF((--MID(TEXT(ROUND(C4,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C4,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C4,0),\"000000000\"),6,1))=0,,IF(OR((--MID(TEXT(ROUND(C4,0),\"000000000\"),7,1)+MID(TEXT(ROUND(C4,0),\"000000000\"),8,1)+MID(TEXT(ROUND(C4,0),\"000000000\"),9,1))=0,--MID(TEXT(ROUND(C4,0),\"000000000\"),7,1)<>0),\" Thousand \",\" Thousand and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C4,0),\"000000000\"),7,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C4,0),\"000000000\"),7,1)=0,,IF(AND(--MID(TEXT(ROUND(C4,0),\"000000000\"),8,1)=0,--MID(TEXT(ROUND(C4,0),\"000000000\"),9,1)=0),\" Hundred \",\" Hundred and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C4,0),\"000000000\"),8,1)+1,1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C4,0),\"000000000\"),8,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C4,0),\"000000000\"),9,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C4,0),\"000000000\"),9,1)+1,1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))\n&\" Dirhams\"","v":"  Twenty Nine Thousand Four Hundred and Eighty Four Dirhams"},null,null,null,null,null,null,"Apple",29484.09]
[null,"Orange",25676,{"$f":"_xlfn.SWITCH((LEFT(TEXT(ROUND(C5,0),\"000000000\"))+1),1,\" \",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--LEFT(TEXT(ROUND(C5,0),\"000000000\"))=0,,IF(AND(--MID(TEXT(ROUND(C5,0),\"000000000\"),2,1)=0,--MID(TEXT(ROUND(C5,0),\"000000000\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&_xlfn.SWITCH((MID(TEXT(ROUND(C5,0),\"000000000\"),2,1)+1),1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C5,0),\"000000000\"),2,1)<>1,_xlfn.SWITCH((MID(TEXT(ROUND(C5,0),\"000000000\"),3,1)+1),1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH((MID(TEXT(ROUND(C5,0),\"000000000\"),3,1)+1),1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))&IF((--LEFT(TEXT(ROUND(C5,0),\"000000000\"))+MID(TEXT(ROUND(C5,0),\"000000000\"),2,1)+MID(TEXT(ROUND(C5,0),\"000000000\"),3,1))=0,,IF(AND((--MID(TEXT(ROUND(C5,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C5,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C5,0),\"000000000\"),6,1)+MID(TEXT(ROUND(C5,0),\"000000000\"),7,1))=0,(--MID(TEXT(ROUND(C5,0),\"000000000\"),8,1)+RIGHT(TEXT(ROUND(C5,0),\"000000000\")))>0),\" Million and \",\" Million \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C5,0),\"000000000\"),4,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C5,0),\"000000000\"),4,1)=0,,IF(AND(--MID(TEXT(ROUND(C5,0),\"000000000\"),5,1)=0,--MID(TEXT(ROUND(C5,0),\"000000000\"),6,1)=0),\" Hundred\",\" Hundred and\"))&_xlfn.SWITCH(MID(TEXT(ROUND(C5,0),\"000000000\"),5,1)+1,1,\"\",2,\"\",3,\" Twenty\",4,\" Thirty\",5,\" Forty\",6,\" Fifty\",7,\" Sixty\",8,\" Seventy\",9,\" Eighty\",10,\" Ninety\")&IF(--MID(TEXT(ROUND(C5,0),\"000000000\"),5,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C5,0),\"000000000\"),6,1)+1,1,\"\",2,\" One\",3,\" Two\",4,\" Three\",5,\" Four\",6,\" Five\",7,\" Six\",8,\" Seven\",9,\" Eight\",10,\" Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C5,0),\"000000000\"),6,1)+1,1,\" Ten\",2,\" Eleven\",3,\" Twelve\",4,\" Thirteen\",5,\" Fourteen\",6,\" Fifteen\",7,\" Sixteen\",8,\" Seventeen\",9,\" Eighteen\",10,\" Nineteen\"))&IF((--MID(TEXT(ROUND(C5,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C5,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C5,0),\"000000000\"),6,1))=0,,IF(OR((--MID(TEXT(ROUND(C5,0),\"000000000\"),7,1)+MID(TEXT(ROUND(C5,0),\"000000000\"),8,1)+MID(TEXT(ROUND(C5,0),\"000000000\"),9,1))=0,--MID(TEXT(ROUND(C5,0),\"000000000\"),7,1)<>0),\" Thousand \",\" Thousand and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C5,0),\"000000000\"),7,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C5,0),\"000000000\"),7,1)=0,,IF(AND(--MID(TEXT(ROUND(C5,0),\"000000000\"),8,1)=0,--MID(TEXT(ROUND(C5,0),\"000000000\"),9,1)=0),\" Hundred \",\" Hundred and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C5,0),\"000000000\"),8,1)+1,1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C5,0),\"000000000\"),8,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C5,0),\"000000000\"),9,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C5,0),\"000000000\"),9,1)+1,1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))\n&\" Dirhams\"","v":"  Twenty Five Thousand Six Hundred and Seventy Six Dirhams"},null,null,null,null,null,null,"Orange",25676]
[null,"Kiwi",2839,{"$f":"_xlfn.SWITCH((LEFT(TEXT(ROUND(C6,0),\"000000000\"))+1),1,\" \",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--LEFT(TEXT(ROUND(C6,0),\"000000000\"))=0,,IF(AND(--MID(TEXT(ROUND(C6,0),\"000000000\"),2,1)=0,--MID(TEXT(ROUND(C6,0),\"000000000\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&_xlfn.SWITCH((MID(TEXT(ROUND(C6,0),\"000000000\"),2,1)+1),1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C6,0),\"000000000\"),2,1)<>1,_xlfn.SWITCH((MID(TEXT(ROUND(C6,0),\"000000000\"),3,1)+1),1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH((MID(TEXT(ROUND(C6,0),\"000000000\"),3,1)+1),1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))&IF((--LEFT(TEXT(ROUND(C6,0),\"000000000\"))+MID(TEXT(ROUND(C6,0),\"000000000\"),2,1)+MID(TEXT(ROUND(C6,0),\"000000000\"),3,1))=0,,IF(AND((--MID(TEXT(ROUND(C6,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C6,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C6,0),\"000000000\"),6,1)+MID(TEXT(ROUND(C6,0),\"000000000\"),7,1))=0,(--MID(TEXT(ROUND(C6,0),\"000000000\"),8,1)+RIGHT(TEXT(ROUND(C6,0),\"000000000\")))>0),\" Million and \",\" Million \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C6,0),\"000000000\"),4,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C6,0),\"000000000\"),4,1)=0,,IF(AND(--MID(TEXT(ROUND(C6,0),\"000000000\"),5,1)=0,--MID(TEXT(ROUND(C6,0),\"000000000\"),6,1)=0),\" Hundred\",\" Hundred and\"))&_xlfn.SWITCH(MID(TEXT(ROUND(C6,0),\"000000000\"),5,1)+1,1,\"\",2,\"\",3,\" Twenty\",4,\" Thirty\",5,\" Forty\",6,\" Fifty\",7,\" Sixty\",8,\" Seventy\",9,\" Eighty\",10,\" Ninety\")&IF(--MID(TEXT(ROUND(C6,0),\"000000000\"),5,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C6,0),\"000000000\"),6,1)+1,1,\"\",2,\" One\",3,\" Two\",4,\" Three\",5,\" Four\",6,\" Five\",7,\" Six\",8,\" Seven\",9,\" Eight\",10,\" Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C6,0),\"000000000\"),6,1)+1,1,\" Ten\",2,\" Eleven\",3,\" Twelve\",4,\" Thirteen\",5,\" Fourteen\",6,\" Fifteen\",7,\" Sixteen\",8,\" Seventeen\",9,\" Eighteen\",10,\" Nineteen\"))&IF((--MID(TEXT(ROUND(C6,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C6,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C6,0),\"000000000\"),6,1))=0,,IF(OR((--MID(TEXT(ROUND(C6,0),\"000000000\"),7,1)+MID(TEXT(ROUND(C6,0),\"000000000\"),8,1)+MID(TEXT(ROUND(C6,0),\"000000000\"),9,1))=0,--MID(TEXT(ROUND(C6,0),\"000000000\"),7,1)<>0),\" Thousand \",\" Thousand and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C6,0),\"000000000\"),7,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C6,0),\"000000000\"),7,1)=0,,IF(AND(--MID(TEXT(ROUND(C6,0),\"000000000\"),8,1)=0,--MID(TEXT(ROUND(C6,0),\"000000000\"),9,1)=0),\" Hundred \",\" Hundred and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C6,0),\"000000000\"),8,1)+1,1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C6,0),\"000000000\"),8,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C6,0),\"000000000\"),9,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C6,0),\"000000000\"),9,1)+1,1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))\n&\" Dirhams\"","v":"  Two Thousand Eight Hundred and Thirty Nine Dirhams"},null,null,null,null,null,null,"Kiwi",2839]
[null,"Raspberry",20911,{"$f":"_xlfn.SWITCH((LEFT(TEXT(ROUND(C7,0),\"000000000\"))+1),1,\" \",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--LEFT(TEXT(ROUND(C7,0),\"000000000\"))=0,,IF(AND(--MID(TEXT(ROUND(C7,0),\"000000000\"),2,1)=0,--MID(TEXT(ROUND(C7,0),\"000000000\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&_xlfn.SWITCH((MID(TEXT(ROUND(C7,0),\"000000000\"),2,1)+1),1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C7,0),\"000000000\"),2,1)<>1,_xlfn.SWITCH((MID(TEXT(ROUND(C7,0),\"000000000\"),3,1)+1),1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH((MID(TEXT(ROUND(C7,0),\"000000000\"),3,1)+1),1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))&IF((--LEFT(TEXT(ROUND(C7,0),\"000000000\"))+MID(TEXT(ROUND(C7,0),\"000000000\"),2,1)+MID(TEXT(ROUND(C7,0),\"000000000\"),3,1))=0,,IF(AND((--MID(TEXT(ROUND(C7,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C7,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C7,0),\"000000000\"),6,1)+MID(TEXT(ROUND(C7,0),\"000000000\"),7,1))=0,(--MID(TEXT(ROUND(C7,0),\"000000000\"),8,1)+RIGHT(TEXT(ROUND(C7,0),\"000000000\")))>0),\" Million and \",\" Million \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C7,0),\"000000000\"),4,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C7,0),\"000000000\"),4,1)=0,,IF(AND(--MID(TEXT(ROUND(C7,0),\"000000000\"),5,1)=0,--MID(TEXT(ROUND(C7,0),\"000000000\"),6,1)=0),\" Hundred\",\" Hundred and\"))&_xlfn.SWITCH(MID(TEXT(ROUND(C7,0),\"000000000\"),5,1)+1,1,\"\",2,\"\",3,\" Twenty\",4,\" Thirty\",5,\" Forty\",6,\" Fifty\",7,\" Sixty\",8,\" Seventy\",9,\" Eighty\",10,\" Ninety\")&IF(--MID(TEXT(ROUND(C7,0),\"000000000\"),5,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C7,0),\"000000000\"),6,1)+1,1,\"\",2,\" One\",3,\" Two\",4,\" Three\",5,\" Four\",6,\" Five\",7,\" Six\",8,\" Seven\",9,\" Eight\",10,\" Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C7,0),\"000000000\"),6,1)+1,1,\" Ten\",2,\" Eleven\",3,\" Twelve\",4,\" Thirteen\",5,\" Fourteen\",6,\" Fifteen\",7,\" Sixteen\",8,\" Seventeen\",9,\" Eighteen\",10,\" Nineteen\"))&IF((--MID(TEXT(ROUND(C7,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C7,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C7,0),\"000000000\"),6,1))=0,,IF(OR((--MID(TEXT(ROUND(C7,0),\"000000000\"),7,1)+MID(TEXT(ROUND(C7,0),\"000000000\"),8,1)+MID(TEXT(ROUND(C7,0),\"000000000\"),9,1))=0,--MID(TEXT(ROUND(C7,0),\"000000000\"),7,1)<>0),\" Thousand \",\" Thousand and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C7,0),\"000000000\"),7,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C7,0),\"000000000\"),7,1)=0,,IF(AND(--MID(TEXT(ROUND(C7,0),\"000000000\"),8,1)=0,--MID(TEXT(ROUND(C7,0),\"000000000\"),9,1)=0),\" Hundred \",\" Hundred and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C7,0),\"000000000\"),8,1)+1,1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C7,0),\"000000000\"),8,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C7,0),\"000000000\"),9,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C7,0),\"000000000\"),9,1)+1,1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))\n&\" Dirhams\"","v":"  Twenty Thousand Nine Hundred and Eleven Dirhams"},null,null,null,null,null,null,"Raspberry",20911]
[null,"Blackberry",17810,{"$f":"_xlfn.SWITCH((LEFT(TEXT(ROUND(C8,0),\"000000000\"))+1),1,\" \",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--LEFT(TEXT(ROUND(C8,0),\"000000000\"))=0,,IF(AND(--MID(TEXT(ROUND(C8,0),\"000000000\"),2,1)=0,--MID(TEXT(ROUND(C8,0),\"000000000\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&_xlfn.SWITCH((MID(TEXT(ROUND(C8,0),\"000000000\"),2,1)+1),1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C8,0),\"000000000\"),2,1)<>1,_xlfn.SWITCH((MID(TEXT(ROUND(C8,0),\"000000000\"),3,1)+1),1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH((MID(TEXT(ROUND(C8,0),\"000000000\"),3,1)+1),1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))&IF((--LEFT(TEXT(ROUND(C8,0),\"000000000\"))+MID(TEXT(ROUND(C8,0),\"000000000\"),2,1)+MID(TEXT(ROUND(C8,0),\"000000000\"),3,1))=0,,IF(AND((--MID(TEXT(ROUND(C8,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C8,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C8,0),\"000000000\"),6,1)+MID(TEXT(ROUND(C8,0),\"000000000\"),7,1))=0,(--MID(TEXT(ROUND(C8,0),\"000000000\"),8,1)+RIGHT(TEXT(ROUND(C8,0),\"000000000\")))>0),\" Million and \",\" Million \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C8,0),\"000000000\"),4,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C8,0),\"000000000\"),4,1)=0,,IF(AND(--MID(TEXT(ROUND(C8,0),\"000000000\"),5,1)=0,--MID(TEXT(ROUND(C8,0),\"000000000\"),6,1)=0),\" Hundred\",\" Hundred and\"))&_xlfn.SWITCH(MID(TEXT(ROUND(C8,0),\"000000000\"),5,1)+1,1,\"\",2,\"\",3,\" Twenty\",4,\" Thirty\",5,\" Forty\",6,\" Fifty\",7,\" Sixty\",8,\" Seventy\",9,\" Eighty\",10,\" Ninety\")&IF(--MID(TEXT(ROUND(C8,0),\"000000000\"),5,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C8,0),\"000000000\"),6,1)+1,1,\"\",2,\" One\",3,\" Two\",4,\" Three\",5,\" Four\",6,\" Five\",7,\" Six\",8,\" Seven\",9,\" Eight\",10,\" Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C8,0),\"000000000\"),6,1)+1,1,\" Ten\",2,\" Eleven\",3,\" Twelve\",4,\" Thirteen\",5,\" Fourteen\",6,\" Fifteen\",7,\" Sixteen\",8,\" Seventeen\",9,\" Eighteen\",10,\" Nineteen\"))&IF((--MID(TEXT(ROUND(C8,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C8,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C8,0),\"000000000\"),6,1))=0,,IF(OR((--MID(TEXT(ROUND(C8,0),\"000000000\"),7,1)+MID(TEXT(ROUND(C8,0),\"000000000\"),8,1)+MID(TEXT(ROUND(C8,0),\"000000000\"),9,1))=0,--MID(TEXT(ROUND(C8,0),\"000000000\"),7,1)<>0),\" Thousand \",\" Thousand and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C8,0),\"000000000\"),7,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C8,0),\"000000000\"),7,1)=0,,IF(AND(--MID(TEXT(ROUND(C8,0),\"000000000\"),8,1)=0,--MID(TEXT(ROUND(C8,0),\"000000000\"),9,1)=0),\" Hundred \",\" Hundred and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C8,0),\"000000000\"),8,1)+1,1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C8,0),\"000000000\"),8,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C8,0),\"000000000\"),9,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C8,0),\"000000000\"),9,1)+1,1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))\n&\" Dirhams\"","v":"  Seventeen Thousand Eight Hundred and Ten Dirhams"},null,null,null,null,null,null,"Blackberry",17810]
[null,"Guava",24817,{"$f":"_xlfn.SWITCH((LEFT(TEXT(ROUND(C9,0),\"000000000\"))+1),1,\" \",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--LEFT(TEXT(ROUND(C9,0),\"000000000\"))=0,,IF(AND(--MID(TEXT(ROUND(C9,0),\"000000000\"),2,1)=0,--MID(TEXT(ROUND(C9,0),\"000000000\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&_xlfn.SWITCH((MID(TEXT(ROUND(C9,0),\"000000000\"),2,1)+1),1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C9,0),\"000000000\"),2,1)<>1,_xlfn.SWITCH((MID(TEXT(ROUND(C9,0),\"000000000\"),3,1)+1),1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH((MID(TEXT(ROUND(C9,0),\"000000000\"),3,1)+1),1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))&IF((--LEFT(TEXT(ROUND(C9,0),\"000000000\"))+MID(TEXT(ROUND(C9,0),\"000000000\"),2,1)+MID(TEXT(ROUND(C9,0),\"000000000\"),3,1))=0,,IF(AND((--MID(TEXT(ROUND(C9,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C9,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C9,0),\"000000000\"),6,1)+MID(TEXT(ROUND(C9,0),\"000000000\"),7,1))=0,(--MID(TEXT(ROUND(C9,0),\"000000000\"),8,1)+RIGHT(TEXT(ROUND(C9,0),\"000000000\")))>0),\" Million and \",\" Million \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C9,0),\"000000000\"),4,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C9,0),\"000000000\"),4,1)=0,,IF(AND(--MID(TEXT(ROUND(C9,0),\"000000000\"),5,1)=0,--MID(TEXT(ROUND(C9,0),\"000000000\"),6,1)=0),\" Hundred\",\" Hundred and\"))&_xlfn.SWITCH(MID(TEXT(ROUND(C9,0),\"000000000\"),5,1)+1,1,\"\",2,\"\",3,\" Twenty\",4,\" Thirty\",5,\" Forty\",6,\" Fifty\",7,\" Sixty\",8,\" Seventy\",9,\" Eighty\",10,\" Ninety\")&IF(--MID(TEXT(ROUND(C9,0),\"000000000\"),5,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C9,0),\"000000000\"),6,1)+1,1,\"\",2,\" One\",3,\" Two\",4,\" Three\",5,\" Four\",6,\" Five\",7,\" Six\",8,\" Seven\",9,\" Eight\",10,\" Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C9,0),\"000000000\"),6,1)+1,1,\" Ten\",2,\" Eleven\",3,\" Twelve\",4,\" Thirteen\",5,\" Fourteen\",6,\" Fifteen\",7,\" Sixteen\",8,\" Seventeen\",9,\" Eighteen\",10,\" Nineteen\"))&IF((--MID(TEXT(ROUND(C9,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C9,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C9,0),\"000000000\"),6,1))=0,,IF(OR((--MID(TEXT(ROUND(C9,0),\"000000000\"),7,1)+MID(TEXT(ROUND(C9,0),\"000000000\"),8,1)+MID(TEXT(ROUND(C9,0),\"000000000\"),9,1))=0,--MID(TEXT(ROUND(C9,0),\"000000000\"),7,1)<>0),\" Thousand \",\" Thousand and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C9,0),\"000000000\"),7,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C9,0),\"000000000\"),7,1)=0,,IF(AND(--MID(TEXT(ROUND(C9,0),\"000000000\"),8,1)=0,--MID(TEXT(ROUND(C9,0),\"000000000\"),9,1)=0),\" Hundred \",\" Hundred and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C9,0),\"000000000\"),8,1)+1,1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C9,0),\"000000000\"),8,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C9,0),\"000000000\"),9,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C9,0),\"000000000\"),9,1)+1,1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))\n&\" Dirhams\"","v":"  Twenty Four Thousand Eight Hundred and Seventeen Dirhams"},null,null,null,null,null,null,"Guava",24817]
[null,"Mango",27771,{"$f":"_xlfn.SWITCH((LEFT(TEXT(ROUND(C10,0),\"000000000\"))+1),1,\" \",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--LEFT(TEXT(ROUND(C10,0),\"000000000\"))=0,,IF(AND(--MID(TEXT(ROUND(C10,0),\"000000000\"),2,1)=0,--MID(TEXT(ROUND(C10,0),\"000000000\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&_xlfn.SWITCH((MID(TEXT(ROUND(C10,0),\"000000000\"),2,1)+1),1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C10,0),\"000000000\"),2,1)<>1,_xlfn.SWITCH((MID(TEXT(ROUND(C10,0),\"000000000\"),3,1)+1),1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH((MID(TEXT(ROUND(C10,0),\"000000000\"),3,1)+1),1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))&IF((--LEFT(TEXT(ROUND(C10,0),\"000000000\"))+MID(TEXT(ROUND(C10,0),\"000000000\"),2,1)+MID(TEXT(ROUND(C10,0),\"000000000\"),3,1))=0,,IF(AND((--MID(TEXT(ROUND(C10,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C10,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C10,0),\"000000000\"),6,1)+MID(TEXT(ROUND(C10,0),\"000000000\"),7,1))=0,(--MID(TEXT(ROUND(C10,0),\"000000000\"),8,1)+RIGHT(TEXT(ROUND(C10,0),\"000000000\")))>0),\" Million and \",\" Million \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C10,0),\"000000000\"),4,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C10,0),\"000000000\"),4,1)=0,,IF(AND(--MID(TEXT(ROUND(C10,0),\"000000000\"),5,1)=0,--MID(TEXT(ROUND(C10,0),\"000000000\"),6,1)=0),\" Hundred\",\" Hundred and\"))&_xlfn.SWITCH(MID(TEXT(ROUND(C10,0),\"000000000\"),5,1)+1,1,\"\",2,\"\",3,\" Twenty\",4,\" Thirty\",5,\" Forty\",6,\" Fifty\",7,\" Sixty\",8,\" Seventy\",9,\" Eighty\",10,\" Ninety\")&IF(--MID(TEXT(ROUND(C10,0),\"000000000\"),5,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C10,0),\"000000000\"),6,1)+1,1,\"\",2,\" One\",3,\" Two\",4,\" Three\",5,\" Four\",6,\" Five\",7,\" Six\",8,\" Seven\",9,\" Eight\",10,\" Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C10,0),\"000000000\"),6,1)+1,1,\" Ten\",2,\" Eleven\",3,\" Twelve\",4,\" Thirteen\",5,\" Fourteen\",6,\" Fifteen\",7,\" Sixteen\",8,\" Seventeen\",9,\" Eighteen\",10,\" Nineteen\"))&IF((--MID(TEXT(ROUND(C10,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C10,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C10,0),\"000000000\"),6,1))=0,,IF(OR((--MID(TEXT(ROUND(C10,0),\"000000000\"),7,1)+MID(TEXT(ROUND(C10,0),\"000000000\"),8,1)+MID(TEXT(ROUND(C10,0),\"000000000\"),9,1))=0,--MID(TEXT(ROUND(C10,0),\"000000000\"),7,1)<>0),\" Thousand \",\" Thousand and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C10,0),\"000000000\"),7,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C10,0),\"000000000\"),7,1)=0,,IF(AND(--MID(TEXT(ROUND(C10,0),\"000000000\"),8,1)=0,--MID(TEXT(ROUND(C10,0),\"000000000\"),9,1)=0),\" Hundred \",\" Hundred and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C10,0),\"000000000\"),8,1)+1,1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C10,0),\"000000000\"),8,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C10,0),\"000000000\"),9,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C10,0),\"000000000\"),9,1)+1,1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))\n&\" Dirhams\"","v":"  Twenty Seven Thousand Seven Hundred and Seventy One Dirhams"},null,null,null,null,null,null,"Mango",27771]
[null,"Cherries",9331.18,{"$f":"_xlfn.SWITCH((LEFT(TEXT(ROUND(C11,0),\"000000000\"))+1),1,\" \",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--LEFT(TEXT(ROUND(C11,0),\"000000000\"))=0,,IF(AND(--MID(TEXT(ROUND(C11,0),\"000000000\"),2,1)=0,--MID(TEXT(ROUND(C11,0),\"000000000\"),3,1)=0),\" Hundred\",\" Hundred and \"))\n&_xlfn.SWITCH((MID(TEXT(ROUND(C11,0),\"000000000\"),2,1)+1),1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C11,0),\"000000000\"),2,1)<>1,_xlfn.SWITCH((MID(TEXT(ROUND(C11,0),\"000000000\"),3,1)+1),1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH((MID(TEXT(ROUND(C11,0),\"000000000\"),3,1)+1),1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))&IF((--LEFT(TEXT(ROUND(C11,0),\"000000000\"))+MID(TEXT(ROUND(C11,0),\"000000000\"),2,1)+MID(TEXT(ROUND(C11,0),\"000000000\"),3,1))=0,,IF(AND((--MID(TEXT(ROUND(C11,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C11,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C11,0),\"000000000\"),6,1)+MID(TEXT(ROUND(C11,0),\"000000000\"),7,1))=0,(--MID(TEXT(ROUND(C11,0),\"000000000\"),8,1)+RIGHT(TEXT(ROUND(C11,0),\"000000000\")))>0),\" Million and \",\" Million \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C11,0),\"000000000\"),4,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C11,0),\"000000000\"),4,1)=0,,IF(AND(--MID(TEXT(ROUND(C11,0),\"000000000\"),5,1)=0,--MID(TEXT(ROUND(C11,0),\"000000000\"),6,1)=0),\" Hundred\",\" Hundred and\"))&_xlfn.SWITCH(MID(TEXT(ROUND(C11,0),\"000000000\"),5,1)+1,1,\"\",2,\"\",3,\" Twenty\",4,\" Thirty\",5,\" Forty\",6,\" Fifty\",7,\" Sixty\",8,\" Seventy\",9,\" Eighty\",10,\" Ninety\")&IF(--MID(TEXT(ROUND(C11,0),\"000000000\"),5,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C11,0),\"000000000\"),6,1)+1,1,\"\",2,\" One\",3,\" Two\",4,\" Three\",5,\" Four\",6,\" Five\",7,\" Six\",8,\" Seven\",9,\" Eight\",10,\" Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C11,0),\"000000000\"),6,1)+1,1,\" Ten\",2,\" Eleven\",3,\" Twelve\",4,\" Thirteen\",5,\" Fourteen\",6,\" Fifteen\",7,\" Sixteen\",8,\" Seventeen\",9,\" Eighteen\",10,\" Nineteen\"))&IF((--MID(TEXT(ROUND(C11,0),\"000000000\"),4,1)+MID(TEXT(ROUND(C11,0),\"000000000\"),5,1)+MID(TEXT(ROUND(C11,0),\"000000000\"),6,1))=0,,IF(OR((--MID(TEXT(ROUND(C11,0),\"000000000\"),7,1)+MID(TEXT(ROUND(C11,0),\"000000000\"),8,1)+MID(TEXT(ROUND(C11,0),\"000000000\"),9,1))=0,--MID(TEXT(ROUND(C11,0),\"000000000\"),7,1)<>0),\" Thousand \",\" Thousand and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C11,0),\"000000000\"),7,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\")&IF(--MID(TEXT(ROUND(C11,0),\"000000000\"),7,1)=0,,IF(AND(--MID(TEXT(ROUND(C11,0),\"000000000\"),8,1)=0,--MID(TEXT(ROUND(C11,0),\"000000000\"),9,1)=0),\" Hundred \",\" Hundred and \"))&_xlfn.SWITCH(MID(TEXT(ROUND(C11,0),\"000000000\"),8,1)+1,1,\"\",2,\"\",3,\"Twenty \",4,\"Thirty \",5,\"Forty \",6,\"Fifty \",7,\"Sixty \",8,\"Seventy \",9,\"Eighty \",10,\"Ninety \")&IF(--MID(TEXT(ROUND(C11,0),\"000000000\"),8,1)<>1,_xlfn.SWITCH(MID(TEXT(ROUND(C11,0),\"000000000\"),9,1)+1,1,\"\",2,\"One\",3,\"Two\",4,\"Three\",5,\"Four\",6,\"Five\",7,\"Six\",8,\"Seven\",9,\"Eight\",10,\"Nine\"),_xlfn.SWITCH(MID(TEXT(ROUND(C11,0),\"000000000\"),9,1)+1,1,\"Ten\",2,\"Eleven\",3,\"Twelve\",4,\"Thirteen\",5,\"Fourteen\",6,\"Fifteen\",7,\"Sixteen\",8,\"Seventeen\",9,\"Eighteen\",10,\"Nineteen\"))\n&\" Dirhams\"","v":"  Nine Thousand Three Hundred and Thirty One Dirhams"},null,null,null,null,null,null,"Cherries",9331.18]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Code","index":2,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,12,0,14]]}
[null,"Using VBA Code",null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Sales","Sales in Word",null,null,null,null,null,null,null,null,"Product","Sales","Sales in Word"]
[null,"Apple",29484.09,{"$f":"Dirham_word(C4)","v":"Twenty Nine Thousand Four Hundred Eighty Four Dirham and Nine Fils"},null,null,null,null,null,null,null,null,"Apple",29484.09]
[null,"Orange",25676,{"$f":"Dirham_word(C5)","v":"Twenty Five Thousand Six Hundred Seventy Six Dirham and No Fils"},null,null,null,null,null,null,null,null,"Orange",25676]
[null,"Kiwi",2839,{"$f":"Dirham_word(C6)","v":"Two Thousand Eight Hundred Thirty Nine Dirham and No Fils"},null,null,null,null,null,null,null,null,"Kiwi",2839]
[null,"Raspberry",20911,{"$f":"Dirham_word(C7)","v":"Twenty  Thousand Nine Hundred Eleven Dirham and No Fils"},null,null,null,null,null,null,null,null,"Raspberry",20911]
[null,"Blackberry",17810,{"$f":"Dirham_word(C8)","v":"Seventeen Thousand Eight Hundred Ten Dirham and No Fils"},null,null,null,null,null,null,null,null,"Blackberry",17810]
[null,"Guava",24817,{"$f":"Dirham_word(C9)","v":"Twenty Four Thousand Eight Hundred Seventeen Dirham and No Fils"},null,null,null,null,null,null,null,null,"Guava",24817]
[null,"Mango",27771,{"$f":"Dirham_word(C10)","v":"Twenty Seven Thousand Seven Hundred Seventy One Dirham and No Fils"},null,null,null,null,null,null,null,null,"Mango",27771]
[null,"Cherries",9331.18,{"$f":"Dirham_word(C11)","v":"Nine Thousand Three Hundred Thirty One Dirham and Eighteen Fils"},null,null,null,null,null,null,null,null,"Cherries",9331.18]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]