(C) 2012 - 2017 by Mourad Louha · All rights reserved.

Vše

In the following an alphabetically sorted list of all Excel functions for the current version of Microsoft Excel as well as their translations in the selected language. Please note, that in earlier versions of Excel the translations may be different. A detailed list of the translations for each function from Microsoft Excel 2010 and above can be found in the linked article.

Překlady

VýrobekMicrosoft Excel 2016
KategorieVše
Zdrojový jazykCzech
Cílový jazyk
AEnglish
AAND
ABSABS
ACCRINTACCRINT
ACCRINTMACCRINTM
ACOTACOT
ACOTHACOTH
AGGREGATEAGGREGATE
AMORDEGRCAMORDEGRC
AMORLINCAMORLINC
ARABICARABIC
ARCCOSACOS
ARCCOSHACOSH
ARCSINASIN
ARCSINHASINH
ARCTGATAN
ARCTG2ATAN2
ARCTGHATANH
ASCASC
AVERAGEAAVERAGEA
AVERAGEIFAVERAGEIF
AVERAGEIFSAVERAGEIFS
BEnglish
BAHTTEXTBAHTTEXT
BASEBASE
BESSELIBESSELI
BESSELJBESSELJ
BESSELKBESSELK
BESSELYBESSELY
BETA.DISTBETA.DIST
BETA.INVBETA.INV
BETADISTBETADIST
BETAINVBETAINV
BIN2DECBIN2DEC
BIN2HEXBIN2HEX
BIN2OCTBIN2OCT
BINOM.DISTBINOM.DIST
BINOM.DIST.RANGEBINOM.DIST.RANGE
BINOM.INVBINOM.INV
BINOMDISTBINOMDIST
BITANDBITAND
BITLSHIFTBITLSHIFT
BITORBITOR
BITRSHIFTBITRSHIFT
BITXORBITXOR
BUDHODNOTAFV
ČEnglish
ČASTIME
ČASHODNTIMEVALUE
ČÁSTMID
CEnglish
CEILING.MATHCEILING.MATH
CEILING.PRECISECEILING.PRECISE
CELÁ.ČÁSTINT
ČEnglish
ČETNOSTIFREQUENCY
CEnglish
CHIDISTCHIDIST
CHIINVCHIINV
CHISQ.DISTCHISQ.DIST
CHISQ.DIST.RTCHISQ.DIST.RT
CHISQ.INVCHISQ.INV
CHISQ.INV.RTCHISQ.INV.RT
CHISQ.TESTCHISQ.TEST
CHITESTCHITEST
CHYBA.TYPERROR.TYPE
ČEnglish
ČISTÁ.SOUČHODNOTANPV
CEnglish
COMBINACOMBINA
COMPLEXCOMPLEX
CONCATCONCAT
CONCATENATECONCATENATE
CONFIDENCECONFIDENCE
CONFIDENCE.NORMCONFIDENCE.NORM
CONFIDENCE.TCONFIDENCE.T
CONVERTCONVERT
CORRELCORREL
COSCOS
COSHCOSH
COTCOT
COTHCOTH
COUNTBLANKCOUNTBLANK
COUNTIFCOUNTIF
COUNTIFSCOUNTIFS
COUPDAYBSCOUPDAYBS
COUPDAYSCOUPDAYS
COUPDAYSNCCOUPDAYSNC
COUPNCDCOUPNCD
COUPNUMCOUPNUM
COUPPCDCOUPPCD
COVARCOVAR
COVARIANCE.PCOVARIANCE.P
COVARIANCE.SCOVARIANCE.S
CRITBINOMCRITBINOM
CSCCSC
CSCHCSCH
CUBEKPIMEMBERCUBEKPIMEMBER
CUBEMEMBERCUBEMEMBER
CUBEMEMBERPROPERTYCUBEMEMBERPROPERTY
CUBERANKEDMEMBERCUBERANKEDMEMBER
CUBESETCUBESET
CUBESETCOUNTCUBESETCOUNT
CUBEVALUECUBEVALUE
CUMIPMTCUMIPMT
CUMPRINCCUMPRINC
DEnglish
DATEDIFDATEDIF
DATESTRINGDATESTRING
DATUMDATE
DATUMHODNDATEVALUE
DAYSDAYS
DBCSDBCS
DEC2BINDEC2BIN
DEC2HEXDEC2HEX
DEC2OCTDEC2OCT
DECIMALDECIMAL
DEGREESDEGREES
DÉLKALEN
DELTADELTA
DENDAY
DENTÝDNEWEEKDAY
DETERMINANTMDETERM
DEVSQDEVSQ
DISCDISC
DMAXDMAX
DMINDMIN
DNESTODAY
DOLLARDEDOLLARDE
DOLLARFRDOLLARFR
DOSADITSUBSTITUTE
DPOČETDCOUNT
DPOČET2DCOUNTA
DPRŮMĚRDAVERAGE
DSMODCHDSTDEVP
DSMODCH.VÝBĚRDSTDEV
DSOUČINDPRODUCT
DSUMADSUM
DURATIONDURATION
DVARDVARP
DVAR.VÝBĚRDVAR
DZÍSKATDGET
EEnglish
ECMA.CEILINGECMA.CEILING
EDATEEDATE
EFFECTEFFECT
ENCODEURLENCODEURL
EOMONTHEOMONTH
ERFERF
ERF.PRECISEERF.PRECISE
ERFCERFC
ERFC.PRECISEERFC.PRECISE
EXPEXP
EXPON.DISTEXPON.DIST
EXPONDISTEXPONDIST
FEnglish
F.DISTF.DIST
F.DIST.RTF.DIST.RT
F.INVF.INV
F.INV.RTF.INV.RT
F.TESTF.TEST
FACTDOUBLEFACTDOUBLE
FAKTORIÁLFACT
FDISTFDIST
FILTERXMLFILTERXML
FINDBFINDB
FINVFINV
FISHERFISHER
FISHERINVFISHERINV
FLOOR.MATHFLOOR.MATH
FLOOR.PRECISEFLOOR.PRECISE
FORECASTFORECAST
FORECAST.ETSFORECAST.ETS
FORECAST.ETS.CONFINTFORECAST.ETS.CONFINT
FORECAST.ETS.SEASONALITYFORECAST.ETS.SEASONALITY
FORECAST.ETS.STATFORECAST.ETS.STAT
FORECAST.LINEARFORECAST.LINEAR
FORMULATEXTFORMULATEXT
FTESTFTEST
FVSCHEDULEFVSCHEDULE
GEnglish
GAMMAGAMMA
GAMMA.DISTGAMMA.DIST
GAMMA.INVGAMMA.INV
GAMMADISTGAMMADIST
GAMMAINVGAMMAINV
GAMMALNGAMMALN
GAMMALN.PRECISEGAMMALN.PRECISE
GAUSSGAUSS
GCDGCD
GEOMEANGEOMEAN
GESTEPGESTEP
HEnglish
HARMEANHARMEAN
HEX2BINHEX2BIN
HEX2DECHEX2DEC
HEX2OCTHEX2OCT
HLEDATSEARCH
HODINAHOUR
HODNOTAVALUE
HODNOTA.NA.TEXTTEXT
HYPERTEXTOVÝ.ODKAZHYPERLINK
HYPGEOM.DISTHYPGEOM.DIST
HYPGEOMDISTHYPGEOMDIST
IEnglish
IFERRORIFERROR
IFNAIFNA
IFSIFS
IMABSIMABS
IMAGINARYIMAGINARY
IMARGUMENTIMARGUMENT
IMCONJUGATEIMCONJUGATE
IMCOSIMCOS
IMCOSHIMCOSH
IMCOTIMCOT
IMCSCIMCSC
IMCSCHIMCSCH
IMDIVIMDIV
IMEXPIMEXP
IMLNIMLN
IMLOG10IMLOG10
IMLOG2IMLOG2
IMPOWERIMPOWER
IMPRODUCTIMPRODUCT
IMREALIMREAL
IMSECIMSEC
IMSECHIMSECH
IMSINIMSIN
IMSINHIMSINH
IMSQRTIMSQRT
IMSUBIMSUB
IMSUMIMSUM
IMTANIMTAN
INDEXINDEX
INTERCEPTINTERCEPT
INTRATEINTRATE
INVERZEMINVERSE
ISEVENISEVEN
ISFORMULAISFORMULA
ISO.CEILINGISO.CEILING
ISODDISODD
ISOWEEKNUMISOWEEKNUM
ISPMTISPMT
ISTHAIDIGITISTHAIDIGIT
JEnglish
JE.CHYBAISERR
JE.CHYBHODNISERROR
JE.ČISLOISNUMBER
JE.LOGHODNISLOGICAL
JE.NEDEFISNA
JE.NETEXTISNONTEXT
JE.ODKAZISREF
JE.PRÁZDNÉISBLANK
JE.TEXTISTEXT
KEnglish
DOLLAR
KDYŽIF
KÓDCODE
KOMBINACECOMBIN
KURTKURT
LEnglish
LARGELARGE
LCMLCM
LEFTBLEFTB
LENBLENB
LINREGRESELINEST
LINTRENDTREND
LNLN
LOGLOG10
LOGINVLOGINV
LOGLINREGRESELOGEST
LOGLINTRENDGROWTH
LOGNORM.DISTLOGNORM.DIST
LOGNORM.INVLOGNORM.INV
LOGNORMDISTLOGNORMDIST
LOGZLOG
MEnglish
MALÁLOWER
MAXMAX
MAXAMAXA
MAXIFSMAXIFS
MDURATIONMDURATION
MEDIANMEDIAN
MĚSÍCMONTH
MIDBMIDB
MINMIN
MINAMINA
MINIFSMINIFS
MINUTAMINUTE
MÍRA.VÝNOSNOSTIIRR
MODMOD
MOD.MÍRA.VÝNOSNOSTIMIRR
MODEMODE
MODE.MULTMODE.MULT
MODE.SNGLMODE.SNGL
MROUNDMROUND
MULTINOMIALMULTINOMIAL
MUNITMUNIT
NEnglish
NN
NÁHČÍSLORAND
NAHRADITREPLACE
NAHRADITBREPLACEB
NAJÍTFIND
NENOT
NEBOOR
NEDEFNA
NEGBINOM.DISTNEGBINOM.DIST
NEGBINOMDISTNEGBINOMDIST
NEPRAVDAFALSE
NEPŘÍMÝ.ODKAZINDIRECT
NETWORKDAYSNETWORKDAYS
NETWORKDAYS.INTLNETWORKDAYS.INTL
NOMINALNOMINAL
NORM.DISTNORM.DIST
NORM.INVNORM.INV
NORM.S.DISTNORM.S.DIST
NORM.S.INVNORM.S.INV
NORMDISTNORMDIST
NORMINVNORMINV
NORMSDISTNORMSDIST
NORMSINVNORMSINV
NUMBERSTRINGNUMBERSTRING
NUMBERVALUENUMBERVALUE
NYNÍNOW
OEnglish
O.PROSTŘEDÍINFO
OCT2BINOCT2BIN
OCT2DECOCT2DEC
OCT2HEXOCT2HEX
ODDFPRICEODDFPRICE
ODDFYIELDODDFYIELD
ODDLPRICEODDLPRICE
ODDLYIELDODDLYIELD
ODKAZADDRESS
ODMOCNINASQRT
ODPIS.LINSLN
ODPIS.NELINSYD
ODPIS.ZA.INTVDB
ODPIS.ZRYCHDB
ODPIS.ZRYCH2DDB
OPAKOVATREPT
PEnglish
PDURATIONPDURATION
PEARSONPEARSON
PERCENTILPERCENTILE
PERCENTIL.EXCPERCENTILE.EXC
PERCENTIL.INCPERCENTILE.INC
PERCENTRANKPERCENTRANK
PERCENTRANK.EXCPERCENTRANK.EXC
PERCENTRANK.INCPERCENTRANK.INC
PERMUTACEPERMUT
PERMUTATIONAPERMUTATIONA
PHIPHI
PIPI
PLATBAPMT
PLATBA.ÚROKIPMT
PLATBA.ZÁKLADPPMT
POČETCOUNT
POČET.BLOKŮAREAS
POČET.OBDOBÍNPER
POČET2COUNTA
POISSONPOISSON
POISSON.DISTPOISSON.DIST
POLÍČKOCELL
POSUNOFFSET
POWERPOWER
POZVYHLEDATMATCH
PRAVDATRUE
PRICEPRICE
PRICEDISCPRICEDISC
PRICEMATPRICEMAT
PROBPROB
PROČISTITTRIM
PRŮMĚRAVERAGE
PRŮMODCHYLKAAVEDEV
QEnglish
QUARTILQUARTILE
QUARTIL.EXCQUARTILE.EXC
QUARTIL.INCQUARTILE.INC
QUOTIENTQUOTIENT
ŘEnglish
ŘÁDEKROW
REnglish
RADIANSRADIANS
ŘEnglish
ŘÁDKYROWS
REnglish
RANDBETWEENRANDBETWEEN
RANKRANK
RANK.AVGRANK.AVG
RANK.EQRANK.EQ
RECEIVEDRECEIVED
RIGHTBRIGHTB
RKQRSQ
ROKYEAR
ROK360DAYS360
ROMANROMAN
ROUNDBAHTDOWNROUNDBAHTDOWN
ROUNDBAHTUPROUNDBAHTUP
ROUNDDOWNROUNDDOWN
ROUNDUPROUNDUP
RRIRRI
RTDRTD
SEnglish
SEARCHBSEARCHB
SECSEC
SECHSECH
SEKUNDASECOND
SERIESSUMSERIESSUM
SHEETSHEET
SHEETSSHEETS
SIGNSIGN
SINSIN
SINHSINH
SKEWSKEW
SKEW.PSKEW.P
SLOPESLOPE
SLOUPCECOLUMNS
SLOUPECCOLUMN
SMALLSMALL
SMODCHSTDEVP
SMODCH.PSTDEV.P
SMODCH.VÝBĚRSTDEV
SMODCH.VÝBĚR.SSTDEV.S
SOUČHODNOTAPV
SOUČINPRODUCT
SOUČIN.MATICMMULT
SOUČIN.SKALÁRNÍSUMPRODUCT
SQRTPISQRTPI
STANDARDIZESTANDARDIZE
STDEVASTDEVA
STDEVPASTDEVPA
STEJNÉEXACT
STEYXSTEYX
SUBTOTALSUBTOTAL
SUMASUM
SUMA.ČTVERCŮSUMSQ
SUMIFSUMIF
SUMIFSSUMIFS
SUMX2MY2SUMX2MY2
SUMX2PY2SUMX2PY2
SUMXMY2SUMXMY2
SVYHLEDATVLOOKUP
SWITCHSWITCH
TEnglish
TT
T.DISTT.DIST
T.DIST.2TT.DIST.2T
T.DIST.RTT.DIST.RT
T.INVT.INV
T.INV.2TT.INV.2T
T.TESTT.TEST
TBILLEQTBILLEQ
TBILLPRICETBILLPRICE
TBILLYIELDTBILLYIELD
TDISTTDIST
TEXTJOINTEXTJOIN
TGTAN
TGHTANH
THAIDAYOFWEEKTHAIDAYOFWEEK
THAIDIGITTHAIDIGIT
THAIMONTHOFYEARTHAIMONTHOFYEAR
THAINUMSOUNDTHAINUMSOUND
THAINUMSTRINGTHAINUMSTRING
THAISTRINGLENGTHTHAISTRINGLENGTH
THAIYEARTHAIYEAR
TINVTINV
TRANSPOZICETRANSPOSE
TRIMMEANTRIMMEAN
TTESTTTEST
TYPTYPE
UEnglish
UNICHARUNICHAR
UNICODEUNICODE
ÚEnglish
ÚROKOVÁ.MÍRARATE
UEnglish
USDOLARUSDOLLAR
USEKNOUTTRUNC
VEnglish
VARVARP
VAR.PVAR.P
VAR.SVAR.S
VAR.VÝBĚRVAR
VARAVARA
VARPAVARPA
VELKÁUPPER
VELKÁ2PROPER
VVYHLEDATHLOOKUP
VYČISTITCLEAN
VYHLEDATLOOKUP
WEnglish
WEBSERVICEWEBSERVICE
WEEKNUMWEEKNUM
WEIBULLWEIBULL
WEIBULL.DISTWEIBULL.DIST
WORKDAYWORKDAY
WORKDAY.INTLWORKDAY.INTL
XEnglish
XIRRXIRR
XNPVXNPV
XORXOR
YEnglish
YEARFRACYEARFRAC
YIELDYIELD
YIELDDISCYIELDDISC
YIELDMATYIELDMAT
ZEnglish
Z.TESTZ.TEST
ZAOKR.DOLŮFLOOR
ZAOKR.NAHORUCEILING
ZAOKROUHLITROUND
ZAOKROUHLIT.NA.LICHÉODD
ZAOKROUHLIT.NA.SUDÉEVEN
ZAOKROUHLIT.NA.TEXTFIXED
ZÍSKATKONTDATAGETPIVOTDATA
ZLEVALEFT
ZNAKCHAR
ZPRAVARIGHT
ZTESTZTEST
ZVOLITCHOOSE
ZVUKOVÉPHONETIC

Machine translation

This text has been machine translated.

Missing translation

This text has not been translated yet.