En este post les indicaré -asi como hemos mostrado en el vídeo relacionado- cómo convertir un número en letras.
VIDEO:
Se trata en este caso de una adaptación de una App desarrollada por ABLE3 Ventures.
El rango de números para este ejercicio va de: 1 – 999999999
En Google Sheets, creamos una hoja y agregamos tres columnas: id, nro, letras.
En AppSheet vinculamos esta hoja y ajustamos las tres columnas citadas en:
id -> text, initial value: UNIQUEID()
nro -> number
letras -> longtext
Luego adicionamos 12 columnas virtuales denominadas:
ultimos3, unidades, decenas, centenas, primeros3, miles, diez miles, cien miles, Mprimeros3, millones, diez millones, cien millones
Finalmente, en la formula de la columna letras y en las columnas virtuales citadas, escribimos las siguientes expresiones:
// letras IFS( LEN(CONCATENATE([nro]))=1,[unidades], LEN(CONCATENATE([nro]))=2,[decenas], LEN(CONCATENATE([nro]))=3,[centenas], LEN(CONCATENATE([nro]))=4, IFS( [ultimos3]="000",[miles]&" mil", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[miles]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[miles]&" mil "&[decenas], TRUE,[miles]&" mil "&[centenas] ), LEN(CONCATENATE([nro]))=5, IFS( [ultimos3]="000",[diez miles]&" mil", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[diez miles]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[diez miles]&" mil "&[decenas], TRUE,[diez miles]&" mil "&[centenas] ), LEN(CONCATENATE([nro]))=6, IFS( [ultimos3]="000",[cien miles]&" mil", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[cien miles]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[cien miles]&" mil "&[decenas], TRUE,[cien miles]&" mil "&[centenas] ), LEN(CONCATENATE([nro]))=7, IFS( [primeros3]="000", IFS( [ultimos3]="000",[millones]&" millones", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[millones]&" millones "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[millones]&" millones "&[decenas], TRUE,[millones]&" millones "&[centenas] ), AND(LEFT([primeros3],2)="00",NOT(RIGHT([primeros3],1)="0")), IFS( [ultimos3]="000",[millones]&" millones "&[millones]&" mil", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[millones]&" millones "&[miles]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[millones]&" millones "&[miles]&" mil "&[decenas], TRUE,[millones]&" millones "&[miles]&" mil "&[centenas] ), AND(LEFT([primeros3],1)="0",NOT(MID([primeros3],2,1)="0")), IFS( [ultimos3]="000",[millones]&" millones "&[diez miles]&" mil", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[millones]&" millones "&[diez miles]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[millones]&" millones "&[diez miles]&" mil "&[decenas], TRUE,[millones]&" millones "&[diez miles]&" mil "&[centenas] ), TRUE, IFS( [ultimos3]="000",[millones]&" millones "&[cien miles]&" mil", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[millones]&" millones "&[cien miles]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[millones]&" millones "&[cien miles]&" mil "&[decenas], TRUE,[millones]&" millones "&[cien miles]&" mil "&[centenas] ) ), LEN(CONCATENATE([nro]))=8, IFS( [primeros3]="000", IFS( [ultimos3]="000",[diez millones]&" millones", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[diez millones]&" millones "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[diez millones]&" millones "&[decenas], TRUE,[diez millones]&" millones "&[centenas] ), AND(LEFT([primeros3],2)="00",NOT(RIGHT([primeros3],1)="0")), IFS( [ultimos3]="000",[diez millones]&" millones "&[millones]&" mil", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[diez millones]&" millones "&[miles]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[diez millones]&" millones "&[miles]&" mil "&[decenas], TRUE,[diez millones]&" millones "&[miles]&" mil "&[centenas] ), AND(LEFT([primeros3],1)="0",NOT(MID([primeros3],2,1)="0")), IFS( [ultimos3]="000",[diez millones]&" millones "&[diez miles]&" mil", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[diez millones]&" millones "&[diez miles]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[diez millones]&" millones "&[diez miles]&" mil "&[decenas], TRUE,[diez millones]&" millones "&[diez miles]&" mil "&[centenas] ), TRUE, IFS( [ultimos3]="000",[diez millones]&" millones "&[cien miles]&" mil", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[diez millones]&" millones "&[cien miles]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[diez millones]&" millones "&[cien miles]&" mil "&[decenas], TRUE,[diez millones]&" millones "&[cien miles]&" mil "&[centenas] ) ), LEN(CONCATENATE([nro]))=9, IFS( [primeros3]="000", IFS( [ultimos3]="000",[cien millones]&" millones", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[cien millones]&" millones "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[cien millones]&" millones "&[decenas], TRUE,[cien millones]&" millones "&[centenas] ), AND(LEFT([primeros3],2)="00",NOT(RIGHT([primeros3],1)="0")), IFS( [ultimos3]="000",[cien millones]&" millones "&[millones]&" mil", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[cien millones]&" millones "&[millones]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[cien millones]&" millones "&[millones]&" mil "&[decenas], TRUE,[cien millones]&" millones "&[millones]&" mil "&[centenas] ), AND(LEFT([primeros3],1)="0",NOT(MID([primeros3],2,1)="0")), IFS( [ultimos3]="000",[cien millones]&" millones "&[diez miles]&" miles", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[cien millones]&" millones "&[diez miles]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[cien millones]&" millones "&[diez miles]&" mil "&[decenas], TRUE,[cien millones]&" millones "&[diez miles]&" mil "&[centenas] ), TRUE, IFS( [ultimos3]="000",[cien millones]&" millones "&[cien miles]&" mil", AND(LEFT([ultimos3],2)="00",NOT(RIGHT([ultimos3],1)="0")),[cien millones]&" millones "&[cien miles]&" mil "&[unidades], AND(LEFT([ultimos3],1)="0",NOT(MID([ultimos3],2,1)="0")),[cien millones]&" millones "&[cien miles]&" mil "&[decenas], TRUE,[cien millones]&" millones "&[cien miles]&" mil "&[centenas] ) ) ) // ultimos3 IF( LEN(CONCATENATE([nro]))>=3, RIGHT(CONCATENATE([nro]),3), CONCATENATE([nro]) ) // unidades IFS( RIGHT([ultimos3],1)="1","Uno", RIGHT([ultimos3],1)="2","Dos", RIGHT([ultimos3],1)="3","Tres", RIGHT([ultimos3],1)="4","cuatro", RIGHT([ultimos3],1)="5","Cinco", RIGHT([ultimos3],1)="6","Seis", RIGHT([ultimos3],1)="7","Siete", RIGHT([ultimos3],1)="8","Ocho", RIGHT([ultimos3],1)="9","Nueve" ) // decenas IFS( LEN([ultimos3])=2, IFS( AND(LEFT([ultimos3],1)="1",RIGHT([ultimos3],1)="0"),"Diez", AND(LEFT([ultimos3],1)="1",RIGHT([ultimos3],1)="1"),"Once", AND(LEFT([ultimos3],1)="1",RIGHT([ultimos3],1)="2"),"Doce", AND(LEFT([ultimos3],1)="1",RIGHT([ultimos3],1)="3"),"Trece", AND(LEFT([ultimos3],1)="1",RIGHT([ultimos3],1)="4"),"Catorce", AND(LEFT([ultimos3],1)="1",RIGHT([ultimos3],1)="5"),"Quince", AND(LEFT([ultimos3],1)="1",RIGHT([ultimos3],1)="6"),"Dieciseis", AND(LEFT([ultimos3],1)="1",RIGHT([ultimos3],1)="7"),"Diecisiete", AND(LEFT([ultimos3],1)="1",RIGHT([ultimos3],1)="8"),"Dieciocho", AND(LEFT([ultimos3],1)="1",RIGHT([ultimos3],1)="9"),"Diecinueve", AND(LEFT([ultimos3],1)="2",RIGHT([ultimos3],1)="0"),"Veinte", AND(LEFT([ultimos3],1)="2",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Veinte y ",[unidades]), AND(LEFT([ultimos3],1)="3",RIGHT([ultimos3],1)="0"),"Treinta", AND(LEFT([ultimos3],1)="3",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Treinta y ",[unidades]), AND(LEFT([ultimos3],1)="4",RIGHT([ultimos3],1)="0"),"Cuarenta", AND(LEFT([ultimos3],1)="4",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Cuarenta y ",[unidades]), AND(LEFT([ultimos3],1)="5",RIGHT([ultimos3],1)="0"),"Cincuenta", AND(LEFT([ultimos3],1)="5",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Cincuenta y ",[unidades]), AND(LEFT([ultimos3],1)="6",RIGHT([ultimos3],1)="0"),"Sesenta", AND(LEFT([ultimos3],1)="6",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Sesenta y ",[unidades]), AND(LEFT([ultimos3],1)="7",RIGHT([ultimos3],1)="0"),"Setenta", AND(LEFT([ultimos3],1)="7",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Setenta y ",[unidades]), AND(LEFT([ultimos3],1)="8",RIGHT([ultimos3],1)="0"),"Ochenta", AND(LEFT([ultimos3],1)="8",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Ochenta y",[unidades]), AND(LEFT([ultimos3],1)="9",RIGHT([ultimos3],1)="0"),"Noventa", AND(LEFT([ultimos3],1)="9",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Noventa y ",[unidades]) ), LEN([ultimos3])>2, IFS( AND(LEFT(RIGHT([ultimos3],2),1)="1",RIGHT([ultimos3],1)="0"),"Diez", AND(LEFT(RIGHT([ultimos3],2),1)="1",RIGHT([ultimos3],1)="1"),"Once", AND(LEFT(RIGHT([ultimos3],2),1)="1",RIGHT([ultimos3],1)="2"),"Doce", AND(LEFT(RIGHT([ultimos3],2),1)="1",RIGHT([ultimos3],1)="3"),"Trece", AND(LEFT(RIGHT([ultimos3],2),1)="1",RIGHT([ultimos3],1)="4"),"Catorce", AND(LEFT(RIGHT([ultimos3],2),1)="1",RIGHT([ultimos3],1)="5"),"Quince", AND(LEFT(RIGHT([ultimos3],2),1)="1",RIGHT([ultimos3],1)="6"),"Dieciseis", AND(LEFT(RIGHT([ultimos3],2),1)="1",RIGHT([ultimos3],1)="7"),"Diecisiete", AND(LEFT(RIGHT([ultimos3],2),1)="1",RIGHT([ultimos3],1)="8"),"Dieciocho", AND(LEFT(RIGHT([ultimos3],2),1)="1",RIGHT([ultimos3],1)="9"),"Diecinueve", AND(LEFT(RIGHT([ultimos3],2),1)="2",RIGHT([ultimos3],1)="0"),"Veinte", AND(LEFT(RIGHT([ultimos3],2),1)="2",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Veinte y ",[unidades]), AND(LEFT(RIGHT([ultimos3],2),1)="3",RIGHT([ultimos3],1)="0"),"Treinta", AND(LEFT(RIGHT([ultimos3],2),1)="3",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Treinta y ",[unidades]), AND(LEFT(RIGHT([ultimos3],2),1)="4",RIGHT([ultimos3],1)="0"),"Cuarenta", AND(LEFT(RIGHT([ultimos3],2),1)="4",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Cuarenta y ",[unidades]), AND(LEFT(RIGHT([ultimos3],2),1)="5",RIGHT([ultimos3],1)="0"),"Cincuenta", AND(LEFT(RIGHT([ultimos3],2),1)="5",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Cincuenta y ",[unidades]), AND(LEFT(RIGHT([ultimos3],2),1)="6",RIGHT([ultimos3],1)="0"),"Sesenta", AND(LEFT(RIGHT([ultimos3],2),1)="6",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Sesenta y ",[unidades]), AND(LEFT(RIGHT([ultimos3],2),1)="7",RIGHT([ultimos3],1)="0"),"Setenta", AND(LEFT(RIGHT([ultimos3],2),1)="7",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Setenta y ",[unidades]), AND(LEFT(RIGHT([ultimos3],2),1)="8",RIGHT([ultimos3],1)="0"),"Ochenta", AND(LEFT(RIGHT([ultimos3],2),1)="8",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Ochenta y ",[unidades]), AND(LEFT(RIGHT([ultimos3],2),1)="9",RIGHT([ultimos3],1)="0"),"Noventa", AND(LEFT(RIGHT([ultimos3],2),1)="9",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Noventa y ",[unidades]) ) ) // centenas IFS( AND(LEFT([ultimos3],1)="1",LEFT(RIGHT([ultimos3],2),1)="0",RIGHT([ultimos3],1)="0"),"Ciento", AND(LEFT([ultimos3],1)="2",LEFT(RIGHT([ultimos3],2),1)="0",RIGHT([ultimos3],1)="0"),"Doscientos", AND(LEFT([ultimos3],1)="3",LEFT(RIGHT([ultimos3],2),1)="0",RIGHT([ultimos3],1)="0"),"Trescientos", AND(LEFT([ultimos3],1)="4",LEFT(RIGHT([ultimos3],2),1)="0",RIGHT([ultimos3],1)="0"),"Cuatrocientos", AND(LEFT([ultimos3],1)="5",LEFT(RIGHT([ultimos3],2),1)="0",RIGHT([ultimos3],1)="0"),"Quinientos", AND(LEFT([ultimos3],1)="6",LEFT(RIGHT([ultimos3],2),1)="0",RIGHT([ultimos3],1)="0"),"Seiscientos", AND(LEFT([ultimos3],1)="7",LEFT(RIGHT([ultimos3],2),1)="0",RIGHT([ultimos3],1)="0"),"Setecientos", AND(LEFT([ultimos3],1)="8",LEFT(RIGHT([ultimos3],2),1)="0",RIGHT([ultimos3],1)="0"),"Ochocientos", AND(LEFT([ultimos3],1)="9",LEFT(RIGHT([ultimos3],2),1)="0",RIGHT([ultimos3],1)="0"),"Novecientos", AND(LEFT([ultimos3],1)="1",LEFT(RIGHT([ultimos3],2),1)="0",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Ciento ",[unidades]), AND(LEFT([ultimos3],1)="2",LEFT(RIGHT([ultimos3],2),1)="0",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Doscientos ",[unidades]), AND(LEFT([ultimos3],1)="3",LEFT(RIGHT([ultimos3],2),1)="0",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Trescientos ",[unidades]), AND(LEFT([ultimos3],1)="4",LEFT(RIGHT([ultimos3],2),1)="0",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Cuatrocientos ",[unidades]), AND(LEFT([ultimos3],1)="5",LEFT(RIGHT([ultimos3],2),1)="0",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Qunientos ",[unidades]), AND(LEFT([ultimos3],1)="6",LEFT(RIGHT([ultimos3],2),1)="0",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Seiscientos ",[unidades]), AND(LEFT([ultimos3],1)="7",LEFT(RIGHT([ultimos3],2),1)="0",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Setecientos ",[unidades]), AND(LEFT([ultimos3],1)="8",LEFT(RIGHT([ultimos3],2),1)="0",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Ochocientos ",[unidades]), AND(LEFT([ultimos3],1)="9",LEFT(RIGHT([ultimos3],2),1)="0",NOT(RIGHT([ultimos3],1)="0")),CONCATENATE("Novecientos ",[unidades]), AND(LEFT([ultimos3],1)="1",NOT(LEFT(RIGHT([ultimos3],2),1)="0")),CONCATENATE("Ciento ",[decenas]), AND(LEFT([ultimos3],1)="2",NOT(LEFT(RIGHT([ultimos3],2),1)="0")),CONCATENATE("Doscientos ",[decenas]), AND(LEFT([ultimos3],1)="3",NOT(LEFT(RIGHT([ultimos3],2),1)="0")),CONCATENATE("Trescientos ",[decenas]), AND(LEFT([ultimos3],1)="4",NOT(LEFT(RIGHT([ultimos3],2),1)="0")),CONCATENATE("Cuatrocientos ",[decenas]), AND(LEFT([ultimos3],1)="5",NOT(LEFT(RIGHT([ultimos3],2),1)="0")),CONCATENATE("Quinientos ",[decenas]), AND(LEFT([ultimos3],1)="6",NOT(LEFT(RIGHT([ultimos3],2),1)="0")),CONCATENATE("Seiscientos ",[decenas]), AND(LEFT([ultimos3],1)="7",NOT(LEFT(RIGHT([ultimos3],2),1)="0")),CONCATENATE("Setecientos ",[decenas]), AND(LEFT([ultimos3],1)="8",NOT(LEFT(RIGHT([ultimos3],2),1)="0")),CONCATENATE("Ochocientos ",[decenas]), AND(LEFT([ultimos3],1)="9",NOT(LEFT(RIGHT([ultimos3],2),1)="0")),CONCATENATE("Novecientos ",[decenas]) ) // primeros3 IFS( LEN(CONCATENATE([nro]))=4,LEFT(CONCATENATE([nro]),1), LEN(CONCATENATE([nro]))=5,LEFT(CONCATENATE([nro]),2), LEN(CONCATENATE([nro]))=6,LEFT(CONCATENATE([nro]),3), LEN(CONCATENATE([nro]))=7,MID(CONCATENATE([nro]),2,3), LEN(CONCATENATE([nro]))=8,MID(CONCATENATE([nro]),3,3), LEN(CONCATENATE([nro]))=9,MID(CONCATENATE([nro]),4,3), ) // miles IFS( RIGHT([primeros3],1)="1","Uno", RIGHT([primeros3],1)="2","Dos", RIGHT([primeros3],1)="3","Tres", RIGHT([primeros3],1)="4","Cuatro", RIGHT([primeros3],1)="5","Cinco", RIGHT([primeros3],1)="6","Seis", RIGHT([primeros3],1)="7","Siete", RIGHT([primeros3],1)="8","Ocho", RIGHT([primeros3],1)="9","Nueve" ) // diez miles IFS( AND(LEFT(RIGHT([primeros3],2),1)="1",RIGHT([primeros3],1)="0"),"Diez", AND(LEFT(RIGHT([primeros3],2),1)="1",RIGHT([primeros3],1)="1"),"Once", AND(LEFT(RIGHT([primeros3],2),1)="1",RIGHT([primeros3],1)="2"),"Doce", AND(LEFT(RIGHT([primeros3],2),1)="1",RIGHT([primeros3],1)="3"),"Trece", AND(LEFT(RIGHT([primeros3],2),1)="1",RIGHT([primeros3],1)="4"),"Catorce", AND(LEFT(RIGHT([primeros3],2),1)="1",RIGHT([primeros3],1)="5"),"Quince", AND(LEFT(RIGHT([primeros3],2),1)="1",RIGHT([primeros3],1)="6"),"Dieciseis", AND(LEFT(RIGHT([primeros3],2),1)="1",RIGHT([primeros3],1)="7"),"Diecisiete", AND(LEFT(RIGHT([primeros3],2),1)="1",RIGHT([primeros3],1)="8"),"Dieciocho", AND(LEFT(RIGHT([primeros3],2),1)="1",RIGHT([primeros3],1)="9"),"Diecinueve", AND(LEFT(RIGHT([primeros3],2),1)="2",RIGHT([primeros3],1)="0"),"Veinte", AND(LEFT(RIGHT([primeros3],2),1)="3",RIGHT([primeros3],1)="0"),"Treinta", AND(LEFT(RIGHT([primeros3],2),1)="4",RIGHT([primeros3],1)="0"),"Cuarenta", AND(LEFT(RIGHT([primeros3],2),1)="5",RIGHT([primeros3],1)="0"),"Cincuenta", AND(LEFT(RIGHT([primeros3],2),1)="6",RIGHT([primeros3],1)="0"),"Sesenta", AND(LEFT(RIGHT([primeros3],2),1)="7",RIGHT([primeros3],1)="0"),"Setenta", AND(LEFT(RIGHT([primeros3],2),1)="8",RIGHT([primeros3],1)="0"),"Ochenta", AND(LEFT(RIGHT([primeros3],2),1)="9",RIGHT([primeros3],1)="0"),"Noventa", AND(LEFT(RIGHT([primeros3],2),1)="2",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Veinte y ",[miles]), AND(LEFT(RIGHT([primeros3],2),1)="3",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Treinta y ",[miles]), AND(LEFT(RIGHT([primeros3],2),1)="4",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Cuarenta y ",[miles]), AND(LEFT(RIGHT([primeros3],2),1)="5",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Cincuenta y ",[miles]), AND(LEFT(RIGHT([primeros3],2),1)="6",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Sesenta y ",[miles]), AND(LEFT(RIGHT([primeros3],2),1)="7",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Setenta y ",[miles]), AND(LEFT(RIGHT([primeros3],2),1)="8",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Ochenta y ",[miles]), AND(LEFT(RIGHT([primeros3],2),1)="9",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Noventa y ",[miles]) ) // cien miles IFS( AND(LEFT([primeros3],1)="1",LEFT(RIGHT([primeros3],2),1)="0",RIGHT([primeros3],1)="0"),"Ciento", AND(LEFT([primeros3],1)="2",LEFT(RIGHT([primeros3],2),1)="0",RIGHT([primeros3],1)="0"),"Doscientos", AND(LEFT([primeros3],1)="3",LEFT(RIGHT([primeros3],2),1)="0",RIGHT([primeros3],1)="0"),"Trescientos", AND(LEFT([primeros3],1)="4",LEFT(RIGHT([primeros3],2),1)="0",RIGHT([primeros3],1)="0"),"Cuatrocientos", AND(LEFT([primeros3],1)="5",LEFT(RIGHT([primeros3],2),1)="0",RIGHT([primeros3],1)="0"),"Quinientos", AND(LEFT([primeros3],1)="6",LEFT(RIGHT([primeros3],2),1)="0",RIGHT([primeros3],1)="0"),"Seiscientos", AND(LEFT([primeros3],1)="7",LEFT(RIGHT([primeros3],2),1)="0",RIGHT([primeros3],1)="0"),"Setecientos", AND(LEFT([primeros3],1)="8",LEFT(RIGHT([primeros3],2),1)="0",RIGHT([primeros3],1)="0"),"Ochocientos", AND(LEFT([primeros3],1)="9",LEFT(RIGHT([primeros3],2),1)="0",RIGHT([primeros3],1)="0"),"Novecientos", AND(LEFT([primeros3],1)="1",LEFT(RIGHT([primeros3],2),1)="0",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Ciento ",[miles]), AND(LEFT([primeros3],1)="2",LEFT(RIGHT([primeros3],2),1)="0",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Doscientos ",[miles]), AND(LEFT([primeros3],1)="3",LEFT(RIGHT([primeros3],2),1)="0",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Trescientos ",[miles]), AND(LEFT([primeros3],1)="4",LEFT(RIGHT([primeros3],2),1)="0",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Cuatrocientos ",[miles]), AND(LEFT([primeros3],1)="5",LEFT(RIGHT([primeros3],2),1)="0",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Quinientos ",[miles]), AND(LEFT([primeros3],1)="6",LEFT(RIGHT([primeros3],2),1)="0",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Seiscientos ",[miles]), AND(LEFT([primeros3],1)="7",LEFT(RIGHT([primeros3],2),1)="0",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Setecientos ",[miles]), AND(LEFT([primeros3],1)="8",LEFT(RIGHT([primeros3],2),1)="0",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Ochocientos ",[miles]), AND(LEFT([primeros3],1)="9",LEFT(RIGHT([primeros3],2),1)="0",NOT(RIGHT([primeros3],1)="0")),CONCATENATE("Novecientos ",[miles]), AND(LEFT([primeros3],1)="1",NOT(LEFT(RIGHT([primeros3],2),1)="0")),CONCATENATE("Ciento ",[diez miles]), AND(LEFT([primeros3],1)="2",NOT(LEFT(RIGHT([primeros3],2),1)="0")),CONCATENATE("Doscientos ",[diez miles]), AND(LEFT([primeros3],1)="3",NOT(LEFT(RIGHT([primeros3],2),1)="0")),CONCATENATE("Trescientos ",[diez miles]), AND(LEFT([primeros3],1)="4",NOT(LEFT(RIGHT([primeros3],2),1)="0")),CONCATENATE("Cuatrocientos ",[diez miles]), AND(LEFT([primeros3],1)="5",NOT(LEFT(RIGHT([primeros3],2),1)="0")),CONCATENATE("Quinientos ",[diez miles]), AND(LEFT([primeros3],1)="6",NOT(LEFT(RIGHT([primeros3],2),1)="0")),CONCATENATE("Seiscientos ",[diez miles]), AND(LEFT([primeros3],1)="7",NOT(LEFT(RIGHT([primeros3],2),1)="0")),CONCATENATE("Setecientos ",[diez miles]), AND(LEFT([primeros3],1)="8",NOT(LEFT(RIGHT([primeros3],2),1)="0")),CONCATENATE("Ochocientos ",[diez miles]), AND(LEFT([primeros3],1)="9",NOT(LEFT(RIGHT([primeros3],2),1)="0")),CONCATENATE("Novecientos ",[diez miles]) ) // Mprimeros 3 - cifras de millones IFS( LEN(CONCATENATE([nro]))=7,LEFT(CONCATENATE([nro]),1), LEN(CONCATENATE([nro]))=8,LEFT(CONCATENATE([nro]),2), LEN(CONCATENATE([nro]))=9,LEFT(CONCATENATE([nro]),3) ) // millones IFS( RIGHT([Mprimeros3],1)="1","Uno", RIGHT([Mprimeros3],1)="2","Dos", RIGHT([Mprimeros3],1)="3","Tres", RIGHT([Mprimeros3],1)="4","Cuatro", RIGHT([Mprimeros3],1)="5","Cinco", RIGHT([Mprimeros3],1)="6","Seis", RIGHT([Mprimeros3],1)="7","Siete", RIGHT([Mprimeros3],1)="8","Ocho", RIGHT([Mprimeros3],1)="9","Nueve" ) // diez millones IFS( LEN([Mprimeros3])=2, IFS( AND(LEFT([Mprimeros3],1)="1",RIGHT([Mprimeros3],1)="0"),"Diez", AND(LEFT([Mprimeros3],1)="1",RIGHT([Mprimeros3],1)="1"),"Once", AND(LEFT([Mprimeros3],1)="1",RIGHT([Mprimeros3],1)="2"),"Doce", AND(LEFT([Mprimeros3],1)="1",RIGHT([Mprimeros3],1)="3"),"Trece", AND(LEFT([Mprimeros3],1)="1",RIGHT([Mprimeros3],1)="4"),"Catorce", AND(LEFT([Mprimeros3],1)="1",RIGHT([Mprimeros3],1)="5"),"Quince", AND(LEFT([Mprimeros3],1)="1",RIGHT([Mprimeros3],1)="6"),"Dieciseis", AND(LEFT([Mprimeros3],1)="1",RIGHT([Mprimeros3],1)="7"),"Diecisiete", AND(LEFT([Mprimeros3],1)="1",RIGHT([Mprimeros3],1)="8"),"Dieciocho", AND(LEFT([Mprimeros3],1)="1",RIGHT([Mprimeros3],1)="9"),"Diecinueve", AND(LEFT([Mprimeros3],1)="2",RIGHT([Mprimeros3],1)="0"),"Veinte", AND(LEFT([Mprimeros3],1)="2",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Veinte ",[millones]), AND(LEFT([Mprimeros3],1)="3",RIGHT([Mprimeros3],1)="0"),"Thirty", AND(LEFT([Mprimeros3],1)="3",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Treinta ",[millones]), AND(LEFT([Mprimeros3],1)="4",RIGHT([Mprimeros3],1)="0"),"Fourty", AND(LEFT([Mprimeros3],1)="4",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Cuarenta ",[millones]), AND(LEFT([Mprimeros3],1)="5",RIGHT([Mprimeros3],1)="0"),"Fifty", AND(LEFT([Mprimeros3],1)="5",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Cincuenta ",[millones]), AND(LEFT([Mprimeros3],1)="6",RIGHT([Mprimeros3],1)="0"),"Sixty", AND(LEFT([Mprimeros3],1)="6",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Sesenta ",[millones]), AND(LEFT([Mprimeros3],1)="7",RIGHT([Mprimeros3],1)="0"),"Seventy", AND(LEFT([Mprimeros3],1)="7",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Setenta ",[millones]), AND(LEFT([Mprimeros3],1)="8",RIGHT([Mprimeros3],1)="0"),"Eighty", AND(LEFT([Mprimeros3],1)="8",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Ochenta ",[millones]), AND(LEFT([Mprimeros3],1)="9",RIGHT([Mprimeros3],1)="0"),"Ninety", AND(LEFT([Mprimeros3],1)="9",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Noventa ",[millones]) ), LEN([Mprimeros3])>2, IFS( AND(LEFT(RIGHT([Mprimeros3],2),1)="1",RIGHT([Mprimeros3],1)="0"),"Diez", AND(LEFT(RIGHT([Mprimeros3],2),1)="1",RIGHT([Mprimeros3],1)="1"),"Once", AND(LEFT(RIGHT([Mprimeros3],2),1)="1",RIGHT([Mprimeros3],1)="2"),"Doce", AND(LEFT(RIGHT([Mprimeros3],2),1)="1",RIGHT([Mprimeros3],1)="3"),"Trece", AND(LEFT(RIGHT([Mprimeros3],2),1)="1",RIGHT([Mprimeros3],1)="4"),"Catorce", AND(LEFT(RIGHT([Mprimeros3],2),1)="1",RIGHT([Mprimeros3],1)="5"),"Quince", AND(LEFT(RIGHT([Mprimeros3],2),1)="1",RIGHT([Mprimeros3],1)="6"),"Dieciseis", AND(LEFT(RIGHT([Mprimeros3],2),1)="1",RIGHT([Mprimeros3],1)="7"),"Diecisiete", AND(LEFT(RIGHT([Mprimeros3],2),1)="1",RIGHT([Mprimeros3],1)="8"),"Dieciocho", AND(LEFT(RIGHT([Mprimeros3],2),1)="1",RIGHT([Mprimeros3],1)="9"),"Diecinueve", AND(LEFT(RIGHT([Mprimeros3],2),1)="2",RIGHT([Mprimeros3],1)="0"),"Veinte", AND(LEFT(RIGHT([Mprimeros3],2),1)="2",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Veinte ",[millones]), AND(LEFT(RIGHT([Mprimeros3],2),1)="3",RIGHT([Mprimeros3],1)="0"),"Thirty", AND(LEFT(RIGHT([Mprimeros3],2),1)="3",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Treinta ",[millones]), AND(LEFT(RIGHT([Mprimeros3],2),1)="4",RIGHT([Mprimeros3],1)="0"),"Fourty", AND(LEFT(RIGHT([Mprimeros3],2),1)="4",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Cuarenta ",[millones]), AND(LEFT(RIGHT([Mprimeros3],2),1)="5",RIGHT([Mprimeros3],1)="0"),"Fifty", AND(LEFT(RIGHT([Mprimeros3],2),1)="5",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Cincuenta ",[millones]), AND(LEFT(RIGHT([Mprimeros3],2),1)="6",RIGHT([Mprimeros3],1)="0"),"Sixty", AND(LEFT(RIGHT([Mprimeros3],2),1)="6",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Sesenta ",[millones]), AND(LEFT(RIGHT([Mprimeros3],2),1)="7",RIGHT([Mprimeros3],1)="0"),"Seventy", AND(LEFT(RIGHT([Mprimeros3],2),1)="7",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Setenta ",[millones]), AND(LEFT(RIGHT([Mprimeros3],2),1)="8",RIGHT([Mprimeros3],1)="0"),"Eighty", AND(LEFT(RIGHT([Mprimeros3],2),1)="8",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Ochenta ",[millones]), AND(LEFT(RIGHT([Mprimeros3],2),1)="9",RIGHT([Mprimeros3],1)="0"),"Ninety", AND(LEFT(RIGHT([Mprimeros3],2),1)="9",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Noventa ",[millones]) ) ) // cien millones IFS( AND(LEFT([Mprimeros3],1)="1",LEFT(RIGHT([Mprimeros3],2),1)="0",RIGHT([Mprimeros3],1)="0"),"Ciento", AND(LEFT([Mprimeros3],1)="2",LEFT(RIGHT([Mprimeros3],2),1)="0",RIGHT([Mprimeros3],1)="0"),"Doscientos", AND(LEFT([Mprimeros3],1)="3",LEFT(RIGHT([Mprimeros3],2),1)="0",RIGHT([Mprimeros3],1)="0"),"Trescientos", AND(LEFT([Mprimeros3],1)="4",LEFT(RIGHT([Mprimeros3],2),1)="0",RIGHT([Mprimeros3],1)="0"),"Cuatrocientos", AND(LEFT([Mprimeros3],1)="5",LEFT(RIGHT([Mprimeros3],2),1)="0",RIGHT([Mprimeros3],1)="0"),"Quinientos", AND(LEFT([Mprimeros3],1)="6",LEFT(RIGHT([Mprimeros3],2),1)="0",RIGHT([Mprimeros3],1)="0"),"Seiscientos", AND(LEFT([Mprimeros3],1)="7",LEFT(RIGHT([Mprimeros3],2),1)="0",RIGHT([Mprimeros3],1)="0"),"Setecientos", AND(LEFT([Mprimeros3],1)="8",LEFT(RIGHT([Mprimeros3],2),1)="0",RIGHT([Mprimeros3],1)="0"),"Ochocientos", AND(LEFT([Mprimeros3],1)="9",LEFT(RIGHT([Mprimeros3],2),1)="0",RIGHT([Mprimeros3],1)="0"),"Novecientos", AND(LEFT([Mprimeros3],1)="1",LEFT(RIGHT([Mprimeros3],2),1)="0",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Ciento ",[millones]), AND(LEFT([Mprimeros3],1)="2",LEFT(RIGHT([Mprimeros3],2),1)="0",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Doscientos ",[millones]), AND(LEFT([Mprimeros3],1)="3",LEFT(RIGHT([Mprimeros3],2),1)="0",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Trescientos ",[millones]), AND(LEFT([Mprimeros3],1)="4",LEFT(RIGHT([Mprimeros3],2),1)="0",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Cuatrocientos ",[millones]), AND(LEFT([Mprimeros3],1)="5",LEFT(RIGHT([Mprimeros3],2),1)="0",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Quinientos",[millones]), AND(LEFT([Mprimeros3],1)="6",LEFT(RIGHT([Mprimeros3],2),1)="0",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Seiscientos ",[millones]), AND(LEFT([Mprimeros3],1)="7",LEFT(RIGHT([Mprimeros3],2),1)="0",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Setecientos ",[millones]), AND(LEFT([Mprimeros3],1)="8",LEFT(RIGHT([Mprimeros3],2),1)="0",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Ochocientos ",[millones]), AND(LEFT([Mprimeros3],1)="9",LEFT(RIGHT([Mprimeros3],2),1)="0",NOT(RIGHT([Mprimeros3],1)="0")),CONCATENATE("Novecientos ",[millones]), AND(LEFT([Mprimeros3],1)="1",NOT(LEFT(RIGHT([Mprimeros3],2),1)="0")),CONCATENATE("Ciento ",[diez millones]), AND(LEFT([Mprimeros3],1)="2",NOT(LEFT(RIGHT([Mprimeros3],2),1)="0")),CONCATENATE("Doscientos ",[diez millones]), AND(LEFT([Mprimeros3],1)="3",NOT(LEFT(RIGHT([Mprimeros3],2),1)="0")),CONCATENATE("Trescientos ",[diez millones]), AND(LEFT([Mprimeros3],1)="4",NOT(LEFT(RIGHT([Mprimeros3],2),1)="0")),CONCATENATE("Cuatrocientos ",[diez millones]), AND(LEFT([Mprimeros3],1)="5",NOT(LEFT(RIGHT([Mprimeros3],2),1)="0")),CONCATENATE("Quinientos ",[diez millones]), AND(LEFT([Mprimeros3],1)="6",NOT(LEFT(RIGHT([Mprimeros3],2),1)="0")),CONCATENATE("Seiscientos ",[diez millones]), AND(LEFT([Mprimeros3],1)="7",NOT(LEFT(RIGHT([Mprimeros3],2),1)="0")),CONCATENATE("Setecientos ",[diez millones]), AND(LEFT([Mprimeros3],1)="8",NOT(LEFT(RIGHT([Mprimeros3],2),1)="0")),CONCATENATE("Ochocientos ",[diez millones]), AND(LEFT([Mprimeros3],1)="9",NOT(LEFT(RIGHT([Mprimeros3],2),1)="0")),CONCATENATE("Novecientos ",[diez millones]) )