Origin of Excel Worksheet Function Names


Excel Skill Training Hall HOME(English)
Excel Skill Training Hall HOME(Japanese)
InGermany
  1. FINANCIAL FUNCTIONS
  2. MATH & TRIGONOMETRY FUNCTIONS
  3. STATISTICAL FUNCTIONS
  4. LOOKUP & REFERENCE FUNCTIONS
  5. DATABASE & LIST MANAGEMENT FUNCTIONS
  6. DATE & TIME FUNCTIONS
  7. TEXT FUNCTIONS
  8. LOGICAL FUNCTIONS
  9. INFORMATION FUNCTIONS
  10. DDE & EXTERNAL FUNCTIONS
  11. ENGINEERING FUNCTIONS

FINANCIAL FUNCTIONS

NAME ORIGIN DESCRIPTION
ACCRINT ACCRued INTerest Returns the accrued interest for a security that pays periodic interest
ACCRINTM ACCRued INTerest (at Maturity) Returns the accrued interest for a security that pays interest at maturity
AMORDEGRC AMORtissement DEGRessif Comptabilite Returns the depreciation for each accounting period
AMORLINC AMORtissement LINeaire Comptabilite Returns the depreciation for each accounting period
COUPDAYBS COUPon DAYs Biginning to Settlement Returns the number of days from the beginning of the coupon period to the settlement date
COUPDAYS COUPon DAYs containing Settlement Returns the number of days in the coupon period that contains the settlement date
COUPDAYSNC COUPon DAYs Settlement to Next Coupon Returns the number of days from the settlement date to the next coupon date
COUPNCD COUPon, Next Coupon Date Returns the next coupon date after the settlement date
COUPNUM NUMber of COUPons Returns the number of coupons payable between the settlement date and maturity date
COUPPCD COUPon, Previous Coupon Date Returns the previous coupon date before the settlement date
CUMIPMT CUMulative Interest Paid Returns the cumulative interest paid between two periods
CUMPRINC CUMulative PRINCipal Returns the cumulative principal paid on a loan between two periods
DB depreciation, fixed-Declining Balance method Returns the depreciation of an asset for a specified period using the fixed-declining balance method
DDB depreciation, Double-Declining Balance method Returns the depreciation of an asset for a spcified period using the double-declining balance method or some other method you specify
DISC DISCount rate Returns the discount rate for a security
DOLLARDE DOLLAR DEcimal Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
DOLLARFR DOLLAR FRaction Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
DURATION DURATION Returns the annual duration of a security with periodic interest payments
EFFECT EFFECTive annual yield Returns the effective annual interest rate
FV Future Value Returns the future value of an investment
FVSCHEDULE Future Value SCHEDULE Returns the future value of an initial principal after applying a series of compound interest rates
INTRATE INterest RATE Returns the interest rate for a fully invested security
IPMT Interest PayMenT Returns the interest payment for an investment for a given period
IRR Internal Rate of Return Returns the internal rate of return for a series of cash flows
MDURATION Modified DURATION Returns the Macauley modified duration for a security with an assumed par value of $100
MIRR Modified Internal Rate of Return Returns the internal rate of return where positive and negative cash flows are financed at different rates
NOMINAL NOMINAL yield Returns the annual nominal interest rate
NPER Number of PERiods Returns the number of periods for an investment
NPV Net Present Value Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
ODDFPRICE ODD First PRICE Returns the price per $100 face value of a security with an odd first period
ODDFYIELD ODD First YIELD Returns the yield of a security with an odd first period
ODDLPRICE ODD Last PRICE Returns the price per $100 face value of a security with an odd last period
ODDLYIELD ODD Last YIELD Returns the yield of a security with an odd last period
PMT PayMenT Returns the periodic payment for an annuity
PPMT Pincipal PayMenT Returns the payment on the principal for an investment for a given period
PRICE PRICE Returns the price per $100 face value of a security that pays periodic interest
PRICEDISC PRICE of DISCounted security Returns the price per $100 face value of a discounted security
PRICEMAT PRICE at MATurity Returns the price per $100 face value of a security that pays interest at maturity
PV Present Value Returns the present value of an investment
RATE RATE Returns the interest rate per period of an annuity
RECEIVED RECEIVED Returns the amount received at maturity for a fully invested security
SLN Straight LiNe depreciation Returns the straight-line depreciation of an asset for one period
SYD Sum of Year's Digit depreciation Returns the sum-of-years' digits depreciation of an asset for a specified period
TBILLEQ Treasury BILL's bond EQuvalent yield Returns the bond-equivalent yield for a Treasury bill
TBILLPRICE Treasury BILL's PRICE Returns the price per $100 face value for a Treasury bill
TBILLYIELD Treasury BILL's YIELD Returns the yield for a Treasury bill
VDB Variable Declining Balance Returns the depreciation of an asset for a specified or partial period using a declining balance method
XIRR Xtra Internal Rate of Rreturn Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
XNPV Xtra Net Present Value Returns the net present value for a schedule of cash flows that is not necessarily periodic
YIELD YIELD Returns the yield on a security that pays periodic interest
YIELDDISC DIScount YIELD Returns the annual yield for a discounted security. For example, a treasury bill
YIELDMAT YIELD at MATurity Returns the annual yield of a security that pays interest at maturity

MATH & TRIGONOMETRY FUNCTIONS

NAME ORIGIN DESCRIPTION
ABS ABSolute Returns the absolute value of a number
ACOS ArcCOSine Returns the arccosine of a number
ACOSH ArcCOSine, Hyperbolic Returns the inverse hyperbolic cosine of a number
ASIN ArcSINe Returns the arcsine of a number
ASINH ArcSINe, Hyperbolic Returns the inverse hyperbolic sine of a number
ATAN ArcTANgent Returns the arctangent of a number
ATAN2 ArcTangent from x- and y- coordinates Returns the arctangent from x- and y- coordinates
ATANH ArcTANgent, Hyperbolic Returns the inverse hyperbolic tangent of a number
CEILING CEILING Rounds a number to the nearest integer or to the nearest multiple of significance
COMBIN COMBINation Returns the number of combinations for a given number of objects
COS COSine Returns the cosine of a number
COSH COSine, Hyperbolic Returns the hyperbolic cosine of a number
COUNTIF COUNT IF Counts the number of non-blank cells within a range which meet the given criteria
DEGREES DEGREES Converts radians to degrees
EVEN EVEN Rounds a number up to the nearest even integer
EXP EXPonential Returns e raised to the power of a given number
FACT FACTorial Returns the factorial of a number
FACTDOUBLE FACTorial, DOUBLE Returns the double factorial of a number
FLOOR FLOOR Rounds a number down, toward zero
GCD Greatest Common Divisor Returns the greatest common divisor
INT INTeger Rounds a number down to the nearest integer
LCM Lowest Common Multiple Returns the least common multiple
LN Logarithm, Natural Returns the natural logarithm of a number
LOG LOGarithm Returns the logarithm of a number to a specified base
LOG10 base-10 Logarithm Returns the base-10 logarithm of a number
MDETERM Matrix DETERMinant Returns the matrix determinant of an array
MINVERSE Matrix INVERSE Returns the matrix inverse of an array
MMULT Matrix MULTiplication Returns the matrix product of two arrays
MOD MODulus Returns the remainder from division
MROUND ROUNDed to the desired Multiple Returns a number rounded to the desired multiple
MULTINOMIAL MULTI NOMIAL Returns the multinomial of a set of numbers
ODD ODD Rounds a number up to the nearest odd integer
PI Returns the value of Pi
POWER POWER Returns the result of a number raised to a power
PRODUCT PRODUCT Multiplies its arguments
QUOTIENT QUOTIENT Returns the integer portion of a division
RADIANS RADIANS Converts degrees to radians
RAND RANDom number Returns a random number between 0 and 1
RANDBETWEEN RANDom BETWEEN Returns a random number between the numbers you specify
ROMAN ROMAN numerals Converts an Arabic numeral to Roman, as text
ROUND ROUND Rounds a number to a specified number of digits
ROUNDDOWN ROUND DOWN Rounds a number down, toward zero
ROUNDUP ROUND UP Rounds a number up, away from zero
SERIESSUM SERIES SUM Returns the sum of a power series based on the formula
SIGN SIGN of a number Returns the sign of a number
SIN SINe Returns the sine of the given angle
SINH SINe, Hyperbolic Returns the hyperbolic sine of a number
SQRT SQuare RooT Returns a positive square root
SQRTPI SQuare RooT PI Returns the square root of (number * PI)
SUBTOTAL SUBTOTAL Returns a subtotal in a list or database
SUM SUM Adds its arguments
SUMIF SUM IF Adds the cells specified by a given criteria
SUMPRODUCT SUM PRODUCT Returns the sum of the products of corresponding array components
SUMSQ SUM SQuare Returns the sum of the squares of the arguments
SUMX2MY2 SUM X2 Minus Y2 Returns the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2 SUM X2 Plus Y2 Returns the sum of the sum of squares of corresponding values in two arrays
SUMXMY2 SUM (X Minus Y)2 Returns the sum of squares of differences of corresponding values in two arrays
TAN TANgent Returns the tangent of a number
TANH TANgent, Hyperbolic Returns the hyperbolic tangent of a number
TRUNC TRUNCate Truncates a number to an integer

STATISTICAL FUNCTIONS

NAME ORIGIN DESCRIPTION
AVEDEV AVErage DEViation Returns the average of the absolute deviations of data points from their mean
AVERAGE AVERAGE Returns the average of its arguments
AVERAGEA AVERAGE A Returns the average of its arguments, including numbers, text, and logical values
BETADIST BETA DISTribution Returns the cumulative beta probability density function
BETAINV BETA INVerse Returns the inverse of the cumulative beta probability density function
BINOMDIST BINOMial DISTribution Returns the individual term binomial distribution probability
CHIDIST CHI squared DISTribution Returns the one-tailed probability of the chi-squared distribution
CHIINV CHI squared INVerse Returns the inverse of the one-tailed probability of the chi-squared distribution
CHITEST CHI squared TEST Returns the test for independence
CONFIDENCE CONFIDENCE interval Returns the confidence interval for a population mean
CORREL CORRELation coefficient Returns the correlation coefficient between two data sets
COUNT COUNT Counts how many numbers are in the list of arguments
COUNTA COUNT A Counts how many values are in the list of arguments
COVAR COVARiance Returns covariance, the average of the products of paired deviations
CRITBINOM CRITeria of BINOMial Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
DEVSQ SQuare sum of DEViations Returns the sum of squares of deviations
EXPONDIST EXPONential DISTribution Returns the exponential distribution
FDIST F probability DISTribution Returns the F probability distribution
FINV F INVerse Returns the inverse of the F probability distribution
FISHER FISHER transformation Returns the Fisher transformation
FISHERINV FISHER INVerse Returns the inverse of the Fisher transformation
FORECAST FORECAST Returns a value along a linear trend
FREQUENCY FREQUENCY Returns a frequency distribution as a vertical array
FTEST F TEST Returns the result of an F-test
GAMMADIST GAMMA DISTribution Returns the gamma distribution
GAMMAINV GAMMA INVerse Returns the inverse of the gamma cumulative distribution
GAMMALN GAMMA Natural Logarism Returns the natural logarithm of the gamma function, G(x)
GEOMEAN GEOmetrical MEAN Returns the geometric mean
GROWTH GROWTH Returns values along an exponential trend
HARMEAN HARmonic MEAN Returns the harmonic mean
HYPGEOMDIST HYPer GEOMetical DISTribution Returns the hypergeometric distribution
INTERCEPT INTERCEPT Returns the intercept of the linear regression line
KURT KURTosis Returns the kurtosis of a data set
LARGE LARGE Returns the k-th largest value in a data set
LINEST LINe ESTimation Returns the parameters of a linear trend
LOGEST LOGarithm ESTimation Returns the parameters of an exponential trend
LOGINV LOG INVerse Returns the inverse of the lognormal distribution
LOGNORMDIST LOGNORMal DISTribution Returns the cumulative lognormal distribution
MAX MAXimum Returns the maximum value in a list of arguments
MAXA MAXimum A Returns the maximum value in a list of arguments, including numbers, text, and logical values
MEDIAN MEDIAN Returns the median of the given numbers
MIN MINimum Returns the minimum value in a list of arguments
MINA MINimum A Returns the smallest value in a list of arguments, including numbers, text, and logical values
MODE MODE Returns the most common value in a data set
NEGBINOMDIST NEGative BINOMial DISTribution Returns the negative binomial distribution
NORMDIST NORMal cumulative DISTribution Returns the normal cumulative distribution
NORMINV NORMal INVerse Returns the inverse of the normal cumulative distribution
NORMSDIST Standard NORMal cumulative DISTribution Returns the standard normal cumulative distribution
NORMSINV Standard NORMal INVerse Returns the inverse of the standard normal cumulative distribution
PEARSON PEARSON Returns the Pearson product moment correlation coefficient
PERCENTILE PERCENTILE Returns the k-th percentile of values in a range
PERCENTRANK PERCENTage RANK Returns the percentage rank of a value in a data set
PERMUT PERMUTations Returns the number of permutations for a given number of objects
POISSON POISSON distribution Returns the Poisson distribution
PROB PROBability Returns the probability that values in a range are between two limits
QUARTILE QUARTILE Returns the quartile of a data set
RANK RANK Returns the rank of a number in a list of numbers
RSQ SQuare of coRrelation coefficient Returns the square of the Pearson product moment correlatin coefficient
SKEW SKEWness Returns the skewness of a distribution
SLOPE SLOPE Returns the slope of the linear regression line
SMALL SMALL Returns the k-th smallest value in a data set
STANDARDIZE STANDARDIZE Returns a normalized value
STDEV STandard DEViation Estimates standard deviation based on a sample
STDEVA STDEV A Estimates standard deviation based on a sample, including numbers, text, and logical values
STDEVP STandard DEViation ,Population Calculates standard deviation based on the entire population
STDEVPA STDDEV P A Calculates standard deviation based on the entire population, including numbers, text, and logical values
STEYX STandard Error of the predicted Y-value for each X in the regression Returns the standard error of the predicted y-value for each x in the regression
TDIST T DISTribution Returns the Student's t-distribution
TINV T INVerse Returns the inverse of the Student's t-distribution
TREND TREND Returns values along a linear trend
TRIMMEAN TRIM MEAN Returns the mean of the interior of a data set
TTEST T TEST Returns the probability associated with a Student's t-Test
VAR VARiance Estimates variance based on a sample
VARA VARiance A Estimates variance based on a sample, including numbers, text, and logical values
VARP VARiance, Population Calculates variance based on the entire population
VARPA VARiance Population A Calculates variance based on the entire population, including numbers, text, and logical values
WEIBULL WEIBULL distribution Returns the Weibull distribution
ZTEST Z TEST Returns the two-tailed P-value of a z-test

LOOKUP & REFERENCE FUNCTIONS

NAME ORIGIN DESCRIPTION
ADDRESS ADDRESS Returns a reference as text to a single cell in a worksheet
AREAS AREAS Returns the number of areas in a reference
CHOOSE CHOOSE Chooses a value from a list of values
COLUMN COLUMN Returns the column number of a reference
COLUMNS COLUMNS Returns the number of columns in a reference
HLOOKUP Horizontal LOOKUP Looks in the top row of an array and returns the value of the indicated cell
HYPERLINK HYPERLINK Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
INDEX INDEX Uses an index to choose a value from a reference or array
INDIRECT INDIRECT Returns a reference indicated by a text value
LOOKUP LOOK UP Looks up values in a vector or array
MATCH MATCH Looks up values in a reference or array
OFFSET OFFSET Returns a reference offset from a given reference
ROW ROW Returns the row number of a reference
ROWS ROWS Returns the number of rows in a reference
TRANSPOSE TRANSPOSE Returns the transpose of an array
VLOOKUP Vertical LOOK UP Looks in the first column of an array and moves across the row to return the value of a cell

DATABASE & LIST MANAGEMENT FUNCTIONS

NAME ORIGIN DESCRIPTION
DAVERAGE Database AVERAGE Returns the average of selected database entries
DCOUNT Database COUNT Counts the cells that contain numbers in a database
DCOUNTA Database COUNT A Counts nonblank cells in a database
DGET Database GET Extracts from a database a single record that matches the specified criteria
DMAX Database MAXimum Returns the maximum value from selected database entries
DMIN Database MINimum Returns the minimum value from selected database entries
DPRODUCT Database PRODUCT Multiplies the values in a particular field of records that match the criteria in a database
DSTDEV Database Standard DEViation Estimates the standard deviation based on a sample of selected database entries
DSTDEVP Database Standard DEViation, Population Calculates the standard deviation based on the entire population of selected database entries
DSUM Database SUM Adds the numbers in the field column of records in the database that match the criteria
DVAR Database VARiance Estimates variance based on a sample from selected database entries
DVARP Database VARiance, Population Calculates variance based on the entire population of selected database entries
GETPIVOTDATA GET PIVOT DATA Returns data stored in a PivotTable

DATE & TIME FUNCTIONS

NAME ORIGIN DESCRIPTION
DATE DATE Returns the serial number of a particular date
DATEVALUE DATE DIFference Converts a date in the form of text to a serial number
DAY DAY Converts a serial number to a day of the month
DAYS360 DAYS based on a 360 day year Calculates the number of days between two dates based on a 360-day year
EDATE Expiration DATE Returns the serial number of the date that is the indicated number of months before or after the start date
EOMONTH End Of MONTH Returns the serial number of the last day of the month before or after a specified number of months
HOUR HOUR Converts a serial number to an hour
MINUTE MINUTE Converts a serial number to a minute
MONTH MONTH Converts a serial number to a month
NETWORKDAYS NET WORKDAYS Returns the number of whole workdays between two dates
NOW NOW Returns the serial number of the current date and time
SECOND SECOND Converts a serial number to a second
TIME TIME Returns the serial number of a particular time
TIMEVALUE TIME VALUE Converts a time in the form of text to a serial number
TODAY TODAY Returns the serial number of today's date
WEEKDAY WEEKDAY Converts a serial number to a day of the week
WORKDAY WORKDAY Returns the serial number of the date before or after a specified number of workdays
YEAR YEAR Converts a serial number to a year
YEARFRAC YEAR FRACtion Returns the year fraction representing the number of whole days between start_date and end_date

TEXT FUNCTIONS

NAME ORIGIN DESCRIPTION
CHAR CHARacter Returns the character specified by the code number
CLEAN CLEAN Removes all nonprintable characters from text
CODE CODE Returns a numeric code for the first character in a text string
CONCATENATE CONCATENATE Joins several text items into one text item
DOLLAR DOLLAR Converts a number to text, using currency format
EXACT EXACT Checks to see if two text values are identical
FIND FIND Finds one text value within another (case-sensitive)
FIXED FIXED Formats a number as text with a fixed number of decimals
LEFT LEFT Returns the leftmost characters from a text value
LEN LENgth Returns the number of characters in a text string
LOWER LOWER Converts text to lowercase
MID MIDdle Returns a specific number of characters from a text string starting at the position you specify
PROPER PROPER Capitalizes the first letter in each word of a text value
REPLACE REPLACE Replaces characters within text
REPT REPeaT Repeats text a given number of times
RIGHT RIGHT Returns the rightmost characters from a text value
SEARCH SEARCH Finds one text value within another (not case-sensitive)
SUBSTITUTE SUBSTITUTE Substitutes new text for old text in a text string
T Text Converts its arguments to text
TEXT TEXT Formats a number and converts it to text
TRIM TRIM Removes spaces from text
UPPER UPPER Converts text to uppercase
VALUE VALUE Converts a text argument to a number

LOGICAL FUNCTIONS

NAME ORIGIN DESCRIPTION
AND AND Returns TRUE if all its arguments are TRUE
FALSE FALSE Returns the logical value FALSE
IF IF Specifies a logical test to perform
NOT NOT Reverses the logic of its argument
OR OR Returns TRUE if any argument is TRUE
TRUE TRUE Returns the logical value TRUE

INFORMATION FUNCTIONS

NAME ORIGIN DESCRIPTION
CELL CELL Returns information about the formatting, location, or contents of a cell
COUNTBLANK COUNT BLANK cells Counts the number of blank cells within a range
ERROR.TYPE ERROR TYPE Returns a number corresponding to an error type
INFO INFOrmation Returns information about the current operating environment
ISBLANK IS BLANK Returns TRUE if the value is blank
ISERR IS ERRor except #n/a Returns TRUE if the value is any error value except #N/A
ISERROR IS ERROR Returns TRUE if the value is any error value
ISEVEN IS EVEN Returns TRUE if the number is even
ISLOGICAL IS LOGICAL Returns TRUE if the value is a logical value
ISNA IS NA Returns TRUE if the value is the #N/A error value
ISNONTEXT IS NONTEXT Returns TRUE if the value is not text
ISNUMBER IS NUMBER Returns TRUE if the value is a number
ISODD IS ODD Returns TRUE if the number is odd
ISREF IS REFerence Returns TRUE if the value is a reference
ISTEXT IS TEXT Returns TRUE if the value is text
N Number Returns a value converted to a number
NA Not Available Returns the error value #N/A
TYPE TYPE Returns a number indicating the data type of a value

DDE & EXTERNAL FUNCTIONS

NAME ORIGIN DESCRIPTION
CALL CALL Calls a procedure in a dynamic link library or code resource
REGISTER.ID REGISTER ID Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered
SQLREQUEST SQL REQUEST Connects with an external data source and runs a query from a worksheet, then returns the result as an array without the need for macro programming

ENGINEERING FUNCTIONS

NAME ORIGIN DESCRIPTION
BESSELI modified BESSEL function In(x) Returns the modified Bessel function In(x)
BESSELJ BESSEL function Jn(x) Returns the Bessel function Jn(x)
BESSELK modified BESSEL function Kn(x) Returns the modified Bessel function Kn(x)
BESSELY BESSEL function Yn(x) Returns the Bessel function Yn(x)
BIN2DEC BINary number to DECimal Converts a binary number to decimal
BIN2HEX BINary number to HEXadecimal Converts a binary number to hexadecimal
BIN2OCT Binary number to OCTal Converts a binary number to octal
COMPLEX COMPLEX number Converts real and imaginary coefficients into a complex number
CONVERT CONVERT Converts a number from one measurement system to another
DEC2BIN DECimal number to BINary Converts a decimal number to binary
DEC2HEX DECimal number to HEXadecimal Converts a decimal number to hexadecimal
DEC2OCT DECimal number to OCTal Converts a decimal number to octal
DELTA DELTA Tests whether two values are equal
ERF ERror Function Returns the error function
ERFC Complimentary ERror Function Returns the complementary error function
GESTEP Greater than or Equal to STEP Tests whether a number is greater than a threshold value
HEX2BIN HEXadecimal number to BINary Converts a hexadecimal number to binary
HEX2DEC HEXadecimal number to DECimal Converts a hexadecimal number to decimal
HEX2OCT HEXadecimal number to OCTal Converts a hexadecimal number to octal
IMABS IMaginary ABSolute Returns the absolute value (modulus) of a complex number
IMAGINARY IMAGINARY coefficeint Returns the imaginary coefficient of a complex number
IMARGUMENT IMaginary ARGUMENT Returns the argument theta, an angle expressed in radians
IMCONJUGATE IMaginary CONJUGATE Returns the complex conjugate of a complex number
IMCOS IMaginary COSine Returns the cosine of a complex number
IMDIV IMaginary DIVided quotient Returns the quotient of two complex numbers
IMEXP IMaginary EXPonential Returns the exponential of a complex number
IMLN IMaginary Logarithm Natural Returns the natural logarithm of a complex number
IMLOG10 IMaginary base-10 LOGarithm Returns the base-10 logarithm of a complex number
IMLOG2 IMaginary base-2 LOGarithm Returns the base-2 logarithm of a complex number
IMPOWER IMaginary POWER Returns a complex number raised to an integer power
IMPRODUCT IMaginary PRODUCT Returns the product of two complex numbers
IMREAL IMaginary REAL coefficient Returns the real coefficient of a complex number
IMSIN IMaginary SINe Returns the sine of a complex number
IMSQRT IMaginary Square RooT Returns the square root of a complex number
IMSUB IMaginary SUBtract Returns the difference of two complex numbers
IMSUM IMaginary SUM Returns the sum of complex numbers
OCT2BIN OCTal number to BINary Converts an octal number to binary
OCT2DEC OCTal number to DECimal Converts an octal number to decimal
OCT2HEX OCTal number to HEXadecimal Converts an octal number to hexadecimal
SQRTPI SQuare RooT PI Returns the square root of (number * PI)

Excel Skill Training Hall HOME (English version)@b@Excel Skill Training Hall HOME (Japanese version)@|@TOP