abs
Calculate the absolute value of a number
accrint
Calculate accrued interest for a security that pays periodic interest.
acos
Calculate the inverse cosine of a number.
acosh
Calculate the inverse hyperbolic cosine of a number.
acot
Calculate the principal value of the arccotangent of a number.
acoth
Calculate the inverse hyperbolic cotangent of a number.
address
Return the address of a cell using a row and column number.
aggregate
Calculate an aggregation.
amordegrc
Return accounting depreciation for a period.
amorlinc
Calculate depreciation for an accounting period.
arabic
Convert Roman numerals to Arabic numerals.
areas
Calculate the number of areas in a reference.
asc
Convert full-width characters to half-width characters.
asin
Calculate the inverse sine of a number.
asinh
Calculate the inverse hyperbolic sine for a number.
atan
Calculate the arctangent of a number.
atan2
Calculate the arctangent using x- and y-coordinates.
atanh
Calculate the inverse hyperbolic tangent of a number.
avedev
Calculate the sum of the squared deviations of a data set.
averagea
Calculate the average of a set of numbers and text.
averageif
Calculate the average of numbers in a range that meet a specific criteria.
averageifs
Calculate the average of cells that satisfy multiple criteria.
bahttext
Convert a number into Thai text and add the "Baht" suffix.
base
Convert numbers to other bases.
besseli
Compute the modified Bessel function.
besselj
Calculate the Bessel function.
besselk
Return the modified Bessel function.
bessely
Calculate the Bessel function.
beta.dist
Calculate the cumulative beta distribution.
beta.inv
Compute the inverse of the beta cumulative probability density function.
betadist
Calculate the cumulative beta probability density function.
betainv
Calculate the inverse of the cumulative beta probability density function.
bin2dec
Convert a binary number to decimal.
bitor
Return a decimal number representing the bitwise OR of two numbers.
bitrshift
Shift numbers by bits.
bitxor
Return a decimal number representing the bitwise XOR of two numbers.
bycol
Process data in an array or range in a "by column" fashion.
byrow
Apply a function to each row in an array.
calculate
Evaluate an expression.
ceiling
Round a number up to the nearest multiple specified.
char
Retrieve characters from numbers.
chidist
Calculate the one-tailed probability of the chi-squared distribution for a given Î³2 test.
chiinv
Return the appropriate x value based on the accuracy of CHIDIST.
chisq.dist
Return the chi-squared distribution.
chisq.dist.rt
Calculate the right-tailed probability for the chi-squared distribution.
chisq.inv
Return the inverse of the left-tailed probability of the chi-squared distribution.
chisq.inv.rt
Calculate the inverse of the right-tailed probability of a chi-square distribution.
chisq.test
Determine if an experiment verifies the hypothesized results.
chitest
Determine if a hypothesis is verified using an experiment.
choosecols
Return specific columns from an array.
chooserows
Return specific rows from an array or range.
clean
Remove non-printable characters from text.
code
Identify a numeric code for a character.
column
Return the column number for a reference.
columns
Get the count of columns in a given reference.
combin
Calculate combinations without repetition.
combina
Count combinations with repetitions allowed.
complex
Create complex numbers with real and imaginary coefficients.
concat
Combine strings of text values.
confidence
Calculate a range of values to estimate the population mean with a given confidence level.
confidence.norm
Calculate a confidence interval for a population mean using a normal distribution.
confidence.t
Return a confidence interval for a population mean.
convert
Convert units of measurement.
correl
The CORREL function calculates the correlation coefficient between two cell ranges to determine the relationship between two properties. It is used to measure if changes in one property will result in changes in the other.
cos
Calculate the cosine of an angle.
cosh
Calculate the hyperbolic cosine of a number.
countblank
Count blank cells.
countifs
Sums up the cells matching several criteria.
coupdaybs
Calculate the number of days from the start of the coupon period to the settlement date.
coupdays
Calculate the number of days in a coupon period.
coupdaysnc
Calculate the number of days between the settlement date and the next coupon date.
coupncd
Calculate the next coupon date after the settlement date.
coupnum
Calculate the number of coupons or interest payments payable between the settlement date and maturity date.
couppcd
Calculate the previous coupon date before the settlement date for a coupon bond.
covar
Covariance helps to measure the relationship between two data sets by calculating the average of the products of deviations for each data point pair. This can be used to analyse correlations between variables, such as whether greater education is linked to higher earnings. Covariance can be a useful tool for analysing relationships between different components of a dataset.
covariance.p
Calculate the relationship between two data sets by determining the covariance of the deviations for the data points.
covariance.s
Return the sample covariance.
csc
Calculate the cosecant of an angle in radians.
csch
Return the hyperbolic cosecant of an angle.
cumipmt
Calculate the cumulative interest paid on a loan.
datedif
Calculate the number of days, months, or years between two dates.
datepart
Return a part of a date.
datevalue
Convert text dates to valid Sourcetable dates.
daverage
Calculate the average from matching records.
day
Retrieve the day as a number from a date.
days
Calculate the number of days between dates.
days360
Calculate the number of days between two dates in a 360-day year.
db
Calculate depreciation of an asset.
dbcs
Convert half-width letters to full-width letters.
dcount
Count matching records in a database using criteria and a field.
dcounta
Count matching records in a database using criteria and an optional field.
ddb
Calculate depreciation of an asset.
dec2bin
Convert decimal numbers to binary.
dec2hex
Convert decimal numbers to hexadecimal numbers.
dec2oct
Convert decimal numbers to octal numbers.
decimal
Convert a text representation of a number into a decimal number.
degrees
Convert angles to degrees.
delta
Compare two numeric values.
devsq
Calculate the sum of squared deviations from the mean.
dget
Retrieve a single value from a record using criteria.
disc
Calculate the discount rate for a security.
dmax
Calculate the maximum value in a field from a set of records that match a criteria.
dmin
Calculate the minimum value in a field from a set of records that match specified criteria.
dollarde
Convert dollar prices entered with a special notation to decimal numbers.
dollarfr
Convert prices to a fractional notation.
dproduct
Calculate the product of matching records.
drop
Remove a portion of an array
dstdev
The DSTDEV function is a worksheet function used to calculate the standard deviation of a population using a sample of numbers in a column of a table.
dstdevp
Calculate the standard deviation of a population of data.
dsum
Calculate the sum of values from a set of records that match specified criteria.
duration
Calculate the Macauley duration for a $100 par value.
dvar
Calculate the population variance using a sample.
dvarp
Return the variance of a population.
edate
Calculate a date which is a specified number of months before or after a given date.
effect
Calculate an annual interest rate.
encodeurl
Encode a text string into a URL-safe format.
eomonth
Return the serial number of the last day of the month in a given year.
erf
Calculate the integral between lower_limit and upper_limit using the ERF function.
erf.precise
Return the error function.
erfc
Calculate the complementary ERF function.
erfc.precise
Return the complementary ERF function between x and infinity.
errortype
Return a number representing an error value.
euro
The EUROCONVERT function allows users to easily convert a number from one euro member currency to another, or to euros. Fixed conversion rates set by the EU are used for accuracy.
euroconvert
Convert European Union currencies.
even
Round numbers up to the next even integer.
exact
Compare strings of text.
exp
Calculate the value of e raised to the power of a number.
expand
Expand an array by adding rows and columns.
expon.dist
Calculate the exponential distribution.
expondist
Return the exponential distribution.
f.dist
Calculate the difference in diversity between two data sets.
f.dist.rt
Determine if two datasets have different degrees of diversity.
f.inv
Calculate the inverse of the F probability distribution.
f.inv.rt
Calculate the inverse of the right-tailed F probability distribution.
f.test
Determine if two samples have the same variances.
fact
Calculate the factorial of a number.
factdouble
Calculate the double factorial of a number.
fdist
Determine whether two data sets have different amounts of diversity.
findb
Find the starting position of text within a parent string in languages using the double-byte character set.
finv
Calculate the inverse of the F probability distribution.
fisher
Calculate hypothesis testing on the correlation coefficient.
fisherinv
Calculate the inverse of the Fisher transformation.
fixed
Format numbers as text with fixed decimals.
floor
Round numbers down to a multiple specified.
formulatext
Retrieve the formula in a cell as text.
ftest
Determine whether two samples have different variances.
fv
Calculate the future value of an investment.
fvschedule
Calculate the future value of a single sum using a schedule of interest rates.
gamma
Return the gamma function value.
gamma.dist
Calculate skewed variables using GAMMA.DIST.
gamma.inv
Calculate the inverse of a gamma distribution.
gammadist
Study variables with a skewed distribution.
gammainv
Study a variable whose distribution is skewed.
gammaln
Calculate the natural logarithm of the gamma function.
gammaln.precise
Calculate the natural logarithm of the gamma function with precision.
gauss
Calculate the probability of a standard normal population member falling between the mean and standard deviations.
gcd
Calculate the greatest common divisor of multiple integers.
geomean
Calculate the geometric mean.
gestep
Filter values using GESTEP.
getpivotdata
Retrieve data from a pivot table by name.
growth
Calculate predicted exponential growth.
harmean
Calculate the harmonic mean.
hex2bin
Convert a hexadecimal number to binary.
hex2dec
Convert a hexadecimal number to its decimal equivalent.
hex2oct
Convert a hexadecimal number to octal.
hlookup
Find values in a horizontal table.
hour
Extract the hour from a time.
hstack
Combine arrays horizontally into a single array.
hyperlink
Create a clickable link.
hypgeom.dist
Calculate the hypergeometric distribution.
hypgeomdist
Calculate the hypergeometric distribution.
ifna
Trap #N/A errors.
imabs
Calculate the absolute value of a complex number.
image
The IMAGE function allows users to insert images, spheres, and cylinders into cells in a worksheet. It works with various image formats and can be customized to specify alternate text and dimensions.
imaginary
Calculate the imaginary coefficient of a complex number.
imargument
Return the argument of a complex number.
imconjugate
Return the complex conjugate of a complex number.
imcos
Calculate the complex cosine of a complex number.
imcosh
Return the cosine of a complex number.
imcot
Calculate the cotangent of a complex number.
imcsc
Calculate the cosecant of a complex number.
imcsch
Calculate the hyperbolic cosecant of a complex number.
imdiv
Divide complex numbers.
imexp
Calculate the exponential of a complex number.
imln
Calculate the natural logarithm of a complex number.
imlog10
Calculate the complex common logarithm of a number.
imlog2
Calculate the base-2 logarithm of a complex number.
impower
Raise a complex number to a given power.
improduct
The IMPRODUCT function is used to multiply complex numbers by taking a set of complex numbers as arguments.
imreal
Calculate the real coefficient of a complex number.
imsec
Calculate the secant of a complex number.
imsech
Calculate the hyperbolic secant of a complex number.
imsin
Calculate the sine of a complex number.
imsinh
Calculate the hyperbolic sine of a complex number.
imsqrt
Calculate the square root of a complex number.
imsub
Calculate the difference between two complex numbers.
imsum
Calculate the sum of complex numbers.
imtan
Calculate the tangent of a complex number.
int
Round down a decimal number to the nearest integer.
intercept
Calculate the intercept of a regression line.
intrate
Calculate the annual effective interest rate for a security that is fully invested.
ipmt
Calculate interest in a given period.
isblank
Determine if a cell is empty.
iserr
Test for any error but #N/A.
iserror
Test for errors in Sourcetable.
iseven
Test if a value is even.
isformula
Test if a cell contains a formula.
islogical
Test if a value is logical.
isna
Test for the #N/A error.
isnontext
Test for a non-text value.
isnumber
Test if a cell contains a number.
isodd
Test whether a value is odd.
isomitted
Check if a LAMBDA has a missing argument.
isoweeknum
Calculate the ISO week number for a date.
ispmt
Calculate the interest paid during a specified period of an investment.
isref
Test if a cell contains a reference.
istext
Test if a cell contains a text value.
jis
Convert single byte characters into double byte characters in a specific encoding.
kurt
Calculate the kurtosis of a data set.
lambda
Create custom functions for use throughout a workbook.
large
Identify the nth largest value in an array.
lcm
Calculate the least common multiple of numbers.
leftb
Extract text from the left of a string.
lenb
Calculate the length of text.
let
Assign variables in a formula.
ln
Calculate the natural logarithm of a number.
log
Calculate the logarithm of a number.
log10
Calculate the base 10 logarithm of a number.
logest
Calculate an exponential curve using data.
loginv
Calculate the inverse of the lognormal cumulative distribution function.
lognorm.dist
Calculate the lognormal distribution.
lognorm.inv
Calculate the inverse of the lognormal cumulative distribution function.
lognormdist
Calculate data that has been logarithmically transformed and divided into a range of values.
lower
Convert text to lower case.
makearray
Create an array with calculated values.
map
Apply a custom function to an array.
maxa
Find the largest numeric value in a range.
maxifs
Find the maximum value in a range using criteria.
mdeterm
Compute the matrix determinant of an array.
mduration
Calculate the Macauley modified duration for a security with an assumed par value of $100.
midb
Return a specified number of characters from a text string starting at a specified position.
min
Find the smallest value in the data supplied.
mina
Find the smallest numeric value in a range of values.
minifs
Find the minimum value in a range using criteria.
minute
Return the minute from a given time.
minverse
Calculate the inverse matrix of an array.
mirr
Calculate the modified internal rate of return.
mmult
Perform matrix multiplication.
mode
Calculate the most frequently occurring number in a set of numbers.
mode.mult
Calculate the most frequently occurring numbers in a data set.
mode.sngl
Find the most frequently occurring number in a set of numbers.
month
Retrieve the month from a date.
mround
Round a number to the nearest multiple.
multinomial
Calculate the ratio of the factorial of a sum of values to the product of factorials.
munit
Return a unit matrix of a specified dimension.
n
Convert a value to a number.
na
Create an #N/A error.
negbinom.dist
Calculate the negative binomial distribution.
negbinomdist
Calculate the probability of an event occurring given that the event has a specific number of chances of occurring.
networkdays
Calculate the number of working days between two dates.
networkdays.intl
Calculate the number of working days between two dates.
nominal
Calculate the nominal interest rate.
norm.dist
Calculate values and areas for the normal probability density function and the normal cumulative distribution function.
norm.inv
Calculate the inverse of the normal cumulative distribution.
norm.s.dist
Calculate the standard normal CDF and PDF.
norm.s.inv
Calculate the inverse of the standard normal cumulative distribution.
normdist
Return values for the normal probability density function (PDF) and the normal cumulative distribution function (CDF).
norminv
Calculate the inverse of the normal cumulative distribution.
normsdist
Calculate the standard normal cumulative distribution.
normsinv
Calculate the value of z such that with a given probability p, a standard normal random variable is less than or equal to z.
not
Reverse a value.
nper
Calculate the number of periods for a loan or investment.
npv
Calculate the net present value of an investment.
oct2bin
Convert an octal number into a binary number.
oct2dec
Convert an octal number to a decimal number.
oct2hex
Convert an octal number to hexadecimal.
odd
Round up a number to the next odd integer.
oddfprice
Calculate the price per $100 face value for a security with an odd first period.
oddfyield
Calculate the yield of a security with an odd first period.
oddlprice
Calculate the price per $100 face value of a security with an odd last period.
oddlyield
Calculate the yield of a security with an odd last period.
pduration
Calculate the number of periods needed to reach a given value.
pearson
Calculate the Pearson product moment correlation coefficient.
percentile
Calculate the kth percentile for a set of data.
percentile.exc
Calculate the kth percentile.
percentile.inc
Calculate the kth percentile.
percentrank
Calculate the percentile rank of a value in a data set.
percentrank.exc
Calculate the relative ranking of a value in a data set as a percentage.
percentrank.inc
Calculate the relative rank of a value in a data set as a percentage.
permut
Calculate the number of permutations without repetitions.
permutationa
Calculate the number of permutations with repetitions.
phi
Calculate the density function for a standard normal distribution.
pi
Calculate the value of Ï€.
poisson
Calculate the Poisson distribution.
poisson.dist
Calculate the Poisson distribution.
power
Raise a number to a power.
ppmt
Calculate the principal portion of a loan payment.
price
Calculate the price per $100 face value of a security that pays periodic interest.
pricedisc
Calculate the price per $100 face value of a discounted security.
pricemat
Calculate the price per $100 face value of a security that pays interest at maturity.
prob
Calculate the probability of a range of values between two limits.
product
Multiply numbers given as arguments.
proper
Capitalize the first letter of each word in a text string.
quartile
Calculate the quartile in a data set.
quartile.exc
Calculate the quartile for a set of data.
quartile.inc
Calculate the quartile of a data set.
quotient
Calculate the quotient of a division.
radians
Convert degrees into radians.
randarray
Generate an array of random numbers.
randbetween
Generate a random integer between two numbers.
rank.avg
Rank a number against other numeric values.
rank.eq
Rank a number against other numeric values.
received
Calculate the amount received at maturity for a fully invested security.
reduce
Reduce an array.
removefilters
Clear the filters from a table.
replaceb
Replace text in a string using the number of bytes specified.
rept
Repeat specified text.
roman
Convert numbers to Roman numerals as text.
rounddown
Round down to a specified number of digits.
rri
Calculate an equivalent interest rate for growth.
rsq
Calculate the square of the Pearson product moment correlation coefficient.
scan
Return intermediate results from scanning an array.
searchb
Find where a substring is within another string.
sec
Calculate the secant of an angle.
sech
Calculate the hyperbolic secant of an angle.
second
Return the second component of a time as a number between 0-59.
sequence
Generate a list of numbers in an array.
seriessum
Calculate the sum of a power series.
sheet
Return the sheet number for a reference sheet.
sheets
Calculate the number of sheets in a reference.
sign
Calculate the sign of a number.
sin
Calculate the sine of an angle using radians.
sinh
Calculate the hyperbolic sine of a number.
skew
Calculate the skewness of a distribution.
skew.p
Calculate the skewness of a distribution.
sln
Calculate depreciation.
slope
Calculate the slope of a linear regression line.
sort
Organize a range or array.
sortby
Sort a range or array by column.
sqrt
Calculate the positive square root of a number.
sqrtpi
Calculate the square root of a number using pi.
standardize
Calculate a z-score using the mean and standard deviation.
stdev
Calculate the standard deviation for a sample.
stdev.p
Calculate the standard deviation for a data set.
stdev.s
Calculate the standard deviation for a data set.
stdeva
Calculate the standard deviation for a sample of data.
stdevp
Calculate the standard deviation for a population.
stdevpa
Calculate the standard deviation for a population.
steyx
Calculate the standard error of the predicted y-value for each x in a regression.
substitute
Replace text based on content.
sumproduct
Return the sum of products from multiplying arrays.
sumsq
Calculate the sum of the squares of the provided values.
sumx2my2
Calculate the sum of the squares of differences of corresponding values in two arrays.
sumx2py2
Calculate the sum of the sum of squares of corresponding values in two arrays.
sumxmy2
Calculate the sum of squares of differences between corresponding values in two arrays.
switch
Match multiple values with the SWITCH function.
syd
Calculate sum of years depreciation.
t
Filter text values only.
t.dist
Compute the student's left-tailed t-distribution.
t.dist.2t
Compute the two-tailed Student's t-distribution.
t.dist.rt
Calculate the right-tailed student's t-distribution.
t.inv
Calculate the left-tailed inverse of the Student's t-distribution.
t.inv.2t
Calculate the two-tailed inverse of the Student's t-distribution.
t.test
Determine if two samples come from the same two underlying populations with the same mean.
take
Retrieve a subset of an array.
tan
Calculate the tangent of an angle.
tanh
Calculate the hyperbolic tangent of a number.
tbilleq
Calculate the bond-equivalent yield for a Treasury bill.
tbillprice
Calculate the price per $100 face value for a Treasury bill.
tbillyield
Calculate the yield for a Treasury bill.
tdist
Compute the probability for the student t-distribution.
textafter
Extract text after a delimiter.
textbefore
Extract text before a delimiter.
textjoin
Combine text values using a delimiter.
textsplit
Split text using a delimiter.
time
Create a time with hours, minutes, and seconds.
timevalue
Convert a text string into a time.
tinv
Calculate the two-tailed inverse of the Student's t-distribution.
tocol
Return an array in a single column.
torow
Transform an array into a single column.
transpose
Flip the orientation of a range of cells.
trend
Fits polynomial curves using regression.
trimmean
Calculate the mean of a data set while excluding outliers.
true
Verify the logical value TRUE.
trunc
"Truncate a number to a specified precision."
ttest
Calculate the probability associated with the Student's T Test.
type
Determine the type of value in a cell.
unichar
Return the Unicode character corresponding to a given number.
unicode
Retrieve the number from a Unicode character.
unique
The UNIQUE function returns a list of unique values from a list or range, ensuring that all names are different. It is an effective way to separate and manage data.
upper
Convert text to uppercase.
value
Convert text to a number.
var
Calculate the variation of a sample of data.
var.p
Calculate the variance of a population.
var.s
Calculate the variance of a sample of data.
vara
Calculate the variation in a sample of data.
varp
Calculate the variance of a population.
varpa
Calculate the variance of a population.
vdb
Calculate depreciation for an asset.
vstack
Combine arrays vertically.
webservice
Retrieve data from a web service.
weeknum
Determine the week number for a date.
weibull
Calculate the Weibull distribution.
weibull.dist
Calculate the Weibull distribution.
workday
Calculate a date n working days in the future or past.
workday.intl
Calculate the nearest working day in the future or past using an offset value.
wrapcols
Wrap an array into columns.
xirr
Calculate the internal rate of return for an irregular cash flow.
xlookup
Find values in a range or array using XLOOKUP.
xmatch
Find where an item is in a list or table.
xnpv
Calculate the net present value of an investment using a discount rate and irregular cash flows.
xor
Perform exclusive OR.
year
Retrieve the year from a date.
yearfrac
Calculate the fraction of a year between two dates.
yield
Calculate the periodic interest yield on a security.
yielddisc
Calculate the annual yield for a discounted security.
yieldmat
Calculate the annual yield of a security with interest at maturity.
z.test
Calculate the P-value for a z-test.
ztest
Calculate the one-tailed probability-value of a z-test.
and
To test multiple logical conditions at the same time.
cell
The CELL function is used in Sourcetable to get information about a cell, such as the address, data type, and contents.
choose
To get a value from a list using a list index.
concatenate
Joins strings of text together.
counta
To count the number of cells that contain data.
countif
Counts cells that match a criterion.
date
Creates dates from inputting a year, month, and day
filter
Filters a range of cells based on supplied criteria
find
To find out where a substring is located within a string.
forecast
Predicts values based on a linear trend
frequency
Counts how many times each value appears in a data set
if
To test a condition and return one value if the condition is true and another value if the condition is false.
iferror
To trap and manage errors.
ifs
Evaluates multiple conditions and returns the first result that is TRUE
index
To retrieve a value based on its location within a given array, vector, or reference.
indirect
Uses text to create references
irr
Determines the internal rate of return for a given investment.
left
To extract text from the left of a text string.
len
Calculates the length of any text string
linest
Calculates the parameters of the best-fit line for a set of data points
lookup
Searches a one-column range for a specific value
match
Locates the position of a specific value within an array
max
To get the largest value in a set of data.
median
Calculates the middle value of a set of numbers
mid
To extract text from a given string.
mod
Calculates the remainder when two numbers are divided
now
Displays the current date and time
offset
To create a reference from a specific starting point.
or
Tests multiple logical conditions simultaneously
pmt
To calculate periodic loan payments.
pv
Calculates the present value of an investment
rand
Generates a random number between 0 and 1
rank
Determines the relative rank of a given number compared to other numbers in a list or array
rate
Calculates the periodic interest rate of an annuity.
replace
To replace characters in a string by location.
right
To find a specified number of characters from the right end of the source string
round
Rounds a number to the desired number of digits specified
roundup
Rounds a number up to a specified number of decimal places
row
Identifies and returns the row number for a given reference
rows
To return the number of rows in a reference.
search
To find where a substring is within another string.
small
Identifies the n<sup>th</sup> smallest value in an array of given values
sumif
Add cells together based on a given criteria.
sumifs
To sum cells in a range that meet one or more conditions.
text
Converts numbers into their textual equivalent
today
Gets today's date.
trim
Removes any unnecessary white space from text
vlookup
Searches for data stored in the first column of a table.
weekday
Retrieves the day of the week from a given date
average
To calculate the average of a set of numbers.
count
To count numerical values.
subtotal
To get a subtotal from a list or database.
query
To pull data from a data table into the sheet.
sum
To calculate the total or sum of a range of numeric values, including individual numbers, cell references, or cell ranges.
binomdist
To calculate the probability of a specific number of successes in a fixed number of trials with a specified probability of success.
critbinom
The CRITBINOM function calculates the smallest number of successes required in a fixed number of binomial trials to meet or exceed a specified criterion value, making it useful for determining critical values in hypothesis testing.
bin2hex
To converts a binary number to its hexadecimal equivalent.
bin2oct
The BIN2OCT formula converts a binary number to its octal equivalent.
bitand
The BITAND formula performs a bitwise AND operation on two integers, comparing each pair of corresponding bits and returning an integer result where each bit is the logical AND of the corresponding bits in the input integers.
bitlshift
The BITLSHIFT formula performs a bitwise left shift operation on an integer, shifting its bits a specified number of positions to the left and returning the result as an integer.
accrintm
The ACCRINTM formula calculates the accrued interest for a security that pays interest at maturity, based on the issue date, maturity date, and rate of interest.
binom.dist
The BINOM.DIST formula calculates the binomial probability or the cumulative binomial distribution for a given number of successes, trials, and probability of success on each trial.
binom.dist.range
The BINOM.DIST.RANGE formula calculates the probability of achieving a specified range of successes in a fixed number of trials, each with the same probability of success, using the binomial distribution.
binom.inv
The BINOM.INV function calculates the smallest number of successes (k) for which the cumulative binomial distribution is greater than or equal to a specified criteria (alpha), given a fixed number of trials (n) and the probability of success (p) on each trial.
cot
To calculate the cotangent of a specified angle in radians, which is the reciprocal of the tangent of the angle.
coth
To calculate the hyperbolic cotangent of a given number, which is the reciprocal of the hyperbolic tangent of that number.
cumprinc
The CUMPRINC function calculates the cumulative principal paid on a loan between two specified periods, providing the total amount of principal repaid over a range of payment periods.
dollar
The DOLLAR function converts a numeric value into a text string formatted as currency, with the default currency symbol and a specified number of decimal places.
rightb
To extract a specified number of bytes from the right end of a text string, making it useful for handling text in double-byte character sets (DBCS).
single
The SINGLE function is used to extract a single value from an array or range, making it particularly useful for retrieving a specific value from a dynamic array result.
wraprows
To wrap a row or column by a certain number of rows which creates a new array.