Formula translator / Hungarian

Excel functions in Hungarian and English

Excel-függvények magyarul és angolul

Excel in Hungarian has its own name for most functions: VLOOKUP is FKERES and IF is HA. Paste a formula to translate it either way, or look a function up in the list below.

An example

English: =IF(VLOOKUP(A2, Prices!A:C, 3, FALSE)>=1.5, "High", "Low")

Hungarian: =HA(FKERES(A2; Prices!A:C; 3; HAMIS)>=1,5; "High"; "Low")

In Hungarian, Excel usually separates arguments with a semicolon and writes decimals with a comma (1,5). Excel takes both from your computer's region settings.

All 465 functions in Hungarian and English

TRUE is IGAZ and FALSE is HAMIS.

EnglishHungarianWhat it does
ABSABSThe absolute value: the number without its sign.
ACCRINTIDŐSZAKI.KAMAT
ACCRINTMLEJÁRATI.KAMAT
ACOSARCCOSThe angle, in radians, whose cosine is the number.
ACOSHACOSHThe inverse hyperbolic cosine of a number.
ACOTARCCOTThe angle, in radians, whose cotangent is the number. The result is between 0 and π.
ACOTHARCCOTH
ADDRESSCÍMBuilds a cell address as text from a row number and a column number.
AGGREGATEÖSSZESÍTLike SUBTOTAL with more calculations, and it can ignore errors in the range.
AMORDEGRCÉRTÉKCSÖKK.TÉNYEZŐVEL
AMORLINCÉRTÉKCSÖKK
ANDÉSTRUE only if every condition is TRUE.
ARABICARABTurns Roman numerals into a number.
AREASTERÜLET
ARRAYTOTEXTTÖMB.SZÖVEGGÉAll the values of a range written out as one piece of text.
ASINARCSINThe angle, in radians, whose sine is the number. Wrap it in DEGREES() for degrees.
ASINHASINHThe inverse hyperbolic sine of a number.
ATANARCTANThe angle, in radians, whose tangent is the number.
ATAN2ARCTAN2The angle, in radians, from the x-axis to the point (x, y). Unlike ATAN it knows which quarter of the circle the point is in.
ATANHATANHThe inverse hyperbolic tangent of a number.
AVEDEVÁTL.ELTÉRÉSThe average distance of the values from their mean: a plain measure of how spread out they are.
AVERAGEÁTLAGThe arithmetic mean of the numbers.
AVERAGEAÁTLAGAThe average, counting text in a range as 0 and TRUE as 1.
AVERAGEIFÁTLAGHAAverages the cells that meet a condition.
AVERAGEIFSÁTLAGHATÖBBAverages the cells that meet every one of several conditions.
BASEALAPWrites a number in another base, such as binary (2) or hexadecimal (16), as text.
BESSELIBESSELI
BESSELJBESSELJ
BESSELKBESSELK
BESSELYBESSELY
BETA.DISTBÉTA.ELOSZLThe beta distribution, for shares and percentages that vary between two bounds.
BETA.INVBÉTA.INVERZThe value below which a given share of a beta distribution falls.
BETADISTBÉTA.ELOSZLÁSThe chance of x or less in a beta distribution. The older form of BETA.DIST.
BETAINVINVERZ.BÉTA
BIN2DECBIN.DECTurns a binary number into an ordinary one.
BIN2HEXBIN.HEX
BIN2OCTBIN.OKT
BINOM.DISTBINOM.ELOSZLThe chance of a number of successes in a set number of tries, each with the same chance.
BINOM.DIST.RANGEBINOM.ELOSZL.TARTThe chance that the number of successes in a set of tries lands between two counts.
BINOM.INVBINOM.INVERZThe smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for.
BINOMDISTBINOM.ELOSZLÁS
BITANDBIT.ÉSCompares two whole numbers bit by bit and keeps the bits that are set in both.
BITLSHIFTBIT.BAL.ELTOLMoves the bits of a whole number to the left, which doubles it for every bit moved.
BITORBIT.VAGYCompares two whole numbers bit by bit and keeps the bits that are set in either.
BITRSHIFTBIT.JOBB.ELTOLMoves the bits of a whole number to the right, which halves it for every bit moved and drops the remainder.
BITXORBIT.XVAGYCompares two whole numbers bit by bit and keeps the bits that are set in one but not the other.
CEILINGPLAFONRounds a number up to the nearest multiple (away from zero when both are negative).
CEILING.MATHPLAFON.MATRounds a number up to the nearest multiple; mode rounds negative numbers away from zero.
CEILING.PRECISEPLAFON.PONTOS
CELLCELLATells you something about a cell: its address, row, column, contents, number format or the type of value in it.
CHARKARAKTERThe character for a character code.
CHIDISTKHI.ELOSZLÁS
CHIINVINVERZ.KHI
CHISQ.DISTKHINÉGYZET.ELOSZLÁSThe chi-square distribution: the chance of a value of x or less, or the height of the curve at x.
CHISQ.DIST.RTKHINÉGYZET.ELOSZLÁS.JOBBThe right tail of the chi-square distribution: the chance of a value greater than x. This is the p-value of a chi-square statistic.
CHISQ.INVKHINÉGYZET.INVERZThe value below which a given share of the chi-square distribution falls.
CHISQ.INV.RTKHINÉGYZET.INVERZ.JOBBThe chi-square value with a given share of the distribution above it: the critical value of a chi-square test.
CHISQ.TESTKHINÉGYZET.PRÓBAThe chi-square test of independence: the chance of counts this far from the expected ones if nothing but chance were at work.
CHITESTKHI.PRÓBA
CHOOSEVÁLASZTPicks a value from a list by its position.
CHOOSECOLSOSZLOPVÁLASZTÁSReturns the columns you name from an array, in the order you name them.
CLEANTISZTÍTRemoves non-printable characters.
CODEKÓDThe character code of the first character.
COLUMNOSZLOPThe column number of a reference (A = 1).
COLUMNSOSZLOPOKHow many columns a range has.
COMBINKOMBINÁCIÓKHow many ways to choose a number of items from a group, when the order does not matter.
COMBINAKOMBINÁCIÓK.ISMThe number of ways to choose items when the same item may be chosen more than once and the order does not matter.
COMPLEXKOMPLEX
CONCATFŰZJoins text from several values or ranges.
CONCATENATEÖSSZEFŰZJoins several text values (older version of CONCAT).
CONFIDENCEMEGBÍZHATÓSÁG
CONFIDENCE.NORMMEGBÍZHATÓSÁG.NORMThe margin of error for an average: add and subtract it to get the confidence interval.
CONFIDENCE.TMEGBÍZHATÓSÁG.TThe margin of error of a sample mean, using Student's t-distribution. Add it to and subtract it from the mean for the confidence interval.
CONVERTKONVERTÁLÁSConverts a number from one unit of measurement to another: miles to kilometres, pounds to kilograms, Fahrenheit to Celsius.
CORRELKORRELThe correlation coefficient of two data sets: from −1 (opposite) through 0 (unrelated) to 1 (move together).
COSCOSThe cosine of an angle given in radians.
COSHCOSHThe hyperbolic cosine of a number.
COTCOTThe cotangent of an angle: 1 divided by its tangent.
COTHCOTH
COUNTDARABCounts cells that contain numbers.
COUNTADARAB2Counts cells that are not empty.
COUNTBLANKDARABÜRESCounts empty cells in a range.
COUNTIFDARABTELICounts the cells that meet a condition.
COUNTIFSDARABHATÖBBCounts the rows that meet every one of several conditions.
COUPDAYBSSZELVÉNYIDŐ.KEZDETTŐL
COUPDAYSSZELVÉNYIDŐ
COUPDAYSNCSZELVÉNYIDŐ.KIFIZETÉSTŐL
COUPNCDELSŐ.SZELVÉNYDÁTUM
COUPNUMSZELVÉNYSZÁM
COUPPCDUTOLSÓ.SZELVÉNYDÁTUM
COVARKOVAR
COVARIANCE.PKOVARIANCIA.SPopulation covariance: the average product of the deviations of each pair from their means.
COVARIANCE.SKOVARIANCIA.MSample covariance: like COVARIANCE.P, but divides by n − 1 for a sample.
CRITBINOMKRITBINOM
CSCCSCThe cosecant of an angle: 1 divided by its sine.
CSCHCSCH
CUBEKPIMEMBERKOCKA.FŐTELJMUT
CUBEMEMBERKOCKA.TAG
CUBEMEMBERPROPERTYKOCKA.TAG.TUL
CUBERANKEDMEMBERKOCKA.HALM.ELEM
CUBESETKOCKA.HALM
CUBESETCOUNTKOCKA.HALM.DB
CUBEVALUEKOCKA.ÉRTÉK
CUMIPMTÖSSZES.KAMATTotal interest paid between two payment numbers.
CUMPRINCÖSSZES.TŐKERÉSZTotal paid off the loan itself (not interest) between two payment numbers.
DATEDÁTUMBuilds a date from a year, month and day.
DATEDIFDÁTUMTÓLIGThe difference between two dates in years, months or days.
DATEVALUEDÁTUMÉRTÉKConverts a date written as text into a date serial number.
DAVERAGEAB.ÁTLAGThe average of a column of a table for the rows that meet conditions written in cells.
DAYNAPThe day of the month (1-31).
DAYSNAPOKThe number of days between two dates.
DAYS360NAP360Days between two dates in a year of twelve 30-day months, as some accounts count them.
DBKCS2Depreciation for one period, losing the same percentage of the remaining value each period.
DCOUNTAB.DARABCounts the numbers in a column of a table for the rows that meet conditions written in cells.
DCOUNTAAB.DARAB2Counts the cells that are not empty in a column of a table for the rows that meet conditions written in cells.
DDBKCSADepreciation for one period at double the straight-line rate (or another multiple).
DEC2BINDEC.BINWrites a whole number in binary.
DEC2HEXDEC.HEXWrites a whole number in hexadecimal.
DEC2OCTDEC.OKT
DECIMALTIZEDESTurns a number written in another base, as text, into an ordinary number.
DEGREESFOKTurns radians into degrees.
DELTADELTATests whether two numbers are equal: 1 when they are, 0 when they are not.
DEVSQSQThe sum of the squared distances of the values from their mean.
DGETAB.MEZŐThe one value in a column of a table from the single row that meets the conditions. Two matching rows are an error, which makes it a strict lookup.
DISCLESZÁM
DMAXAB.MAXThe largest number in a column of a table among the rows that meet conditions written in cells.
DMINAB.MINThe smallest number in a column of a table among the rows that meet conditions written in cells.
DOLLARFORINTA number as text in currency style: $1,234.57, with negatives in brackets.
DOLLARDEFORINT.DECTurns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal.
DOLLARFRFORINT.TÖRTTurns a decimal price into one written with a fraction, as bond prices are: 1.125 in sixteenths is 1.02.
DPRODUCTAB.SZORZATMultiplies the numbers in a column of a table for the rows that meet conditions written in cells.
DSTDEVAB.SZÓRÁSThe standard deviation of a column of a table for the matching rows, treating them as a sample.
DSTDEVPAB.SZÓRÁS2The standard deviation of a column of a table for the matching rows, treating them as the whole population.
DSUMAB.SZUMAdds up a column of a table for the rows that meet conditions written in cells.
DVARAB.VARThe variance of a column of a table for the matching rows, treating them as a sample.
DVARPAB.VAR2The variance of a column of a table for the matching rows, treating them as the whole population.
EDATEKALK.DÁTUMThe same day a number of months before or after a date.
EFFECTTÉNYLEGESThe yearly rate you really pay or earn, once interest is added several times a year.
ENCODEURLURL.KÓDOLText made safe to put in a web address: spaces become %20, and so on.
EOMONTHHÓNAP.UTOLSÓ.NAPThe last day of the month, a number of months away.
ERFHIBAFThe error function between two limits. With one limit it runs from 0.
ERF.PRECISEHIBAF.PONTOSThe error function from 0 to x.
ERFCHIBAF.KOMPLEMENTERThe complementary error function: 1 - ERF(x).
ERROR.TYPEHIBA.TÍPUSA number for the kind of error: 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A.
EVENPÁROSRounds away from zero to the next even integer.
EXACTAZONOSTRUE if two text values are exactly the same, including case.
EXPKITEVŐe raised to a power.
EXPON.DISTEXP.ELOSZLThe exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.
EXPONDISTEXP.ELOSZLÁS
F.DISTF.ELOSZLThe F-distribution: the chance of a ratio of two variances of x or less, or the height of the curve at x.
F.DIST.RTF.ELOSZLÁS.JOBBThe right tail of the F-distribution: the chance of a ratio greater than x. This is the p-value of an F statistic.
F.INVF.INVERZThe value below which a given share of the F-distribution falls.
F.INV.RTF.INVERZ.JOBBThe F value with a given share of the distribution above it: the critical value of an F-test.
F.TESTF.PRÓBThe F-test: the chance that two samples would have variances this different if their populations varied equally. Two-tailed.
FACTFAKTFactorial: 1 × 2 × … × n.
FACTDOUBLEFAKTDUPLAThe double factorial: the number times every second whole number below it (7 × 5 × 3 × 1).
FDISTF.ELOSZLÁS
FILTERSZŰRŐKeeps only the rows that meet a condition. The result spills.
FILTERXMLXMLSZŰRÉS
FINDSZÖVEG.TALÁLPosition of one text inside another (case-sensitive).
FINVINVERZ.F
FISHERFISHERThe Fisher transformation of a correlation, which makes it close to normally distributed so that it can be tested.
FISHERINVINVERZ.FISHERTurns a Fisher-transformed value back into a correlation.
FIXEDFIXA number as text, rounded to a set number of decimals, with or without commas.
FLOORPADLÓRounds a number down to the nearest multiple (toward zero when both are negative).
FLOOR.MATHPADLÓ.MATRounds a number down to the nearest multiple; mode rounds negative numbers toward zero.
FLOOR.PRECISEPADLÓ.PONTOS
FORECASTELŐREJELZÉSPredicts a y value for a new x from the best-fit straight line through known data.
FORMULATEXTKÉPLETSZÖVEGShows the formula in a cell as text.
FREQUENCYGYAKORISÁGCounts how many values fall into each bin, for a histogram. Spills one more count than there are bins: the last counts values above the top bin.
FTESTF.PRÓBA
FVJBÉThe future value of an investment with regular payments.
FVSCHEDULEKJÉWhat an amount grows to when the interest rate changes from period to period.
GAMMAGAMMAThe gamma function, which stretches the factorial to numbers that are not whole: GAMMA(n) is (n-1)!
GAMMA.DISTGAMMA.ELOSZLThe gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.
GAMMA.INVGAMMA.INVERZThe value below which a given share of a gamma distribution falls.
GAMMADISTGAMMA.ELOSZLÁS
GAMMAINVINVERZ.GAMMA
GAMMALNGAMMALNThe natural logarithm of the gamma function. It stays small where GAMMA itself would overflow.
GAMMALN.PRECISEGAMMALN.PONTOS
GAUSSGAUSSThe chance that a standard normal value falls between the mean and z standard deviations above it.
GCDLKOGreatest common divisor.
GEOMEANMÉRTANI.KÖZÉPThe geometric mean: the right average for growth rates.
GESTEPKÜSZÖBNÉL.NAGYOBBTests whether a number reaches a threshold: 1 when it is greater than or equal to the step, 0 when it is not.
GETPIVOTDATAKIMUTATÁSADATOT.VESZReads one value out of a PivotTable by naming it, so that the formula still finds it when the PivotTable grows or is sorted.
GROWTHNÖVValues on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills.
HARMEANHARM.KÖZÉPThe harmonic mean: the right average for rates such as speeds.
HEX2BINHEX.BIN
HEX2DECHEX.DECTurns a hexadecimal number into an ordinary one.
HEX2OCTHEX.OKT
HLOOKUPVKERESFinds a value in the first row of a table and returns a value from the same column.
HOURÓRAThe hour of a time (0-23).
HSTACKVÍZSZ.HALMOZÁSPlaces arrays side by side into one wider array.
HYPERLINKHIPERHIVATKOZÁSMakes a cell a link: to a web page, an email address, or another cell ("#Sheet2!A1"). Select the cell and click its link button, or Ctrl+click it, to follow the link.
HYPGEOM.DISTHIPGEOM.ELOSZLÁSThe hypergeometric distribution: the chance of a number of successes in a sample drawn without putting anything back.
HYPGEOMDISTHIPERGEOM.ELOSZLÁSThe chance of exactly a number of successes in a sample drawn without putting anything back. The older form of HYPGEOM.DIST.
IFHAReturns one value if a condition is TRUE and another if it is FALSE.
IFERRORHAHIBAReturns a fallback value if a formula results in an error.
IFNAHAHIÁNYZIKReturns a fallback value only for #N/A errors.
IFSHAELSŐIGAZChecks conditions in order and returns the value for the first TRUE one.
IMABSKÉPZ.ABSZ
IMAGINARYKÉPZETES
IMARGUMENTKÉPZ.ARGUMENT
IMCONJUGATEKÉPZ.KONJUGÁLT
IMCOSKÉPZ.COS
IMCOSHKÉPZ.COSH
IMCOTKÉPZ.COT
IMCSCKÉPZ.CSC
IMCSCHKÉPZ.CSCH
IMDIVKÉPZ.HÁNYAD
IMEXPKÉPZ.EXP
IMLNKÉPZ.LN
IMLOG10KÉPZ.LOG10
IMLOG2KÉPZ.LOG2
IMPOWERKÉPZ.HATV
IMPRODUCTKÉPZ.SZORZAT
IMREALKÉPZ.VALÓS
IMSECKÉPZ.SEC
IMSECHKÉPZ.SECH
IMSINKÉPZ.SIN
IMSINHKÉPZ.SINH
IMSQRTKÉPZ.GYÖK
IMSUBKÉPZ.KÜL
IMSUMKÉPZ.ÖSSZEG
IMTANKÉPZ.TAN
INDEXINDEXThe value at a given row and column of a range.
INDIRECTINDIREKTTurns text such as "B2" into a real reference to that cell or range.
INFOINFÓ
INTINTRounds down to the nearest whole number.
INTERCEPTMETSZWhere the best-fit straight line crosses the y axis: the predicted y when x is 0.
INTRATEKAMATRÁTA
IPMTRRÉSZLETThe interest part of one loan payment.
IRRBMRInternal rate of return for a series of cash flows.
ISBLANKÜRESTRUE if the cell is empty.
ISERRHIBA.ETRUE if the value is any error except #N/A.
ISERRORHIBÁSTRUE if the value is any error.
ISEVENPÁROSETRUE if the number is even.
ISFORMULAKÉPLETTRUE if the cell holds a formula.
ISLOGICALLOGIKAITRUE if the value is TRUE or FALSE.
ISNANINCSTRUE if the value is the #N/A error.
ISNONTEXTNEM.SZÖVEGTRUE if the value is not text.
ISNUMBERSZÁMTRUE if the value is a number (dates count too).
ISODDPÁRATLANETRUE if the number is odd.
ISOWEEKNUMISO.HÉT.SZÁMAThe ISO 8601 week number: weeks start on Monday, and week 1 contains the first Thursday of the year.
ISPMTLRÉSZLETKAMATThe interest paid in a period of a loan that is repaid in equal amounts of principal, so the interest falls every period.
ISREFHIVATKOZÁSTRUE if the value is a reference to a cell or range.
ISTEXTSZÖVEG.ETRUE if the value is text.
KURTCSÚCSOSSÁGKurtosis: how heavy the tails are compared with a normal distribution (0). Positive means more extreme values.
LARGENAGYThe k-th largest value (k = 1 is the maximum).
LCMLKTLeast common multiple.
LEFTBALThe first characters of a text value.
LENHOSSZThe number of characters in a text value.
LINESTLIN.ILLFits a straight line by least squares and returns its slope(s) and intercept, with the full regression statistics (standard errors, R², F, sums of squares) if you ask. Spills.
LNLNNatural logarithm.
LOGLOGLogarithm to a base (default 10).
LOG10LOG10Base-10 logarithm.
LOGESTLOG.ILLFits an exponential curve, y = b × m^x, and returns the growth factor m and the starting value b, with the regression statistics if you ask. Spills.
LOGINVINVERZ.LOG.ELOSZLÁS
LOGNORM.DISTLOGNORM.ELOSZLÁSThe lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes.
LOGNORM.INVLOGNORM.INVERZThe value below which a given share of a lognormal distribution falls.
LOGNORMDISTLOG.ELOSZLÁSThe chance of x or less in a lognormal distribution. The older form of LOGNORM.DIST.
LOOKUPKERESFinds a value in a sorted row or column and returns the value in the same place in another. XLOOKUP is the modern choice.
LOWERKISBETŰConverts text to lowercase.
MATCHHOL.VANThe position of a value in a row or column.
MAXMAXThe largest number.
MAXAMAXAThe largest value, counting text in a range as 0 and TRUE as 1.
MAXIFSMAXHAThe largest value among cells that meet conditions.
MDETERMMDETERMThe determinant of a square matrix.
MDURATIONMKAMATÉRZ
MEDIANMEDIÁNThe middle number of a sorted list.
MIDKÖZÉPCharacters from the middle of a text value.
MINMINThe smallest number.
MINAMIN2The smallest value, counting text in a range as 0 and TRUE as 1.
MINIFSMINHAThe smallest value among cells that meet conditions.
MINUTEPERCEKThe minute of a time (0-59).
MINVERSEINVERZ.MÁTRIXThe inverse of a square matrix.
MIRRMEGTÉRÜLÉSRate of return when money borrowed and money reinvested earn different rates.
MMULTMSZORZATMultiplies two matrices.
MODMARADÉKThe remainder after division.
MODEMÓDUSZThe most frequently occurring number.
MODE.MULTMÓDUSZ.TÖBBEvery value that is tied for most common, as a list.
MODE.SNGLMÓDUSZ.EGY
MONTHHÓNAPThe month of a date (1-12).
MROUNDTÖBBSZ.KEREKÍTRounds to the nearest multiple of a number.
MULTINOMIALSZORHÁNYFAKTThe number of ways to split a group into smaller groups of the given sizes: the factorial of the total, divided by the factorial of each size.
MUNITMMÁTRIXThe unit matrix of a given size: 1 down the diagonal and 0 everywhere else.
NSConverts a value to a number (text becomes 0).
NAHIÁNYZIKReturns the #N/A error on purpose.
NEGBINOM.DISTNEGBINOM.ELOSZLÁSThe negative binomial distribution: the chance of a number of failures before a given number of successes.
NEGBINOMDISTNEGBINOM.ELOSZLThe chance of exactly a number of failures before a given number of successes. The older form of NEGBINOM.DIST.
NETWORKDAYSÖSSZ.MUNKANAPWorking days (Monday–Friday) between two dates, inclusive.
NETWORKDAYS.INTLÖSSZ.MUNKANAP.INTLWorking days between two dates, inclusive, with the weekend on days you choose.
NOMINALNÉVLEGESThe quoted yearly rate behind an effective rate. The reverse of EFFECT.
NORM.DISTNORM.ELOSZLÁSThe normal distribution: the chance of a value at or below x, or the height of the bell curve at x.
NORM.INVNORM.INVERZThe value below which a given share of a normal distribution falls.
NORM.S.DISTNORM.S.ELOSZLÁSThe standard normal distribution (mean 0, standard deviation 1) at a z-score.
NORM.S.INVNORM.S.INVERZThe z-score below which a given share of the standard normal distribution falls.
NORMDISTNORM.ELOSZL
NORMINVINVERZ.NORM
NORMSDISTSTNORMELOSZLThe chance of a z-score or less in the standard normal distribution. The older form of NORM.S.DIST.
NORMSINVINVERZ.STNORM
NOTNEMFlips TRUE to FALSE and FALSE to TRUE.
NOWMOSTThe current date and time.
NPERPER.SZÁMHow many payment periods are needed to pay off a loan.
NPVNMÉNet present value of future cash flows at a discount rate.
NUMBERVALUESZÁMÉRTÉKTurns text into a number, whatever decimal and thousands marks it uses.
OCT2BINOKT.BIN
OCT2DECOKT.DEC
OCT2HEXOKT.HEX
ODDPÁRATLANRounds away from zero to the next odd integer.
ODDFPRICEELTÉRŐ.EÁR
ODDFYIELDELTÉRŐ.EHOZAM
ODDLPRICEELTÉRŐ.UÁR
ODDLYIELDELTÉRŐ.UHOZAM
OFFSETELTOLÁSA range a set number of rows and columns away from a starting cell, of any size.
ORVAGYTRUE if at least one condition is TRUE.
PDURATIONKAMATÉRZ.PERHow many periods an investment needs to reach a target at a steady rate.
PEARSONPEARSONThe Pearson correlation coefficient, the same as CORREL.
PERCENTILEPERCENTILISThe value below which a given percentage of the data falls.
PERCENTILE.EXCPERCENTILIS.KIZÁRThe value below which a percentage of the data falls, excluding 0% and 100%.
PERCENTILE.INCPERCENTILIS.TARTALMAZ
PERCENTRANKSZÁZALÉKRANG
PERCENTRANK.EXCSZÁZALÉKRANG.KIZÁRWhere a value stands in a list, between 0 and 1 without ever reaching either.
PERCENTRANK.INCSZÁZALÉKRANG.TARTALMAZWhere a value stands in a list, from 0 (the lowest) to 1 (the highest).
PERMUTVARIÁCIÓKHow many ways to pick a number of items from a group, when the order matters.
PERMUTATIONAVARIÁCIÓK.ISMThe number of ordered arrangements when the same item may be used more than once: number to the power of number_chosen.
PHIFIThe height of the standard normal bell curve at x.
PHONETICFONETIKUS
PIPIThe number π (3.14159…).
PMTRÉSZLETThe payment for a loan with constant payments and a constant interest rate.
POISSONPOISSON
POISSON.DISTPOISSON.ELOSZLÁSThe chance of a number of events in a period, given how many happen on average.
POWERHATVÁNYRaises a number to a power (same as ^).
PPMTPRÉSZLETThe principal (pay-down) part of one loan payment.
PRICEÁR
PRICEDISCÁR.LESZÁM
PRICEMATÁR.LEJÁRAT
PROBVALÓSZÍNŰSÉGAdds up the probabilities of the outcomes that fall between two limits.
PRODUCTSZORZATMultiplies all the numbers together.
PROPERTNÉVCapitalises The First Letter Of Each Word.
PVMÉThe present value: what a series of future payments is worth now.
QUARTILEKVARTILISA quartile of the data (0 = min, 2 = median, 4 = max).
QUARTILE.EXCKVARTILIS.KIZÁRA quartile of the data (1, 2 or 3), using the exclusive method.
QUARTILE.INCKVARTILIS.TARTALMAZ
QUOTIENTKVÓCIENSThe whole-number part of a division.
RADIANSRADIÁNTurns degrees into radians, which is what SIN, COS and TAN take.
RANDVÉLA random number between 0 and 1. Changes on every edit.
RANDARRAYVÉLETLENTÖMBFills an array with random numbers.
RANDBETWEENVÉLETLEN.KÖZÖTTA random whole number between two limits.
RANKSORSZÁMThe position of a number in a list (1 = largest by default).
RANK.AVGRANG.ÁTLThe position of a number in a list. Tied values share the average of their positions.
RATERÁTAThe interest rate per period of a loan or investment.
RECEIVEDKAPOTT
REPLACECSEREReplaces characters at a given position.
REPTSOKSZORRepeats text a number of times.
RIGHTJOBBThe last characters of a text value.
ROMANRÓMAIWrites a number in Roman numerals.
ROUNDKEREKÍTÉSRounds a number to a given number of digits.
ROUNDDOWNKEREK.LERounds a number towards zero.
ROUNDUPKEREK.FELRounds a number away from zero.
ROWSORThe row number of a reference (or of the current cell).
ROWSSOROKHow many rows a range has.
RRIMRThe steady growth rate per period that turns one amount into another (CAGR).
RSQRNÉGYZETR squared: the share of the variation in y that the best-fit line explains, from 0 to 1.
RTDVIA
SEARCHSZÖVEG.KERESPosition of one text inside another (not case-sensitive, allows wildcards).
SECSECThe secant of an angle: 1 divided by its cosine.
SECHSECH
SECONDMPERCThe second of a time (0-59).
SERIESSUMSORÖSSZEGThe sum of a power series: each coefficient times x raised to a power that grows by a fixed step.
SHEETLAPThe number of a sheet, counting the tabs from the left: 1 for the first.
SHEETSLAPOKHow many sheets the workbook has.
SIGNELŐJEL1 for positive numbers, -1 for negative, 0 for zero.
SINSINThe sine of an angle given in radians.
SINHSINHThe hyperbolic sine of a number.
SKEWFERDESÉGSkewness: how lopsided the data are. Positive means a longer tail of high values, negative a longer tail of low values.
SKEW.PFERDESÉG.PHow lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left.
SLNLCSAStraight-line depreciation: the same loss of value every year.
SLOPEMEREDEKSÉGThe slope of the straight line that best fits the data: how much y changes for each 1 added to x.
SMALLKICSIThe k-th smallest value (k = 1 is the minimum).
SORTSORBA.RENDEZSorts a range. The result spills.
SORTBYRENDEZÉS.ALAP.SZERINTSorts a range by the values in another range.
SQRTGYÖKSquare root.
SQRTPIGYÖKPIThe square root of a number multiplied by π.
STANDARDIZENORMALIZÁLÁSA z-score: how many standard deviations a value is above (or below) the mean.
STDEVSZÓRÁSStandard deviation of a sample.
STDEV.PSZÓR.SStandard deviation of an entire population.
STDEV.SSZÓR.M
STDEVASZÓRÁSAThe standard deviation of a sample, counting text and FALSE in a range as 0 and TRUE as 1. STDEV skips them.
STDEVPSZÓRÁSP
STDEVPASZÓRÁSPAThe standard deviation of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. STDEVP skips them.
STEYXSTHIBAYXThe standard error of the regression: the typical distance of a y value from the best-fit line.
SUBSTITUTEHELYETTEReplaces specific text with new text.
SUBTOTALRÉSZÖSSZEGTotals a range, leaving out rows that a filter hides and other subtotals inside it.
SUMSZUMAdds up numbers, cells and ranges.
SUMIFSZUMHAAdds the cells that meet one condition.
SUMIFSSZUMHATÖBBAdds the cells that meet every one of several conditions.
SUMPRODUCTSZORZATÖSSZEGMultiplies matching items in arrays, then adds the results.
SUMSQNÉGYZETÖSSZEGAdds the squares of the numbers.
SUMX2MY2SZUMX2BŐLY2Adds up the differences of the squares of matching values in two ranges.
SUMX2PY2SZUMX2MEGY2Adds up the sums of the squares of matching values in two ranges.
SUMXMY2SZUMXBŐLY2Adds up the squares of the differences of matching values in two ranges.
SWITCHÁTVÁLTCompares a value against a list and returns the matching result.
SYDÉSZÖSum-of-years’ digits depreciation: more in the early periods, less in the late ones.
TTReturns the value if it is text, otherwise empty text.
T.DISTT.ELOSZLStudent's t-distribution: the chance of a t of x or less, or the height of the curve at x.
T.DIST.2TT.ELOSZLÁS.2SZThe two-tailed t-distribution: the chance of a t further from 0 than x, on either side. This is the p-value of a two-sided t-test.
T.DIST.RTT.ELOSZLÁS.JOBBThe right tail of the t-distribution: the chance of a t greater than x.
T.INVT.INVERZThe t-value below which a given share of the t-distribution falls.
T.INV.2TT.INVERZ.2SZThe t-value with a given share of the distribution beyond it, counting both tails. This is the critical value of a two-sided test.
T.TESTT.PRÓBStudent's t-test: the chance that two samples would differ this much if they came from populations with the same mean.
TANTANThe tangent of an angle given in radians.
TANHTANHThe hyperbolic tangent of a number.
TBILLEQKJEGY.EGYENÉRT
TBILLPRICEKJEGY.ÁR
TBILLYIELDKJEGY.HOZAM
TDISTT.ELOSZLÁSThe tail of the t-distribution beyond x, on one side or both. The older form of T.DIST.RT and T.DIST.2T.
TEXTSZÖVEGFormats a number as text using a format code.
TEXTJOINSZÖVEGÖSSZEFŰZÉSJoins text with a separator between each item.
TEXTSPLITSZÖVEGFELOSZTÁSSplits text into separate cells at a delimiter. The result spills.
TIMEIDŐBuilds a time from hours, minutes and seconds.
TIMEVALUEIDŐÉRTÉKConverts a time written as text into a fraction of a day.
TINVINVERZ.T
TODAYMAToday's date. Updates automatically.
TRANSPOSETRANSZPONÁLÁSFlips rows into columns and columns into rows.
TRENDTRENDValues on the best-fit straight line (least squares): fitted values for the known data, or predictions for new x values. Spills.
TRIMKIMETSZRemoves extra spaces, leaving single spaces between words.
TRIMMEANRÉSZÁTLAGThe average with a share of the highest and lowest values left out.
TRUNCCSONKCuts off the decimal part of a number.
TTESTT.PRÓBA
TYPETÍPUSA number for the kind of value: 1 number, 2 text, 4 TRUE or FALSE, 16 error, 64 array.
UNICHARUNIKARAKTERThe character with a Unicode number: letters of any alphabet, symbols, emoji.
UNICODEUNICODEThe Unicode number of the first character of some text.
UNIQUEEGYEDIRemoves duplicates from a list. The result spills.
UPPERNAGYBETŰSConverts text to UPPERCASE.
VALUEÉRTÉKConverts text that looks like a number into a number.
VALUETOTEXTÉRTÉK.SZÖVEGGÉAny value as text. Text passes through unchanged, or in quotes in the strict format.
VARVARVariance of a sample.
VAR.PVAR.SVariance of an entire population.
VAR.SVAR.M
VARAVARAThe variance of a sample, counting text and FALSE in a range as 0 and TRUE as 1. VAR skips them.
VARPVARP
VARPAVARPAThe variance of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. VARP skips them.
VDBÉCSRIDepreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.
VLOOKUPFKERESFinds a value in the first column of a table and returns a value from the same row.
VSTACKFÜGG.HALMOZÁSStacks arrays on top of each other into one taller array.
WEBSERVICEWEBSZOLGÁLTATÁS
WEEKDAYHÉT.NAPJAThe day of the week as a number.
WEEKNUMHÉT.SZÁMAThe week number of the year.
WEIBULLWEIBULL
WEIBULL.DISTWEIBULL.ELOSZLÁSThe Weibull distribution, used for how long things last before they fail.
WORKDAYKALK.MUNKANAPThe date a number of working days before or after a date.
WORKDAY.INTLKALK.MUNKANAP.INTLThe date a number of working days before or after a date, with the weekend on days you choose.
XIRRXBMRThe yearly rate of return for cash flows that fall on any dates.
XLOOKUPXKERESSearches a range and returns the matching item from another range. The modern replacement for VLOOKUP.
XMATCHXHOL.VANThe position of a value in a list, with exact match by default.
XNPVXNJÉNet present value of cash flows that fall on any dates, not evenly spaced ones.
XORXVAGYTRUE if an odd number of conditions are TRUE.
YEARÉVThe year of a date.
YEARFRACTÖRTÉVThe fraction of a year between two dates, using a day-count basis.
YIELDHOZAM
YIELDDISCHOZAM.LESZÁM
YIELDMATHOZAM.LEJÁRAT
Z.TESTZ.PRÓBThe one-tailed z-test: the chance of a sample mean this far above a claimed population mean.
ZTESTZ.PRÓBA

How it works

A workbook is not tied to a language. Excel stores every formula the same way and shows it in the language of whoever opens the file, so a file made in Hungarian Excel works in English Excel without changes. The names only get in the way when a formula travels as text: in a tutorial, a forum answer, an email or a chat.

The translator changes four things: function names, the separator between arguments, the decimal point, and TRUE, FALSE and error values such as #N/A. Text in quotes, cell references and sheet names stay exactly as you wrote them. Every name was checked against two sources before it was added; where a name could not be confirmed, the translator leaves the English one and tells you.

Other languages