www.valterborsato.it

Excel functions list in Italian and English All Excel functions (included 2003 version) translated from English to Italian and from Italian to English.
Increasingly there is in condition to use Office versions with different language setting. With regard to the commands in the "Ribbon" it is not difficult to identify the various options. More complicated, instead, to recognize the name of functions, often not even detectable, with a simple command language translation.

Italiano Inglese
ADESSO NOW
AGGREGA AGGREGATE
AMBIENTE.INFO INFO
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
ARABO ARABIC
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
ASS ABS
ASSIMETRIA.P SKEW.P
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.B SEARCHB
CERCA.ORIZZ HLOOKUP
CERCA.VERT VLOOKUP
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.DIFF DATEDIF
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 RIGHT
DESTRA.B 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.CHI.QUAD CHISQ.DIST
DISTRIB.CHI.QUAD.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
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
INC.PERCENT.RANGO PERCENTRANK.INC
INC.PERCENTILE PERCENTILE.INC
INC.QUARTILE QUARTILE.INC
INDICE INDEX
INDIRETTO INDIRECT
INDIRIZZO ADDRESS
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 CHISQ.INV
INV.CHI.QUAD.DS CHISQ.INV.RT
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
JIS JIS
LIBERA CLEAN
LN LN
LN.GAMMA GAMMALN
LN.GAMMA.PRECISA GAMMALN.PRECISE
LOG LOG
LOG10 LOG10
LUNGB LENB
LUNGHEZZA LEN
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.B MIDB
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.VALORE NUMBERVALUE
O OR
OCT.BINARIO OCT2BIN
OCT.DECIMALE OCT2DEC
OCT.HEX OCT2HEX
OGGI TODAY
ORA HOUR
ORARIO TIME
ORARIO.VALORE TIMEVALUE
P.RATA PPMT
PARI EVEN
PEARSON PDURATION
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.EXC
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 SEARCH
RICEV.SCAD RECEIVED
RIF.COLONNA COLUMN
RIF.RIGA ROW
RIGHE ROWS
RIMPIAZZA REPLACE
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 LEFT
SINISTRA.B 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
SOSTITUISCI.B REPLACEB
STRINGA.ESTRAI MID
SUBTOTALE SUBTOTAL
T T
TAN TAN
TANH TANH
TASSO RATE
TASSO.INT INTRATE
TASSO.SCONTO DISC
TENDENZA TREND
TEST.CHI CHITEST
TEST.CHI.QUAD 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 FIND
TROVA.B FINDB
UNICODE UNICODE
USDOLLAR USDOLLAR
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

     

     

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

subject index.

Excel: logical Function IF: How to use the IF function