These are the 140 most common functions in Excel with Galician translations. This list is very useful if you are used to the English version of Excel, and you are working with a Galician version that only accepts the Galician function names in the formulas. Or the other way around!
Funcións de Excel en galego
Normally you would also have to replace all the commas in my example formulas with semi-colon.
| English | Galician |
|---|---|
| ABS | ABS |
| ADDRESS | ENDEREZO |
| AGGREGATE | AGREGAR |
| AND | E |
| ARABIC | NÚMÁRABES |
| AVERAGE | MEDIA |
| AVERAGEIF | MEDIASE |
| AVERAGEIFS | MEDIASECONXUNTO |
| BAHTTEXT | TEXTOBAHT |
| BIN2DEC | BINADEC |
| BIN2HEX | BINAHEX |
| CEILING | LÍMITESUPERIOR |
| CEILING.MATH | LÍMITESUPERIOR.MAT |
| CELL | CELA |
| CHAR | CARACT |
| CHOOSE | ESCOLLER |
| CODE | CÓDIGO |
| COLUMN | COLUMNA |
| COLUMNS | COLUMNAS |
| CONCAT | CONCAT |
| CONCATENATE | CONCATENAR |
| CONVERT | CONVERTER |
| COUNT | CONTAR |
| COUNTA | CONTARA |
| COUNTBLANK | CONTARENBRANCO |
| COUNTIF | CONTARSE |
| COUNTIFS | CONTARSECONXUNTO |
| DATE | DATA |
| DATEVALUE | VALORDATA |
| DAY | DÍA |
| DAYS | DÍAS |
| DEC2BIN | DECABIN |
| DEC2HEX | DECAHEX |
| EOMONTH | FINMES |
| EVEN | PAR |
| EXACT | EXACTO |
| FACT | FACT |
| FILTERXML | FILTRARXML |
| FIND | LOCALIZAR |
| FLOOR | PLANOINFERIOR |
| FLOOR.MATH | ARREDMÚLTINF.PRECISO |
| FORMULATEXT | TEXTOFÓRMULA |
| FREQUENCY | FRECUENCIA |
| HEX2BIN | HEXABIN |
| HEX2DEC | HEXADEC |
| HLOOKUP | BUSCARH |
| HYPERLINK | HIPERLIGAZÓN |
| IF | SE |
| IFERROR | SEERRO |
| IFS | SE.CONXUNTO |
| INDEX | ÍNDICE |
| INDIRECT | INDIRECTO |
| INFO | INFORMACIÓN |
| INT | ENT |
| ISBLANK | ENBRANCO |
| ISERROR | ÉERRO |
| ISEVEN | ÉPAR |
| ISLOGICAL | ÉLÓXICO |
| ISNA | ÉNONDISP |
| ISNONTEXT | ÉNONTEXTO |
| ISNUMBER | ÉNÚMERO |
| ISODD | ÉIMPAR |
| ISOWEEKNUM | NÚMSEMANAISO |
| ISTEXT | ÉTEXTO |
| LARGE | MAIOR |
| LEFT | ESQUERDA |
| LEN | LONX |
| LOOKUP | BUSCAR |
| LOWER | MINÚSCULA |
| MATCH | CORRESP |
| MAX | MÁX |
| MAXIFS | MAX.SE.CONXUNTO |
| MEDIAN | MEDIANA |
| MID | MEDIO |
| MIN | MÍN |
| MINIFS | MIN.SE.CONXUNTO |
| MOD | RESTO |
| MODE | MODO |
| MONTH | MES |
| MROUND | MARRED |
| N | N |
| NA | NONDISP |
| NETWORKDAYS | DÍASÚTILESTOTAIS |
| NETWORKDAYS.INTL | DÍASÚTILESTOTAIS.INTL |
| NOT | NON |
| NOW | AGORA |
| ODD | IMPAR |
| OFFSET | DESPRAZAMENTO |
| OR | OU |
| PERCENTILE | PERCENTIL |
| PERCENTILE.EXC | PERCENTIL.EXC |
| PERCENTILE.INC | PERCENTIL.INC |
| PERCENTRANK | RANGOPORCENTUAL |
| PERCENTRANK.EXC | RANGOPERCENTIL.EXC |
| PERCENTRANK.INC | RANGOPERCENTIL.INC |
| PI | PI |
| PMT | PGTO |
| PROPER | PRIMMAIÚSCULA |
| QUARTILE | CUARTIL |
| QUARTILE.EXC | CUARTIL.EXC |
| QUARTILE.INC | CUARTIL.INC |
| RAND | ALEATORIO |
| RANDBETWEEN | ALEATORIOENTRE |
| RANK | RANGO |
| RANK.AVG | RANGO.MEDIA |
| RANK.EQ | RANGO.EQ |
| REPLACE | SUBSTITUÍR |
| REPT | REPETIR |
| RIGHT | DEREITA |
| ROMAN | NÚMROMANOS |
| ROUND | ARREDONDAR |
| ROUNDDOWN | ARREDONDARCARAAABAIXO |
| ROUNDUP | ARREDONDARCARAAARRIBA |
| ROW | FILA |
| ROWS | FILAS |
| SEARCH | ACHAR |
| SMALL | MENOR |
| STDEV | DESVEST |
| STDEV.P | DESVEST.P |
| STDEV.S | DESVEST.M |
| SUBSTITUTE | CAMBIARTEXTO |
| SUBTOTAL | SUBTOTAL |
| SUM | SUMA |
| SUMIF | SUMARSE |
| SUMIFS | SUMARSECONXUNTO |
| SUMPRODUCT | SUMARPRODUTO |
| SWITCH | CAMBIAR |
| TEXT | TEXTO |
| TEXTJOIN | UNIRTEXTO |
| TODAY | HOXE |
| TRANSPOSE | TRASPOR |
| TRIM | RECORTAR |
| UNICHAR | UNICARACT |
| UNICODE | UNICODE |
| UPPER | MAIÚSCULA |
| VLOOKUP | BUSCARV |
| WEEKDAY | DÍASEMANA |
| WEEKNUM | SEMANACALENDARIO |
| YEAR | ANO |
| FALSE | FALSO |
| TRUE | VERDADEIRO |