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 (,).