Excel Functions in Italian

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.

EnglishItalian
ABSASS
ADDRESSINDIRIZZO
AGGREGATEAGGREGA
ANDE
ARABICARABO
AVERAGEMEDIA
AVERAGEIFMEDIA.SE
AVERAGEIFSMEDIA.PIÙ.SE
BAHTTEXTBAHTTESTO
BIN2DECBINARIO.DECIMALE
BIN2HEXBINARIO.HEX
CEILINGARROTONDA.ECCESSO
CEILING.MATHARROTONDA.ECCESSO.MAT
CELLCELLA
CHARCODICE.CARATT
CHOOSESCEGLI
CODECODICE
COLUMNRIF.COLONNA
COLUMNSCOLONNE
CONCATCONCAT
CONCATENATECONCATENA
CONVERTCONVERTI
COUNTCONTA.NUMERI
COUNTACONTA.VALORI
COUNTBLANKCONTA.VUOTE
COUNTIFCONTA.SE
COUNTIFSCONTA.PIÙ.SE
DATEDATA
DATEVALUEDATA.VALORE
DAYGIORNO
DAYSGIORNI
DEC2BINDECIMALE.BINARIO
DEC2HEXDECIMALE.HEX
EOMONTHFINE.MESE
EVENPARI
EXACTIDENTICO
FACTFATTORIALE
FILTERXMLFILTRO.XML
FINDTROVA
FLOORARROTONDA.DIFETTO
FLOOR.MATHARROTONDA.DIFETTO.MAT
FORMULATEXTTESTO.FORMULA
FREQUENCYFREQUENZA
HEX2BINHEX.BINARIO
HEX2DECHEX.DECIMALE
HLOOKUPCERCA.ORIZZ
HYPERLINKCOLLEG.IPERTESTUALE
IFSE
IFERRORSE.ERRORE
IFSPIÙ.SE
INDEXINDICE
INDIRECTINDIRETTO
INFOAMBIENTE.INFO
INTINT
ISBLANKVAL.VUOTO
ISERRORVAL.ERRORE
ISEVENVAL.PARI
ISLOGICALVAL.LOGICO
ISNAVAL.NON.DISP
ISNONTEXTVAL.NON.TESTO
ISNUMBERVAL.NUMERO
ISODDVAL.DISPARI
ISOWEEKNUMNUM.SETTIMANA.ISO
ISTEXTVAL.TESTO
LARGEGRANDE
LEFTSINISTRA
LENLUNGHEZZA
LOOKUPCERCA
LOWERMINUSC
MATCHCONFRONTA
MAXMAX
MAXIFSMAX.PIÙ.SE
MEDIANMEDIANA
MIDSTRINGA.ESTRAI
MINMIN
MINIFSMIN.PIÙ.SE
MODRESTO
MODEMODA
MONTHMESE
MROUNDARROTONDA.MULTIPLO
NNUM
NANON.DISP
NETWORKDAYSGIORNI.LAVORATIVI.TOT
NETWORKDAYS.INTLGIORNI.LAVORATIVI.TOT.INTL
NOTNON
NOWADESSO
ODDDISPARI
OFFSETSCARTO
ORO
PERCENTILEPERCENTILE
PERCENTILE.EXCESC.PERCENTILE
PERCENTILE.INCINC.PERCENTILE
PERCENTRANKPERCENT.RANGO
PERCENTRANK.EXCESC.PERCENT.RANGO
PERCENTRANK.INCINC.PERCENT.RANGO
PIPI.GRECO
PMTRATA
PROPERMAIUSC.INIZ
QUARTILEQUARTILE
QUARTILE.EXCESC.QUARTILE
QUARTILE.INCINC.QUARTILE
RANDCASUALE
RANDBETWEENCASUALE.TRA
RANKRANGO
RANK.AVGRANGO.MEDIA
RANK.EQRANGO.UG
REPLACERIMPIAZZA
REPTRIPETI
RIGHTDESTRA
ROMANROMANO
ROUNDARROTONDA
ROUNDDOWNARROTONDA.PER.DIF
ROUNDUPARROTONDA.PER.ECC
ROWRIF.RIGA
ROWSRIGHE
SEARCHRICERCA
SMALLPICCOLO
STDEVDEV.ST
STDEV.PDEV.ST.P
STDEV.SDEV.ST.C
SUBSTITUTESOSTITUISCI
SUBTOTALSUBTOTALE
SUMSOMMA
SUMIFSOMMA.SE
SUMIFSSOMMA.PIÙ.SE
SUMPRODUCTMATR.SOMMA.PRODOTTO
SWITCHSWITCH
TEXTTESTO
TEXTJOINTESTO.UNISCI
TODAYOGGI
TRANSPOSEMATR.TRASPOSTA
TRIMANNULLA.SPAZI
UNICHARCARATT.UNI
UNICODEUNICODE
UPPERMAIUSC
VLOOKUPCERCA.VERT
WEEKDAYGIORNO.SETTIMANA
WEEKNUMNUM.SETTIMANA
YEARANNO
FALSEFALSO
TRUEVERO

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

Click on picture to magnify

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:

10 thoughts on “Excel Functions in Italian

Leave a Reply to Tania Cancel reply

Your email address will not be published. Required fields are marked *


× 9 = seventy two