Funzioni Excel in italiano
These are the most common Excel functions with Italian translations.
Normally you would also have to replace all the commas in my example formulas with semi-colon.
| 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 |
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 (,).