Categories
Excel function translations Italian to English
A list of all Excel function translations from Italian to English. If you’re familiar with the Italian version of Excel and you find yourself working with the English version, this list will be of use to you, because Excel functions have different names in different languages.
List of all Excel functions
translated from Italian to English
Italian | English |
ADESSO | NOW |
AGGREGA | AGGREGATE |
AMMORT | DDB |
AMMORT.ANNUO | SYD |
AMMORT.COST | SLN |
AMMORT.DEGR | AMORDEGRC |
AMMORT.FISSO | DB |
AMMORT.PER | AMORLINC |
AMMORT.VAR | VDB |
ANNO | YEAR |
ANNULLA.SPAZI | TRIM |
ARCCOS | ACOS |
ARCCOSH | ACOSH |
ARCCOT | ACOT |
ARCCOTH | ACOTH |
ARCSEN | ASIN |
ARCSENH | ASINH |
ARCTAN | ATAN |
ARCTAN.2 | ATAN2 |
ARCTANH | ATANH |
AREE | AREAS |
ARROTONDA | ROUND |
ARROTONDA.DIFETTO | FLOOR |
ARROTONDA.DIFETTO.MAT | FLOOR.MATH |
ARROTONDA.DIFETTO.PRECISA | FLOOR.PRECISE |
ARROTONDA.ECCESSO | CEILING |
ARROTONDA.ECCESSO.MAT | CEILING.MATH |
ARROTONDA.ECCESSO.PRECISA | CEILING.PRECISE |
ARROTONDA.MULTIPLO | MROUND |
ARROTONDA.PER.DIF | ROUNDDOWN |
ARROTONDA.PER.ECC | ROUNDUP |
ASC | ASC |
ASIMMETRIA | SKEW |
ASIMMETRIA.P | SKEW.P |
ASS | ABS |
BAHTTESTO | BAHTTEXT |
BASE | BASE |
BESSEL.I | BESSELI |
BESSEL.J | BESSELJ |
BESSEL.K | BESSELK |
BESSEL.Y | BESSELY |
BINARIO.DECIMALE | BIN2DEC |
BINARIO.HEX | BIN2HEX |
BINARIO.OCT, | BIN2OCT |
BIT.SPOSTA.DX | BITRSHIFT |
BIT.SPOSTA.SX | BITLSHIFT |
BITAND | BITAND |
BITOR | BITOR |
BITXOR | BITXOR |
BOT.EQUIV | TBILLEQ |
BOT.PREZZO | TBILLPRICE |
BOT.REND | TBILLYIELD |
CAP.CUM | CUMPRINC |
CARATT.UNI | UNICHAR |
CASUALE | RAND |
CASUALE.TRA | RANDBETWEEN |
CELLA | CELL |
CERCA | LOOKUP |
CERCA.ORIZZ | HLOOKUP |
CERCA.VERT | VLOOKUP |
CERCA.X | XLOOKUP |
CODICE | CODE |
CODICE.CARATT | CHAR |
CODIFICA.URL | ENCODEURL |
COLLEG.IPERTESTUALE | HYPERLINK |
COLONNE | COLUMNS |
COMBINAZIONE | COMBIN |
COMBINAZIONE.VALORI | COMBINA |
COMP.ARGOMENTO | IMARGUMENT |
COMP.CONIUGATO | IMCONJUGATE |
COMP.COS | IMCOS |
COMP.COSH | IMCOSH |
COMP.COT | IMCOT |
COMP.CSC | IMCSC |
COMP.CSCH | IMCSCH |
COMP.DIFF | IMSUB |
COMP.DIV | IMDIV |
COMP.EXP | IMEXP |
COMP.IMMAGINARIO | IMAGINARY |
COMP.LN | IMLN |
COMP.LOG10 | IMLOG10 |
COMP.LOG2 | IMLOG2 |
COMP.MODULO | IMABS |
COMP.PARTE.REALE | IMREAL |
COMP.POTENZA | IMPOWER |
COMP.PRODOTTO | IMPRODUCT |
COMP.RADQ | IMSQRT |
COMP.SEC | IMSEC |
COMP.SECH | IMSECH |
COMP.SEN | IMSIN |
COMP.SENH | IMSINH |
COMP.SOMMA | IMSUM |
COMP.TAN | IMTAN |
COMPLESSO | COMPLEX |
CONCATENA | CONCATENATE |
CONFIDENZA | CONFIDENCE |
CONFIDENZA.NORM | CONFIDENCE.NORM |
CONFIDENZA.T | CONFIDENCE.T |
CONFRONTA | MATCH |
CONTA.NUMERI | COUNT |
CONTA.PIÙ.SE | COUNTIFS |
CONTA.SE | COUNTIF |
CONTA.SET.CUBO | CUBESETCOUNT |
CONTA.VALORI | COUNTA |
CONTA.VUOTE | COUNTBLANK |
CONVERTI | CONVERT |
CORRELAZIONE | CORREL |
COS | COS |
COSH | COSH |
COT | COT |
COTH | COTH |
COVARIANZA | COVAR |
COVARIANZA.C | COVARIANCE.S |
COVARIANZA.P | COVARIANCE.P |
CRESCITA | GROWTH |
CRIT.BINOM | CRITBINOM |
CSC | CSC |
CSCH | CSCH |
CURTOSI | KURT |
DATA | DATE |
DATA.CED.PREC | COUPPCD |
DATA.CED.SUCC | COUPNCD |
DATA.MESE | EDATE |
DATA.VALORE | DATEVALUE |
DATITEMPOREALE | RTD |
DB.CONTA.NUMERI | DCOUNT |
DB.CONTA.VALORI | DCOUNTA |
DB.DEV.ST | DSTDEV |
DB.DEV.ST.POP | DSTDEVP |
DB.MAX | DMAX |
DB.MEDIA | DAVERAGE |
DB.MIN | DMIN |
DB.PRODOTTO | DPRODUCT |
DB.SOMMA | DSUM |
DB.VALORI | DGET |
DB.VAR | DVAR |
DB.VAR.POP | DVARP |
DECIMALE | DECIMAL |
DECIMALE.BINARIO | DEC2BIN |
DECIMALE.HEX | DEC2HEX |
DECIMALE.OCT | DEC2OCT |
DELTA | DELTA |
DESTRA, DESTRA.B | RIGHT, RIGHTB |
DEV.Q | DEVSQ |
DEV.ST | STDEV |
DEV.ST.C | STDEV.S |
DEV.ST.P | STDEV.P |
DEV.ST.POP | STDEVP |
DEV.ST.POP.VALORI | STDEVPA |
DEV.ST.VALORI | STDEVA |
DISPARI | ODD |
DISTRIB.BETA | BETADIST |
DISTRIB.BETA.N | BETA.DIST |
DISTRIB.BINOM | BINOMDIST |
DISTRIB.BINOM.N | BINOM.DIST |
DISTRIB.BINOM.NEG | NEGBINOMDIST |
DISTRIB.BINOM.NEG.N | NEGBINOM.DIST |
DISTRIB.CHI | CHIDIST |
DISTRIB.CHIQUAD | CHISQ.DIST |
DISTRIB.CHIQUAD.DS | CHISQ.DIST.RT |
DISTRIB.EXP | EXPONDIST |
DISTRIB.EXP.N | EXPON.DIST |
DISTRIB.F | FDIST |
DISTRIB.F.DS | F.DIST.RT |
DISTRIB.GAMMA | GAMMADIST |
DISTRIB.GAMMA.N | GAMMA.DIST |
DISTRIB.IPERGEOM | HYPGEOMDIST |
DISTRIB.IPERGEOM.N | HYPGEOM.DIST |
DISTRIB.LOGNORM | LOGNORMDIST |
DISTRIB.LOGNORM.N | LOGNORM.DIST |
DISTRIB.NORM | NORMDIST |
DISTRIB.NORM.N | NORM.DIST |
DISTRIB.NORM.ST | NORMSDIST |
DISTRIB.NORM.ST.N | NORM.S.DIST |
DISTRIB.POISSON | POISSON.DIST |
DISTRIB.T | TDIST |
DISTRIB.T.2T | T.DIST.2T |
DISTRIB.T.DS | T.DIST.RT |
DISTRIB.T.N | T.DIST |
DISTRIB.WEIBULL | WEIBULL.DIST |
DISTRIBF | F.DIST |
DURATA | DURATION |
DURATA.M | MDURATION |
DURATA.P | PDURATION |
E | AND |
EFFETTIVO | EFFECT |
ERR.STD.YX | STEYX |
ERRORE.TIPO | ERROR.TYPE |
ESC.PERCENT.RANGO | PERCENTRANK.EXC |
ESC.PERCENTILE | PERCENTILE.EXC |
ESC.QUARTILE | QUARTILE.EXC |
EUROCONVERT | EUROCONVERT |
EXP | EXP |
FALSO | FALSE |
FATT.DOPPIO | FACTDOUBLE |
FATTORIALE | FACT |
FILTRO.XML | FILTERXML |
FINE.MESE | EOMONTH |
FISHER | FISHER |
FISSO | FIXED |
FOGLI | SHEETS |
FOGLIO | SHEET |
FRAZIONE.ANNO | YEARFRAC |
FREQUENZA | FREQUENCY |
FUNZ.ERRORE | ERF |
FUNZ.ERRORE.COMP | ERFC |
FUNZ.ERRORE.COMP.PRECISA | ERFC.PRECISE |
FUNZ.ERRORE.PRECISA | ERF.PRECISE |
FURIGANA | PHONETIC |
GAMMA | GAMMA |
GAUSS | GAUSS |
GIORNI | DAYS |
GIORNI.CED | COUPDAYS |
GIORNI.CED.INIZ.LIQ | COUPDAYBS |
GIORNI.CED.NUOVA | COUPDAYSNC |
GIORNI.LAVORATIVI.TOT | NETWORKDAYS |
GIORNI.LAVORATIVI.TOT.INTL | NETWORKDAYS.INTL |
GIORNO | DAY |
GIORNO.LAVORATIVO | WORKDAY |
GIORNO.LAVORATIVO.INTL | WORKDAY.INTL |
GIORNO.SETTIMANA | WEEKDAY |
GIORNO360 | DAYS360 |
GRADI | DEGREES |
GRANDE | LARGE |
HEX.BINARIO | HEX2BIN |
HEX.DECIMALE | HEX2DEC |
HEX.OCT | HEX2OCT |
IDENTICO | EXACT |
IDENTIFICATORE.REGISTRO | REGISTER.ID |
INC.PERCENT.RANGO | PERCENTRANK.INC |
INC.PERCENTILE | PERCENTILE.INC |
INC.QUARTILE | QUARTILE.INC |
INDICE | INDEX |
INDIRETTO | INDIRECT |
INDIRIZZO | ADDRESS |
INFO | INFO |
INFO.DATI.TAB.PIVOT | GETPIVOTDATA |
INT | INT |
INT.CUMUL | CUMIPMT |
INT.MATURATO.PER | ACCRINT |
INT.MATURATO.SCAD | ACCRINTM |
INTERCETTA | INTERCEPT |
INTERESSE.RATA | ISPMT |
INTERESSI | IPMT |
INTERVALLO.DISTRIB.BINOM.N | BINOM.DIST.RANGE |
INV.BETA | BETAINV |
INV.BETA.N | BETA.INV |
INV.BINOM | BINOM.INV |
INV.CHI | CHIINV |
INV.CHI.QUAD.DS | CHISQ.INV.RT |
INV.CHIQUAD | CHISQ.INV |
INV.F | FINV |
INV.F.DS | F.INV.RT |
INV.FISHER | FISHERINV |
INV.GAMMA | GAMMAINV |
INV.GAMMA.N | GAMMA.INV |
INV.LOGNORM | LOGINV |
INV.LOGNORM.N | LOGNORM.INV |
INV.NORM | NORMINV |
INV.NORM.N | NORM.INV |
INV.NORM.S | NORM.S.INV |
INV.NORM.ST | NORMSINV |
INV.T | TINV |
INV.T.2T | T.INV.2T |
INVF | F.INV |
INVT | T.INV |
ISO.ARROTONDA.ECCESSO | ISO.CEILING |
LIBERA | CLEAN |
LN | LN |
LN.GAMMA | GAMMALN |
LN.GAMMA.PRECISO | GAMMALN.PRECISE |
LOG | LOG |
LOG10 | LOG10 |
LUNGHEZZA, LUNGB | LEN, LENB |
MAIUSC | UPPER |
MAIUSC.INIZ | PROPER |
MATR.DETERM | MDETERM |
MATR.INVERSA | MINVERSE |
MATR.PRODOTTO | MMULT |
MATR.SOMMA.PRODOTTO | SUMPRODUCT |
MATR.TRASPOSTA | TRANSPOSE |
MATR.UNIT | MUNIT |
MAX | MAX |
MAX.VALORI | MAXA |
MCD | GCD |
MCM | LCM |
MEDIA | AVERAGE |
MEDIA.ARMONICA | HARMEAN |
MEDIA.DEV | AVEDEV |
MEDIA.GEOMETRICA | GEOMEAN |
MEDIA.PIÙ.SE | AVERAGEIFS |
MEDIA.SE | AVERAGEIF |
MEDIA.TRONCATA | TRIMMEAN |
MEDIA.VALORI | AVERAGEA |
MEDIANA | MEDIAN |
MEMBRO.CUBO | CUBEMEMBER |
MEMBRO.CUBO.CON.RANGO | CUBERANKEDMEMBER |
MEMBRO.KPI.CUBO | CUBEKPIMEMBER |
MESE | MONTH |
MIN | MIN |
MIN.VALORI | MINA |
MINUSC | LOWER |
MINUTO | MINUTE |
MODA | MODE |
MODA.MULT | MODE.MULT |
MODA.SNGL | MODE.SNGL |
MULTINOMIALE | MULTINOMIAL |
NOMINALE | NOMINAL |
NON | NOT |
NON.DISP | NA |
NORMALIZZA | STANDARDIZE |
NUM | N |
NUM.CED | COUPNUM |
NUM.RATE | NPER |
NUM.SETTIMANA | WEEKNUM |
NUM.SETTIMANA.ISO | ISOWEEKNUM |
NUMERO.ARABO | ARABIC |
NUMERO.VALORE | NUMBERVALUE |
O | OR |
OCT.BINARIO | OCT2BIN |
OCT.DECIMALE | OCT2DEC |
OCT.HEX | OCT2HEX |
OGGI | TODAY |
ORA | HOUR |
ORARIO | TIME |
ORARIO.VALORE | TIMEVALUE |
ORDINAMENTO.DBCS | DBCS |
P.RATA | PPMT |
PARI | EVEN |
PEARSON | PEARSON |
PENDENZA | SLOPE |
PERCENT.RANGO | PERCENTRANK |
PERCENTILE | PERCENTILE |
PERMUTAZIONE | PERMUT |
PERMUTAZIONE.VALORI | PERMUTATIONA |
PHI | PHI |
PI.GRECO | PI |
PICCOLO | SMALL |
POISSON | POISSON |
POTENZA | POWER |
PREVISIONE | FORECAST |
PREZZO | PRICE |
PREZZO.PRIMO.IRR | ODDFPRICE |
PREZZO.SCAD | PRICEMAT |
PREZZO.SCONT | PRICEDISC |
PREZZO.ULTIMO.IRR | ODDLPRICE |
PROBABILITÀ | PROB |
PRODOTTO | PRODUCT |
PROPRIETÀ.MEMBRO.CUBO | CUBEMEMBERPROPERTY |
QUARTILE | QUARTILE |
QUOZIENTE | QUOTIENT |
RADIANTI | RADIANS |
RADQ | SQRT |
RADQ.PI.GRECO | SQRTPI |
RANGO | RANK |
RANGO.MEDIA | RANK.AVG |
RANGO.UG | RANK.EQ |
RATA | PMT |
REGR.LIN | LINEST |
REGR.LOG | LOGEST |
REND | YIELD |
REND.PRIMO.IRR | ODDFYIELD |
REND.SCAD | YIELDMAT |
REND.TITOLI.SCONT | YIELDDISC |
REND.ULTIMO.IRR | ODDLYIELD |
RESTO | MOD |
RICERCA, CERCA.B | SEARCH, SEARCHB |
RICEV.SCAD | RECEIVED |
RICHIAMA | CALL |
RIF.COLONNA | COLUMN |
RIF.RIGA | ROW |
RIGHE | ROWS |
RIMPIAZZA, SOSTITUISCI.B | REPLACE, REPLACEB |
RIPETI | REPT |
RIT.INVEST.EFFETT | RRI |
ROMANO | ROMAN |
RQ | RSQ |
SCARTO | OFFSET |
SCEGLI | CHOOSE |
SE | IF |
SE.ERRORE | IFERROR |
SE.NON.DISP. | IFNA |
SEC | SEC |
SECH | SECH |
SECONDO | SECOND |
SEGNO | SIGN |
SEN | SIN |
SENH | SINH |
SERVIZIO.WEB | WEBSERVICE |
SET.CUBO | CUBESET |
SINISTRA, SINISTRAB | LEFT, LEFTB |
SOGLIA | GESTEP |
SOMMA | SUM |
SOMMA.DIFF.Q | SUMX2MY2 |
SOMMA.PIÙ.SE | SUMIFS |
SOMMA.Q | SUMSQ |
SOMMA.Q.DIFF | SUMXMY2 |
SOMMA.SE | SUMIF |
SOMMA.SERIE | SERIESSUM |
SOMMA.SOMMA.Q | SUMX2PY2 |
SOSTITUISCI | SUBSTITUTE |
SQL.REQUEST | SQL.REQUEST |
STRINGA.ESTRAI, MEDIA.B | MID, MIDB |
SUBTOTALE | SUBTOTAL |
T | T |
TAN | TAN |
TANH | TANH |
TASSO | RATE |
TASSO.INT | INTRATE |
TASSO.SCONTO | DISC |
TENDENZA | TREND |
TEST.CHI | CHITEST |
TEST.CHIQUAD | CHISQ.TEST |
TEST.F | FTEST |
TEST.T | TTEST |
TEST.Z | ZTEST |
TESTF | F.TEST |
TESTO | TEXT |
TESTO.FORMULA | FORMULATEXT |
TESTT | T.TEST |
TESTZ | Z.TEST |
TIPO | TYPE |
TIR.COST | IRR |
TIR.VAR | MIRR |
TIR.X | XIRR |
TRONCA | TRUNC |
TROVA, TROVA.B | FIND, FINDB |
UNICODE | UNICODE |
VA | PV |
VAL.DISPARI | ISODD |
VAL.ERR | ISERR |
VAL.ERRORE | ISERROR |
VAL.FORMULA | ISFORMULA |
VAL.FUT | FV |
VAL.FUT.CAPITALE | FVSCHEDULE |
VAL.LOGICO | ISLOGICAL |
VAL.NON.DISP | ISNA |
VAL.NON.TESTO | ISNONTEXT |
VAL.NUMERO | ISNUMBER |
VAL.PARI | ISEVEN |
VAL.RIF | ISREF |
VAL.TESTO | ISTEXT |
VAL.VUOTO | ISBLANK |
VALORE | VALUE |
VALORE.CUBO | CUBEVALUE |
VALUTA | DOLLAR |
VALUTA.DEC | DOLLARDE |
VALUTA.FRAZ | DOLLARFR |
VAN | NPV |
VAN.X | XNPV |
VAR | VAR |
VAR.C | VAR.S |
VAR.P | VAR.P |
VAR.POP | VARP |
VAR.POP.VALORI | VARPA |
VAR.VALORI | VARA |
VERO | TRUE |
WEIBULL | WEIBULL |
XOR | XOR |