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])
)