4 settembre 2010

Lista Formule Excel in Italiano/Inglese

Ho ordinato e formattato una lista di formule di Excel.
Potrebbe tornare utile quando si lavora su un Excel in lingua diversa.
In questo articolo, mi sono limitato a riportare solo quelle in italiano/inglese.
Nel caso in cui ve ne servano altre, non esitate a contattarmi.


ITALIANO___________INGLESE

ADESSO_________NOW
AMMORT_________DDB
AMMORT.ANNUO_________SYD
AMMORT.COST_________SLN
AMMORT.FISSO_________DB
AMMORT.VAR_________VDB
ANNO_________YEAR
ANNULLA.SPAZI_________TRIM
ARCCOS_________ACOS
ARCCOSH_________ACOSH
ARCSEN_________ASIN
ARCSENH_________ASINH
ARCTAN_________ATAN
ARCTAN.2_________ATAN2
ARCTANH_________ATANH
ARGOMENTO_________ARGUMENT
ARROTONDA_________ROUND
ARROTONDA.DIFETTO_________FLOOR
ARROTONDA.ECCESSO_________CEILING
ARROTONDA.PER.DIF_________ROUNDDOWN
ARROTONDA.PER.ECC_________ROUNDUP
ASC_________ASC
ASIMMETRIA_________SKEW
ASS_________ABS
CASUALE_________RAND
CERCA_________LOOKUP
CERCA.B_________SEARCHB
CERCA.ORIZZ_________HLOOKUP
CERCA.VERT_________VLOOKUP
CODICE_________CODE
CODICE.CARATT_________CHAR
COLONNE_________COLUMNS
COMBINAZIONE_________COMBIN
CONCATENA_________CONCATENATE
CONFIDENZA_________CONFIDENCE
CONFRONTA_________MATCH
CONTA.NUMERI_________COUNT
CONTA.SE_________COUNTIF
CONTA.VALORI_________COUNTA
CONTA.VUOTE_________COUNTBLANK
CONTROLLA.ORTOGRAFIA____SPELLING.CHECK
CORRELAZIONE_________CORREL
COS_________COS
COSH_________COSH
COVARIANZA_________COVAR
CRESCITA_________GROWTH
CRIT.BINOM_________CRITBINOM
CURTOSI_________KURT
DATA_________DATE
DATA.VALORE_________DATEVALUE
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
DESTRA_________RIGHT
DESTRA.B_________RIGHTB
DEV.Q_________DEVSQ
DEV.ST_________STDEV
DEV.ST.POP_________STDEVP
DISPARI_________ODD
DISTRIB.BETA_________BETADIST
DISTRIB.BINOM_________BINOMDIST
DISTRIB.BINOM.NEG_________NEGBINOMDIST
DISTRIB.CHI_________CHIDIST
DISTRIB.EXP_________EXPONDIST
DISTRIB.F_________FDIST
DISTRIB.GAMMA_________GAMMADIST
DISTRIB.IPERGEOM_________HYPGEOMDIST
DISTRIB.LOGNORM_________LOGNORMDIST
DISTRIB.NORM_________NORMDIST
DISTRIB.NORM.ST_________NORMSDIST
DISTRIB.T_________TDIST
E_________AND
ERRORE.TIPO_________ERROR.TYPE
FALSO_________FAUX
FATTORIALE_________FACT
FISHER_________FISHER
FISSO_________FIXED
GIORNO_________DAY
GIORNO.SETTIMANA_________WEEKDAY
GIORNO360_________DAYS360
GRADI_________DEGREES
GRANDE_________LARGE
IDENTICO_________EXACT
INDICE_________INDEX
INDIRETTO_________INDIRECT
INDIRIZZO_________ADDRESS
INT_________INT
INTERCETTA_________INTERCEPT
INTERESSI_________IPMT
INV.BETA_________BETAINV
INV.CHI_________CHIINV
INV.F_________FINV
INV.FISHER_________FISHERINV
INV.GAMMA_________GAMMAINV
INV.LOGNORM_________LOGINV
INV.NORM_________NORMINV
INV.NORM.ST_________NORMSINV
INV.T_________TINV
LN_________LN
LN.GAMMA_________GAMMALN
LOG_________LOG
LOG10_________LOG10
LUNGB_________LENB
LUNGHEZZA_________LEN
MAIUSC_________UPPER
MAIUSC.INIZ_________PROPER
MATR.INVERSA_________MINVERSE
MATR.PRODOTTO_________MMULT
MATR.SOMMA.PRODOTTO_________SUMPRODUCT
MATR.TRASPOSTA_________TRANSPOSE
MAX_________MAX
MEDIA_________AVERAGE
MEDIA.ARMONICA_________HARMEAN
MEDIA.B_________MIDB
MEDIA.DEV_________AVEDEV
MEDIA.GEOMETRICA_________GEOMEAN
MEDIA.TRONCATA_________TRIMMEAN
MEDIANA_________MEDIAN
MESE_________MONTH
MIN_________MIN
MINUSC_________LOWER
MINUTO_________MINUTE
MODA_________MODE
NON_________NOT
NON.DISP_________NA
NORMALIZZA_________STANDARDIZE
NUM_________N
NUM.RATE_________NPER
O_________OR
OGGI_________TODAY
ORA_________HOUR
ORARIO_________TIME
ORARIO.VALORE_________TIMEVALUE
P.RATA_________PPMT
PARI_________EVEN
PASSO_________STEP
PEARSON_________PEARSON
PENDENZA_________SLOPE
PERCENT.RANGO_________PERCENTRANK
PERCENTILE_________PERCENTILE
PERMUTAZIONE_________PERMUT
PI.GRECO_________PI
PICCOLO_________SMALL
POISSON_________POISSON
POTENZA_________POWER
PREVISIONE_________FORECAST
PROBABILITÀ_________PROB
PRODOTTO_________PRODUCT
QUARTILE_________QUARTILE
RADIANTI_________RADIANS
RADQ_________SQRT
RANGO_________RANK
RATA_________PMT
REGR.LIN_________LINEST
REGR.LOG_________LOGEST
RESTO_________MOD
RICERCA_________SEARCH
RIF.ASS_________ABSREF
RIF.COLONNA_________COLUMN
RIF.RIGA_________ROW
RIGHE_________ROWS
RIMPIAZZA_________REPLACE
RIPETI_________REPT
ROMANO_________ROMAN
RQ_________RSQ
SCARTO_________OFFSET
SCEGLI_________CHOOSE
SE_________IF
SECONDO_________SECOND
SEGNO_________SIGN
SEN_________SIN
SENH_________SINH
SERIE_________SERIES
SINISTRA_________LEFT
SINISTRAB_________LEFTB
SOMMA_________SUM
SOMMA.DIFF.Q_________SUMX2MY2
SOMMA.Q_________SUMSQ
SOMMA.Q.DIFF_________SUMXMY2
SOMMA.SE_________SUMIF
SOMMA.SOMMA.Q_________SUMX2PY2
SOSTITUISCI_________SUBSTITUTE
SOSTITUISCI.B_________REPLACEB
STRINGA.ESTRAI_________MID
SUBTOTALE_________SUBTOTAL
T_________T
TAN_________TAN
TANH_________TANH
TASSO_________RATE
TENDENZA_________TREND
TEST.CHI_________CHITEST
TEST.F_________FTEST
TEST.T_________TTEST
TEST.Z_________ZTEST
TESTO_________TEXT
TIR.COST_________IRR
TIR.VAR_________MIRR
TRONCA_________TRUNC
TROVA_________FIND
TROVA.B_________FINDB
VA_________PV
VAL.ERR_________ISERR
VAL.ERRORE_________ISERROR
VAL.FUT_________FV
VAL.NON.DISP_________ISNA
VAL.NON.TESTO_________ISNONTEXT
VAL.NUMERO_________ISNUMBER
VAL.RIF_________ISREF
VAL.TESTO_________ISTEXT
VAL.VUOTO_________ISBLANK
VALORE_________VALUE
VALORE.RIF_________DEREF
VALUTA_________DOLLAR
VAN_________NPV
VAR_________VAR
VAR.POP_________VARP
VERO_________VRAI
WEIBULL_________WEIBULL