=выбор левсимв текст


Download 14.21 Kb.
Sana17.06.2023
Hajmi14.21 Kb.
#1539254
Bog'liq
ВЫБОР


=ВЫБОР(ЛЕВСИМВ(ТЕКСТ(C3;"000000000.00"))+1;"One";"Two";"Three";"Four";"Five";"Six";"Seven";"Eight";"Nine") &ЕСЛИ(--ЛЕВСИМВ(ТЕКСТ(C3;"000000000.00"))=0;ЕСЛИ(И(--ПСТР(ТЕКСТ(C3;"000000000.00");2;1)=0,--ПСТР(ТЕКСТ(C3;"000000000.00");3;1)=0);" Hundred";" Hundred and ")) &ВЫБОР(ПСТР(ТЕКСТ(C3;"000000000.00");2;1)+1;"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &ЕСЛИ(--ПСТР(ТЕКСТ(C3;"000000000.00"),2,1)<>1,ВЫБОР(ПСТР(ТЕКСТ(C3;"000000000.00"),3,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"), ВЫБОР(ПСТР(ТЕКСТ(C3;"000000000.00"),3,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen")) &ЕСЛИ((--ЛЕВСИМВ(ТЕКСТ(C3;"000000000.00"))+ПСТР(ТЕКСТ(C3;"000000000.00"),2,1)+ПСТР(ТЕКСТ(C3;"000000000.00"),3,1))=0,,ЕСЛИ(И((--ПСТР(ТЕКСТ(C3;"000000000.00"),4,1)+ПСТР(ТЕКСТ(C3;"000000000.00"),5,1)+ПСТР(ТЕКСТ(C3;"000000000.00"),6,1)+ПСТР(ТЕКСТ(C3;"000000000.00"),7,1))=0,(--ПСТР(ТЕКСТ(C3;"000000000.00"),8,1)+ПРАВСИМВ(ТЕКСТ(C3;"000000000.00")))>0)," Million and "," Million ")) &ВЫБОР(ПСТР(ТЕКСТ(C3;"000000000.00"),4,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &ЕСЛИ(--ПСТР(ТЕКСТ(C3;"000000000.00"),4,1)=0,,ЕСЛИ(И(--ПСТР(ТЕКСТ(C3;"000000000.00"),5,1)=0,--ПСТР(ТЕКСТ(C3;"000000000.00"),6,1)=0)," Hundred"," Hundred and")) &ВЫБОР(ПСТР(ТЕКСТ(C3;"000000000.00"),5,1)+1,,," Twenty"," Thirty"," Forty"," Fifty"," Sixty"," Seventy"," Eighty"," Ninety") &ЕСЛИ(--ПСТР(ТЕКСТ(C3;"000000000.00"),5,1)<>1,ВЫБОР(ПСТР(ТЕКСТ(C3;"000000000.00"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),ВЫБОР(ПСТР(ТЕКСТ(C3;"000000000.00"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen")) &ЕСЛИ((--ПСТР(ТЕКСТ(C3;"000000000.00"),4,1)+ПСТР(ТЕКСТ(C3;"000000000.00"),5,1)+ПСТР(ТЕКСТ(C3;"000000000.00"),6,1))=0,,ЕСЛИ(ИЛИ((--ПСТР(ТЕКСТ(C3;"000000000.00"),7,1)+ПСТР(ТЕКСТ(C3;"000000000.00"),8,1)+ПСТР(ТЕКСТ(C3;"000000000.00"),9,1))=0,--ПСТР(ТЕКСТ(C3;"000000000.00"),7,1)<>0)," Thousand "," Thousand and ")) &ВЫБОР(ПСТР(ТЕКСТ(C3;"000000000.00"),7,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &ЕСЛИ(--ПСТР(ТЕКСТ(C3;"000000000.00"),7,1)=0,,ЕСЛИ(И(--ПСТР(ТЕКСТ(C3;"000000000.00"),8,1)=0,--ПСТР(ТЕКСТ(C3;"000000000.00"),9,1)=0)," Hundred "," Hundred and "))& ВЫБОР(ПСТР(ТЕКСТ(C3;"000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &ЕСЛИ(--ПСТР(ТЕКСТ(C3;"000000000.00"),8,1)<>1,ВЫБОР(ПСТР(ТЕКСТ(C3;"000000000.00"),9,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),ВЫБОР(ПСТР(ТЕКСТ(C3;"000000000.00"),9,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen")) &" Rupees "
Download 14.21 Kb.

Do'stlaringiz bilan baham:




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling