These are the 140 most common functions in Excel with Catalan translations. This list is very useful if you are used to the English version of Excel, and you are working with a Catalan version that only accepts the Catalan function names in the formulas. Or the other way around!
Funcions d’Excel en català
Normally you would also have to replace all the commas in my example formulas with semi-colon.
| English | Catalan |
|---|---|
| ABS | ABS |
| ADDRESS | ADREÇA |
| AGGREGATE | VALOR.AFEGIT |
| AND | I |
| ARABIC | ARAB |
| AVERAGE | MITJANA |
| AVERAGEIF | MITJANA.SI |
| AVERAGEIFS | MITJANA.SI.CONJUNT |
| BAHTTEXT | TEXTBAHT |
| BIN2DEC | BIN.A.DEC |
| BIN2HEX | BIN.A.HEX |
| CEILING | MULTIPLE.SUPERIOR |
| CEILING.MATH | MULTIPLE.SUPERIOR.MAT |
| CELL | CEL |
| CHAR | CAR |
| CHOOSE | TRIA |
| CODE | CODI |
| COLUMN | COLUMNA |
| COLUMNS | COLUMNES |
| CONCAT | CONCAT |
| CONCATENATE | CONCATENA |
| CONVERT | CONVERT |
| COUNT | COMPT |
| COUNTA | COMPTAA |
| COUNTBLANK | COMPTA.BLANC |
| COUNTIF | COMPTA.SI |
| COUNTIFS | COMPTE.SI.CONJUNT |
| DATE | DATA |
| DATEVALUE | VALDATA |
| DAY | DIA |
| DAYS | DIES |
| DEC2BIN | DEC.A.BIN |
| DEC2HEX | DEC.A.HEX |
| EOMONTH | FIN.MES |
| EVEN | PARELL |
| EXACT | IGUAL |
| FACT | FACT |
| FILTERXML | FILTREXML |
| FIND | BUSCA |
| FLOOR | MULTIPLE.INFERIOR |
| FLOOR.MATH | MULTIPLE.INFERIOR.MAT |
| FORMULATEXT | TEXTFORMULA |
| FREQUENCY | FREQUENCIA |
| HEX2BIN | HEX.A.BIN |
| HEX2DEC | HEX.A.DEC |
| HLOOKUP | CONSULH |
| HYPERLINK | ENLLAÇ |
| IF | SI |
| IFERROR | SIERROR |
| IFS | SI.CONJUNT |
| INDEX | INDEX |
| INDIRECT | INDIRECTE |
| INFO | INFO |
| INT | ENTER |
| ISBLANK | ESBLANC |
| ISERROR | ESERROR |
| ISEVEN | ES.PAR |
| ISLOGICAL | ESLOGIC |
| ISNA | ESND |
| ISNONTEXT | ESNOTEXT |
| ISNUMBER | ESNUM |
| ISODD | ES.IMPAR |
| ISOWEEKNUM | NUM.DE.SEMANA.ISO |
| ISTEXT | ESTEXT |
| LARGE | MAJOR |
| LEFT | ESQUERRA |
| LEN | LLARG |
| LOOKUP | CONSULTA |
| LOWER | MINUSC |
| MATCH | COINCIDEIX |
| MAX | MAX |
| MAXIFS | MAX.SI.CONJUNT |
| MEDIAN | MEDIANA |
| MID | MIG |
| MIN | MIN |
| MINIFS | MIN.SI.CONJUNT |
| MOD | RESIDU |
| MODE | MODA |
| MONTH | MES |
| MROUND | REDOND.MULT |
| N | N |
| NA | ND |
| NETWORKDAYS | DIAS.LAB |
| NETWORKDAYS.INTL | DIES.LAB.INTL |
| NOT | NO |
| NOW | ACTUAL |
| ODD | SENAR |
| OFFSET | DESPLAÇAMENT |
| OR | O |
| PERCENTILE | PERCENTIL |
| PERCENTILE.EXC | PERCENTIL.EXC |
| PERCENTILE.INC | PERCENTIL.INC |
| PERCENTRANK | RANG.PERCENTIL |
| PERCENTRANK.EXC | RANG.PERCENTIL.EXC |
| PERCENTRANK.INC | RANG.PERCENTIL.INC |
| PI | PI |
| PMT | PAGAMENT |
| PROPER | NOMPROPI |
| QUARTILE | QUARTI |
| QUARTILE.EXC | QUARTI.EXC |
| QUARTILE.INC | QUARTI.INC |
| RAND | ALEAT |
| RANDBETWEEN | ALEATORIO.ENTRE |
| RANK | JERARQUIA |
| RANK.AVG | JERARQUIA.MITJANA |
| RANK.EQ | JERARQUIA.EQV |
| REPLACE | REEMPLAÇA |
| REPT | REPETEIX |
| RIGHT | DRETA |
| ROMAN | NUMERO.ROMA |
| ROUND | ARRODONEIX |
| ROUNDDOWN | ARRODONEIX.MENYS |
| ROUNDUP | ARRODONEIX.MES |
| ROW | FILA |
| ROWS | FILES |
| SEARCH | CERCAR |
| SMALL | MENOR |
| STDEV | DESVEST |
| STDEV.P | DESVEST.P |
| STDEV.S | DESVEST.M |
| SUBSTITUTE | SUBSTITUEIX |
| SUBTOTAL | SUBTOTAL |
| SUM | SUMA |
| SUMIF | SUMA.SI |
| SUMIFS | SUMA.SI.CONJUNT |
| SUMPRODUCT | SUMAPRODUCTE |
| SWITCH | CANVIA |
| TEXT | TEXT |
| TEXTJOIN | UNEIXCADENES |
| TODAY | AVUI |
| TRANSPOSE | TRANSPOSA |
| TRIM | RETALLA |
| UNICHAR | UNICAR |
| UNICODE | UNICODE |
| UPPER | MAJUSC |
| VLOOKUP | CONSULV |
| WEEKDAY | DIASETM |
| WEEKNUM | NUM.DE.SEMANA |
| YEAR | ANY |
| FALSE | FALS |
| TRUE | CERT |