Funzioni Excel in italiano
These are the 140 most common functions in Excel with Italian translations. This list is very useful if you are used to the English version of Excel, and you are working with an Italian version that only accepts the Italian function names in the formulas. Or the other way around!
Normally you would also have to replace all the commas in my example formulas with semi-colon.
Do you need a complete list of all the function names in Italian in Excel? Scroll down to the bottom of this page to read more about Microsoft’s Functions Translator add-in.
| English | Italian |
|---|---|
| ABS | ASS |
| ADDRESS | INDIRIZZO |
| AGGREGATE | AGGREGA |
| AND | E |
| ARABIC | ARABO |
| AVERAGE | MEDIA |
| AVERAGEIF | MEDIA.SE |
| AVERAGEIFS | MEDIA.PIÙ.SE |
| BAHTTEXT | BAHTTESTO |
| BIN2DEC | BINARIO.DECIMALE |
| BIN2HEX | BINARIO.HEX |
| CEILING | ARROTONDA.ECCESSO |
| CEILING.MATH | ARROTONDA.ECCESSO.MAT |
| CELL | CELLA |
| CHAR | CODICE.CARATT |
| CHOOSE | SCEGLI |
| CODE | CODICE |
| COLUMN | RIF.COLONNA |
| COLUMNS | COLONNE |
| CONCAT | CONCAT |
| CONCATENATE | CONCATENA |
| CONVERT | CONVERTI |
| COUNT | CONTA.NUMERI |
| COUNTA | CONTA.VALORI |
| COUNTBLANK | CONTA.VUOTE |
| COUNTIF | CONTA.SE |
| COUNTIFS | CONTA.PIÙ.SE |
| DATE | DATA |
| DATEVALUE | DATA.VALORE |
| DAY | GIORNO |
| DAYS | GIORNI |
| DEC2BIN | DECIMALE.BINARIO |
| DEC2HEX | DECIMALE.HEX |
| EOMONTH | FINE.MESE |
| EVEN | PARI |
| EXACT | IDENTICO |
| FACT | FATTORIALE |
| FILTERXML | FILTRO.XML |
| FIND | TROVA |
| FLOOR | ARROTONDA.DIFETTO |
| FLOOR.MATH | ARROTONDA.DIFETTO.MAT |
| FORMULATEXT | TESTO.FORMULA |
| FREQUENCY | FREQUENZA |
| HEX2BIN | HEX.BINARIO |
| HEX2DEC | HEX.DECIMALE |
| HLOOKUP | CERCA.ORIZZ |
| HYPERLINK | COLLEG.IPERTESTUALE |
| IF | SE |
| IFERROR | SE.ERRORE |
| IFS | PIÙ.SE |
| INDEX | INDICE |
| INDIRECT | INDIRETTO |
| INFO | AMBIENTE.INFO |
| INT | INT |
| ISBLANK | VAL.VUOTO |
| ISERROR | VAL.ERRORE |
| ISEVEN | VAL.PARI |
| ISLOGICAL | VAL.LOGICO |
| ISNA | VAL.NON.DISP |
| ISNONTEXT | VAL.NON.TESTO |
| ISNUMBER | VAL.NUMERO |
| ISODD | VAL.DISPARI |
| ISOWEEKNUM | NUM.SETTIMANA.ISO |
| ISTEXT | VAL.TESTO |
| LARGE | GRANDE |
| LEFT | SINISTRA |
| LEN | LUNGHEZZA |
| LOOKUP | CERCA |
| LOWER | MINUSC |
| MATCH | CONFRONTA |
| MAX | MAX |
| MAXIFS | MAX.PIÙ.SE |
| MEDIAN | MEDIANA |
| MID | STRINGA.ESTRAI |
| MIN | MIN |
| MINIFS | MIN.PIÙ.SE |
| MOD | RESTO |
| MODE | MODA |
| MONTH | MESE |
| MROUND | ARROTONDA.MULTIPLO |
| N | NUM |
| NA | NON.DISP |
| NETWORKDAYS | GIORNI.LAVORATIVI.TOT |
| NETWORKDAYS.INTL | GIORNI.LAVORATIVI.TOT.INTL |
| NOT | NON |
| NOW | ADESSO |
| ODD | DISPARI |
| OFFSET | SCARTO |
| OR | O |
| PERCENTILE | PERCENTILE |
| PERCENTILE.EXC | ESC.PERCENTILE |
| PERCENTILE.INC | INC.PERCENTILE |
| PERCENTRANK | PERCENT.RANGO |
| PERCENTRANK.EXC | ESC.PERCENT.RANGO |
| PERCENTRANK.INC | INC.PERCENT.RANGO |
| PI | PI.GRECO |
| PMT | RATA |
| PROPER | MAIUSC.INIZ |
| QUARTILE | QUARTILE |
| QUARTILE.EXC | ESC.QUARTILE |
| QUARTILE.INC | INC.QUARTILE |
| RAND | CASUALE |
| RANDBETWEEN | CASUALE.TRA |
| RANK | RANGO |
| RANK.AVG | RANGO.MEDIA |
| RANK.EQ | RANGO.UG |
| REPLACE | RIMPIAZZA |
| REPT | RIPETI |
| RIGHT | DESTRA |
| ROMAN | ROMANO |
| ROUND | ARROTONDA |
| ROUNDDOWN | ARROTONDA.PER.DIF |
| ROUNDUP | ARROTONDA.PER.ECC |
| ROW | RIF.RIGA |
| ROWS | RIGHE |
| SEARCH | RICERCA |
| SMALL | PICCOLO |
| STDEV | DEV.ST |
| STDEV.P | DEV.ST.P |
| STDEV.S | DEV.ST.C |
| SUBSTITUTE | SOSTITUISCI |
| SUBTOTAL | SUBTOTALE |
| SUM | SOMMA |
| SUMIF | SOMMA.SE |
| SUMIFS | SOMMA.PIÙ.SE |
| SUMPRODUCT | MATR.SOMMA.PRODOTTO |
| SWITCH | SWITCH |
| TEXT | TESTO |
| TEXTJOIN | TESTO.UNISCI |
| TODAY | OGGI |
| TRANSPOSE | MATR.TRASPOSTA |
| TRIM | ANNULLA.SPAZI |
| UNICHAR | CARATT.UNI |
| UNICODE | UNICODE |
| UPPER | MAIUSC |
| VLOOKUP | CERCA.VERT |
| WEEKDAY | GIORNO.SETTIMANA |
| WEEKNUM | NUM.SETTIMANA |
| YEAR | ANNO |
| FALSE | FALSO |
| TRUE | VERO |
Does Excel have a translate function?
Yes, there is an add-in called the Functions Translator add-in that you can install in a few seconds:
Go to Insert > Get Add-ins to open the add-in dialog. Choose Productivity under Category, find the Functions Translator add-in and click on the Add button
Now you will find the Functions Translator on the Home tab to the right.
Use it to look up a functions name in a list (Reference):
Or use the Translator feature to translate a whole formula:
Hi guys, I am italian and I confirm, all of them are right.
Good job. It’s very helpful
grazie 😉
is it possible to use eng formulas in an italian version of excel ?
I don’t think so. I haven’t tested it in the newest versions of Excel, but you probably have to change the settings to English.
Yes, you can do in 2 ways, by using my addin (is in italian), you can download it here:
http://www.tuttoexcel.it/add-in-funzioni-di-tuttoexcel/
By using a Microsoft addin located here
https://support.office.com/en-us/article/excel-functions-translator-f262d0c0-991c-485b-89b6-32cc8d326889
I check carefully. All seems OK. Thank you and best regards. Marco – PowerExcel.it founder
how about the IFS? is it always the “se” in Italian?
Thanks for finally writing about >Excel Functions in Italian | Easy-Excel.com <Loved it!
How does the absolute value shortcut key work on the italian keyboard? Usually it is F4,
https://edu.gcfglobal.org/en/excel-tips/absolute-references-with-the-f4-key/1/
but it doesn’t seem to work on the italian keyboard? Any advice? Thanks!
Hi I seem to encounter some problems with ; and , in the Italian and U.K. versions. Any idea?
In some versions you have to use semicolon (;) to separate function arguments, and in others (UK, US?) you use comma (,).