WP App Studio supports most of Microsoft Excel functions in attribute calculations. The list below shows function names, parameters, and brief descriptions. The parameters in square brackets[] are optional.(WPAS 4.6)
| Category | Name | Definition | Parameters |
|---|---|---|---|
| Date and time | DATE | Returns the serial number of a particular date | DATE(year,month,day) |
| Date and time | DATEDIF | Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. | DATEDIF(startDate,endDate,unit = 'D') |
| Date and time | DATEVALUE | Converts a date in the form of text to a serial number | DATEVALUE(dateValue) |
| Date and time | DAY | Converts a serial number to a day of the month | DAY(dateValue) |
| Date and time | DAYS360 | Calculates the number of days between two dates based on a 360-day year | DAYS360(startDate,endDate[,method]) |
| Date and time | EDATE | Returns the serial number of the date that is the indicated number of months before or after the start date | EDATE(dateValue,adjustmentMonths) |
| Date and time | EOMONTH | Returns the serial number of the last day of the month before or after a specified number of months | EOMONTH(dateValue,adjustmentMonths) |
| Date and time | HOUR | Converts a serial number to an hour | HOUR(timeValue) |
| Date and time | MINUTE | Converts a serial number to a minute | MINUTE(timeValue) |
| Date and time | MONTH | Converts a serial number to a month | MONTH(dateValue) |
| Date and time | NETWORKDAYS | Returns the number of whole workdays between two dates | NETWORKDAYS(startDate,endDate[,holidays[,holiday[,...]]]) |
| Date and time | NOW | Returns the serial number of the current date and time | NOW() |
| Date and time | SECOND | Converts a serial number to a second | SECOND(timeValue) |
| Date and time | TIME | Returns the serial number of a particular time | TIME(hour,minute,second) |
| Date and time | TIMEVALUE | Converts a time in the form of text to a serial number | TIMEVALUE(timeValue) |
| Date and time | TODAY | Returns the serial number of today's date | TODAY() |
| Date and time | WEEKDAY | Converts a serial number to a day of the week | WEEKDAY(dateValue[,style]) |
| Date and time | WEEKNUM | Converts a serial number to a number representing where the week falls numerically with a year | WEEKNUM(dateValue[,style]) |
| Date and time | WORKDAY | Returns the serial number of the date before or after a specified number of workdays | WORKDAY(startDate,endDays[,holidays[,holiday[,...]]]) |
| Date and time | YEAR | Converts a serial number to a year | YEAR(dateValue) |
| Date and time | YEARFRAC | Returns the year fraction representing the number of whole days between start_date and end_date | YEARFRAC(startDate,endDate[,method]) |
| Engineering | BESSELI | Returns the modified Bessel function In(x) | BESSELI(x,ord) |
| Engineering | BESSELJ | Returns the Bessel function Jn(x) | BESSELJ(x,ord) |
| Engineering | BESSELK | Returns the modified Bessel function Kn(x) | BESSELK(x,ord) |
| Engineering | BESSELY | Returns the Bessel function Yn(x) | BESSELY(x,ord) |
| Engineering | BIN2DEC | Converts a binary number to decimal | BIN2DEC(x) |
| Engineering | BIN2HEX | Converts a binary number to hexadecimal | BIN2HEX(x[,places]) |
| Engineering | BIN2OCT | Converts a binary number to octal | BIN2OCT(x[,places]) |
| Engineering | COMPLEX | Converts real and imaginary coefficients into a complex number | COMPLEX(realNumber,imaginary[,places]) |
| Engineering | CONVERT | Converts a number from one measurement system to another | CONVERT(value,fromUOM,toUOM) |
| Engineering | DEC2BIN | Converts a decimal number to binary | DEC2BIN(x[,places]) |
| Engineering | DEC2HEX | Converts a decimal number to hexadecimal | DEC2HEX(x[,places]) |
| Engineering | DEC2OCT | Converts a decimal number to octal | DEC2OCT(x[,places]) |
| Engineering | DELTA | Tests whether two values are equal | DELTA(a[,b]) |
| Engineering | ERF | Returns the error function | ERF(lower[,upper]) |
| Engineering | ERFC | Returns the complementary error function | ERFC(x) |
| Engineering | GESTEP | Tests whether a number is greater than a threshold value | GESTEP(number[,step]) |
| Engineering | HEX2BIN | Converts a hexadecimal number to binary | HEX2BIN(x[,places]) |
| Engineering | HEX2DEC | Converts a hexadecimal number to decimal | HEX2DEC(x) |
| Engineering | HEX2OCT | Converts a hexadecimal number to octal | HEX2OCT(x[,places]) |
| Engineering | IMABS | Returns the absolute value (modulus) of a complex number | IMABS(complexNumber) |
| Engineering | IMAGINARY | Returns the imaginary coefficient of a complex number | IMAGINARY(complexNumber) |
| Engineering | IMARGUMENT | Returns the argument theta, an angle expressed in radians | IMARGUMENT(complexNumber) |
| Engineering | IMCONJUGATE | Returns the complex conjugate of a complex number | IMCONJUGATE(complexNumber) |
| Engineering | IMCOS | Returns the cosine of a complex number | IMCOS(complexNumber) |
| Engineering | IMDIV | Returns the quotient of two complex numbers | IMDIV(complexDividend,complexDivisor) |
| Engineering | IMEXP | Returns the exponential of a complex number | IMEXP(complexNumber) |
| Engineering | IMLN | Returns the natural logarithm of a complex number | IMLN(complexNumber) |
| Engineering | IMLOG10 | Returns the base-10 logarithm of a complex number | IMLOG10(complexNumber) |
| Engineering | IMLOG2 | Returns the base-2 logarithm of a complex number | IMLOG2(complexNumber) |
| Engineering | IMPOWER | Returns a complex number raised to an integer power | IMPOWER(complexNumber,realNumber) |
| Engineering | IMPRODUCT | Returns the product of complex numbers | IMPRODUCT(complexNumber[,complexNumber[,...]]) |
| Engineering | IMREAL | Returns the real coefficient of a complex number | IMREAL(complexNumber) |
| Engineering | IMSIN | Returns the sine of a complex number | IMSIN(complexNumber) |
| Engineering | IMSQRT | Returns the square root of a complex number | IMSQRT(complexNumber) |
| Engineering | IMSUB | Returns the difference between two complex numbers | IMSUB(complexNumber1,complexNumber2) |
| Engineering | IMSUM | Returns the sum of complex numbers | IMSUM(complexNumber[,complexNumber[,...]]) |
| Engineering | OCT2BIN | Converts an octal number to binary | OCT2BIN(x[,places]) |
| Engineering | OCT2DEC | Converts an octal number to decimal | OCT2DEC(x) |
| Engineering | OCT2HEX | Converts an octal number to hexadecimal | OCT2HEX(x[,places]) |
| Financial | ACCRINT | Returns the accrued interest for a security that pays periodic interest | ACCRINT(issue,firstinterest,settlement,rate,par,frequency[,basis]) |
| Financial | ACCRINTM | Returns the accrued interest for a security that pays interest at maturity | ACCRINTM(issue,settlement,rate[,par[,basis]]) |
| Financial | AMORDEGRC | Returns the depreciation for each accounting period by using a depreciation coefficient | AMORDEGRC(cost,purchased,firstPeriod,salvage,period,rate[,basis]) |
| Financial | AMORLINC | Returns the depreciation for each accounting period | AMORLINC(cost,purchased,firstPeriod,salvage,period,rate[,basis]) |
| Financial | COUPDAYBS | Returns the number of days from the beginning of the coupon period to the settlement date | COUPDAYBS(settlement,maturity,frequency[,basis]) |
| Financial | COUPDAYS | Returns the number of days in the coupon period that contains the settlement date | COUPDAYS(settlement,maturity,frequency[,basis]) |
| Financial | COUPDAYSNC | Returns the number of days from the settlement date to the next coupon date | COUPDAYSNC(settlement,maturity,frequency[,basis]) |
| Financial | COUPNCD | Returns the next coupon date after the settlement date | COUPNCD(settlement,maturity,frequency[,basis]) |
| Financial | COUPNUM | Returns the number of coupons payable between the settlement date and maturity date | COUPNUM(settlement,maturity,frequency[,basis]) |
| Financial | COUPPCD | Returns the previous coupon date before the settlement date | COUPPCD(settlement,maturity,frequency[,basis]) |
| Financial | CUMIPMT | Returns the cumulative interest paid between two periods | CUMIPMT(rate,nper,pv,start,end[,type]) |
| Financial | CUMPRINC | Returns the cumulative principal paid on a loan between two periods | CUMPRINC(rate,nper,pv,start,end[,type]) |
| Financial | DB | Returns the depreciation of an asset for a specified period by using the fixed-declining balance method | B(cost,salvage,life,period[,month]) |
| Financial | DDB | Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify | DDB(cost,salvage,life,period[,factor]) |
| Financial | DISC | Returns the discount rate for a security | DISC(settlement,maturity,price,redemption[,basis]) |
| Financial | DOLLARDE | Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number | DOLLARDE(fractional_dollar,fraction) |
| Financial | DOLLARFR | Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction | DOLLARFR(decimal_dollar,fraction) |
| Financial | EFFECT | Returns the effective annual interest rate | EFFECT(nominal_rate,npery) |
| Financial | FV | Returns the future value of an investment | FV(rate,nper,pmt[,pv[,type]]) |
| Financial | FVSCHEDULE | Returns the future value of an initial principal after applying a series of compound interest rates | FVSCHEDULE(principal,schedule) |
| Financial | INTRATE | Returns the interest rate for a fully invested security | INTRATE(settlement,maturity,investment,redemption[,basis]) |
| Financial | IPMT | Returns the interest payment for an investment for a given period | IPMT(rate,per,nper,pv[,fv][,type]) |
| Financial | IRR | Returns the internal rate of return for a series of cash flows | IRR(Array(values)[,guess]) |
| Financial | ISPMT | Calculates the interest paid during a specific period of an investment | ISPMT(interest_rate, period, number_payments, PV) |
| Financial | MIRR | Returns the internal rate of return where positive and negative cash flows are financed at different rates | MIRR(values,finance_rate, reinvestment_rate) |
| Financial | NOMINAL | Returns the annual nominal interest rate | NOMINAL(effect_rate, number_payments_per_year) |
| Financial | NPER | Returns the number of periods for an investment | NPER(interest_rate, periodic_payment, present_value[,future_value,payment_type]) |
| Financial | NPV | Returns the net present value of an investment based on a series of periodic cash flows and a discount rate | NPV(discount_rate, value1, [value2, ... value_n]) |
| Financial | PMT | Returns the periodic payment for an annuity | PMT(interest_rate,number_of_periods,present_value[,future_value,payment_type]) |
| Financial | PPMT | Returns the payment on the principal for an investment for a given period | PPMT( interest_rate, period, number_payments, PV, [FV], [Type] ) |
| Financial | PRICE | Returns the price per $100 face value of a security that pays periodic interest | PRICE(settlement, maturity, rate, yield, redemption, frequency, [basis ]) |
| Financial | PRICEDISC | Returns the price per $100 face value of a discounted security | PRICEDISC(settlement, maturity, discount, redemption, [basis]) |
| Financial | PRICEMAT | Returns the price per $100 face value of a security that pays interest at maturity | PRICEMAT(settlement, maturity, issue, rate, yield, [basis]) |
| Financial | PV | Returns the present value of an investment | PV( interest_rate, number_payments, payment, [FV], [Type] ) |
| Financial | RATE | Returns the interest rate per period of an annuity | RATE(nper,pmt,pv[,fv[,type[,guess]]]) |
| Financial | RECEIVED | Returns the amount received at maturity for a fully invested security | RECEIVED(settlement, maturity, investment, discount, [basis]) |
| Financial | SLN | Returns the straight-line depreciation of an asset for one period | SLN(cost, salvage, life) |
| Financial | SYD | Returns the sum-of-years' digits depreciation of an asset for a specified period | SLN(cost, salvage, life, period) |
| Financial | TBILLEQ | Returns the bond-equivalent yield for a Treasury bill | TBILLEQ(settlement, maturity, discount) |
| Financial | TBILLPRICE | Returns the price per $100 face value for a Treasury bill | TBILLPRICE(settlement, maturity, discount) |
| Financial | TBILLYIELD | Returns the yield for a Treasury bill | TBILLYIELD(settlement, maturity, discount) |
| Financial | XIRR | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic | XIRR(Array(values),Array(dates)[,$guess]) |
| Financial | XNPV | Returns the net present value for a schedule of cash flows that is not necessarily periodic | XNPV(rate,Array(values),Array(dates)) |
| Financial | YIELDDISC | Returns the annual yield for a discounted security; for example, a Treasury bill | YIELDDISC(settlement, maturity, price, redemption, basis) |
| Financial | YIELDMAT | Returns the annual yield of a security that pays interest at maturity | YIELDMAT(settlement, maturity, issue, rate, price, basis) |
| Information | ERROR.TYPE | Returns a number corresponding to an error type | ERROR.TYPE(value) |
| Information | ISBLANK | Returns TRUE if the value is blank | ISBLANK(value) |
| Information | ISERR | Returns TRUE if the value is any error value except #N/A | ISERR(value) |
| Information | ISERROR | Returns TRUE if the value is any error value | ISERROR(value) |
| Information | ISEVEN | Returns TRUE if the number is even | ISEVEN(value) |
| Information | ISLOGICAL | Returns TRUE if the value is a logical value | ISLOGICAL(value) |
| Information | ISNA | Returns TRUE if the value is the #N/A error value | ISNA(value) |
| Information | ISNONTEXT | Returns TRUE if the value is not text | ISNONTEXT(value) |
| Information | ISNUMBER | Returns TRUE if the value is a number | ISNUMBER(value) |
| Information | ISODD | Returns TRUE if the number is odd | ISODD(value) |
| Information | ISTEXT | Returns TRUE if the value is text | ISTEXT(value) |
| Information | N | Returns a value converted to a number | N(value) |
| Information | NA | Returns the error value #N/A | NA() |
| Information | TYPE | Returns a number indicating the data type of a value | TYPE(value) |
| Logical | AND | Returns TRUE if all of its arguments are TRUE | AND(logical1[,logical2[, ...]]) |
| Logical | FALSE | Returns the logical value FALSE | FALSE() |
| Logical | IF | Specifies a logical test to perform | IF(condition[,returnIfTrue[,returnIfFalse]]) |
| Logical | IFERROR | Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula | IFERROR(testValue,errorpart) |
| Logical | NOT | Reverses the logic of its argument | NOT(logical) |
| Logical | OR | Returns TRUE if any argument is TRUE | OR(logical1[,logical2[, ...]]) |
| Logical | TRUE | Returns the logical value TRUE | TRUE() |
| Math and trigonometry | SQRT | Returns a positive square root | SQRT(number) |
| Math and trigonometry | ABS | Returns the absolute value of a number | ABS(number) |
| Math and trigonometry | ACOS | Returns the arccosine of a number | ACOS(number) |
| Math and trigonometry | ACOSH | Returns the inverse hyperbolic cosine of a number | ACOSH(number) |
| Math and trigonometry | ASIN | Returns the arcsine of a number | ASIN(number) |
| Math and trigonometry | ASINH | Returns the inverse hyperbolic sine of a number | ASINH(number) |
| Math and trigonometry | ATAN | Returns the arctangent of a number | ATAN(number) |
| Math and trigonometry | ATAN2 | Returns the arctangent from x- and y-coordinates | ATAN2(xCoordinate,yCoordinate) |
| Math and trigonometry | ATANH | Returns the inverse hyperbolic tangent of a number | ATANH(number) |
| Math and trigonometry | CEILING | Rounds a number to the nearest integer or to the nearest multiple of significance | CEILING(number[,significance]) |
| Math and trigonometry | COMBIN | Returns the number of combinations for a given number of objects | COMBIN(numObjs,numInSet) |
| Math and trigonometry | COS | Returns the cosine of a number | COS(number) |
| Math and trigonometry | COSH | Returns the hyperbolic cosine of a number | COSH(number) |
| Math and trigonometry | DEGREES | Converts radians to degrees | DEGREES( radians ) |
| Math and trigonometry | EVEN | Rounds a number up to the nearest even integer | EVEN(number) |
| Math and trigonometry | EXP | Returns e raised to the power of a given number | EXP(number) |
| Math and trigonometry | FACT | Returns the factorial of a number | FACT(factVal) |
| Math and trigonometry | FACTDOUBLE | Returns the double factorial of a number | FACTDOUBLE(factVal) |
| Math and trigonometry | FLOOR | Rounds a number down, to the nearest integer or to the nearest multiple of significance | FLOOR(number[,significance]) |
| Math and trigonometry | GCD | Returns the greatest common divisor | GCD(number1[,number2[, ...]]) |
| Math and trigonometry | INT | Rounds a number down to the nearest integer | INT(number) |
| Math and trigonometry | LCM | Returns the least common multiple | LCM(number1[,number2[, ...]]) |
| Math and trigonometry | LN | Returns the natural logarithm of a number | LN(number) |
| Math and trigonometry | LOG | Returns the logarithm of a number to a specified base | LOG(number[,base]) |
| Math and trigonometry | LOG10 | Returns the base-10 logarithm of a number | LOG10(number) |
| Math and trigonometry | MDETERM | Returns the matrix determinant of an array | MDETERM(Array(values)) |
| Math and trigonometry | MINVERSE | Returns the matrix inverse of an array | MINVERSE(array) |
| Math and trigonometry | MMULT | Returns the matrix product of two arrays | MMULT(Array(Values1), Array(Values2)) |
| Math and trigonometry | MOD | Returns the remainder from division | MOD(number,divisor) |
| Math and trigonometry | MROUND | Returns a number rounded to the desired multiple | MROUND(number, multiple) |
| Math and trigonometry | MULTINOMIAL | Returns the multinomial of a set of numbers | MULTINOMIAL(array) |
| Math and trigonometry | ODD | Rounds a number up to the nearest odd integer | ODD(number) |
| Math and trigonometry | PI | Returns the value of pi | PI(number) |
| Math and trigonometry | POWER | Returns the result of a number raised to a power | POWER(number,power) |
| Math and trigonometry | PRODUCT | Multiplies its arguments | PRODUCT(value1[,value2[, ...]]) |
| Math and trigonometry | QUOTIENT | Returns the integer portion of a division | QUOTIENT(value1[,value2[, ...]]) |
| Math and trigonometry | RADIANS | Converts degrees to radians | RADIANS(degrees) |
| Math and trigonometry | RAND | Returns a random number between 0 and 1 | RAND() |
| Math and trigonometry | RANDBETWEEN | Returns a random number between the numbers you specify | RAND(number1,number2) |
| Math and trigonometry | ROMAN | Converts an arabic numeral to roman, as text | ROMAN(number,type) |
| Math and trigonometry | ROUND | Rounds a number to a specified number of digits | ROUND(number) |
| Math and trigonometry | ROUNDDOWN | Rounds a number down, toward zero | ROUNDDOWN(number,digits) |
| Math and trigonometry | ROUNDUP | Rounds a number up, away from zero | ROUNDUP(number,digits) |
| Math and trigonometry | SERIESSUM | Returns the sum of a power series based on the formula | SERIESSUM( x, n, m, coefficients ) |
| Math and trigonometry | SIGN | Returns the sign of a number | SIGN(number) |
| Math and trigonometry | SIN | Returns the sine of the given angle | SIN(number) |
| Math and trigonometry | SINH | Returns the hyperbolic sine of a number | SINH(number) |
| Math and trigonometry | SQRTPI | Returns the square root of (number * pi) | SQRTPI(number) |
| Math and trigonometry | SUBTOTAL | Returns a subtotal in a list or database | SUBTOTAL(method, range1, [range2, ... range_n]) |
| Math and trigonometry | SUM | Adds its arguments | SUM(value1[,value2[, ...]]) |
| Math and trigonometry | SUMIF | Adds the cells specified by a given criteria | SUMIF(value1[,value2[, ...]],condition) |
| Math and trigonometry | SUMPRODUCT | Returns the sum of the products of corresponding array components | SUMPRODUCT(value1[,value2[, ...]]) |
| Math and trigonometry | SUMSQ | Returns the sum of the squares of the arguments | SUMSQ(value1[,value2[, ...]]) |
| Math and trigonometry | SUMX2MY2 | Returns the sum of the difference of squares of corresponding values in two arrays | SUMX2MY2(Array(Values1), Array(Values2)) |
| Math and trigonometry | SUMX2PY2 | Returns the sum of the sum of squares of corresponding values in two arrays | SUMX2PY2(Array(Values1), Array(Values2)) |
| Math and trigonometry | SUMXMY2 | Returns the sum of squares of differences of corresponding values in two arrays | SUMXMY2(Array(Values1), Array(Values2)) |
| Math and trigonometry | TAN | Returns the tangent of a number | TAN(number) |
| Math and trigonometry | TANH | Returns the hyperbolic tangent of a number | TANH(number) |
| Math and trigonometry | TRUNC | Truncates a number to an integer | TRUNC(number, [digits] ) |
| Statistical | AVEDEV | Returns the average of the absolute deviations of data points from their mean | AVEDEV(value1[,value2[, ...]]) |
| Statistical | AVERAGE | Returns the average of its arguments | AVERAGE(value1[,value2[, ...]]) |
| Statistical | AVERAGEA | Returns the average of its arguments, including numbers, text, and logical values | AVERAGEA(value1[,value2[, ...]]) |
| Statistical | AVERAGEIF | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria | AVERAGEIF(value1[,value2[, ...]],condition) |
| Statistical | BETADIST | Returns the beta cumulative distribution function | BETADIST( x, alpha, beta, [lower_bound], [upper_bound] ) |
| Statistical | BETAINV | Returns the inverse of the cumulative distribution function for a specified beta distribution | BETAINV( probability, alpha, beta, [lower_bound], [upper_bound] ) |
| Statistical | BINOMDIST | Returns the individual term binomial distribution probability | BINOMDIST( number_success, number_trial, prob_success, cumulative ) |
| Statistical | CONFIDENCE | Returns the confidence interval for a population mean | CONFIDENCE(alpha, standard_deviation, size) |
| Statistical | CORREL | Returns the correlation coefficient between two data sets | CORREL(Array(yValues), [Array(xValues)]) |
| Statistical | COUNT | Counts how many numbers are in the list of arguments | COUNT(value1[,value2[, ...]]) |
| Statistical | COUNTA | Counts how many values are in the list of arguments | COUNTA(value1[,value2[, ...]]) |
| Statistical | COUNTBLANK | Counts the number of blank cells within a range | COUNTBLANK(value1[,value2[, ...]]) |
| Statistical | COUNTIF | Counts the number of cells within a range that meet the given criteria | COUNTIF(value1[,value2[, ...]],condition) |
| Statistical | COVAR | Returns covariance, the average of the products of paired deviations | COVAR(Array(yValues), Array(xValues)) |
| Statistical | DEVSQ | Returns the sum of squares of deviations | DEVSQ(value1[,value2[, ...]]) |
| Statistical | EXPONDIST | Returns the exponential distribution | EXPONDIST(value, lambda, cumulative) |
| Statistical | FISHER | Returns the Fisher transformation | FISHER(value) |
| Statistical | FISHERINV | Returns the inverse of the Fisher transformation | FISHERINV(value) |
| Statistical | FORECAST | Returns a value along a linear trend. | FORECAST( x-value, Array(known_y_values), Array(known_x_values) ) |
| Statistical | GAMMADIST | Returns the gamma distribution | GAMMADIST($value, a, b, cumulative) |
| Statistical | GAMMAINV | Returns the inverse of the gamma cumulative distribution | GAMMAINV(probability, alpha, beta) |
| Statistical | GAMMALN | Returns the natural logarithm of the gamma function, Γ(x) | GAMMALN(value) |
| Statistical | GEOMEAN | Returns the geometric mean | GEOMEAN(value1[,value2[, ...]]) |
| Statistical | GROWTH | Returns values along an exponential trend | GROWTH(Array(known_y_values), [Array(known_x_values)], [Array(new_x_values)], [constant] ) |
| Statistical | HARMEAN | Returns the harmonic mean | HARMEAN(value1[,value2[, ...]]) |
| Statistical | HYPGEOMDIST | Returns the hypergeometric distribution | HYPGEOMDIST(sample_successes, sample_number, population_successes, population_number) |
| Statistical | INTERCEPT | Returns the intercept of the linear regression line | INTERCEPT(Array(yValues), Array(xValues)) |
| Statistical | KURT | Returns the kurtosis of a data set | KURT(array) |
| Statistical | LARGE | Returns the k-th largest value in a data set | LARGE(value1[,value2[, ...]],entry) |
| Statistical | LINEST | Returns the parameters of a linear trend | LINEST( yValues, [xValues], [constant], [additional_statistics] ) |
| Statistical | LOGEST | Returns the parameters of an exponential trend | LOGEST( yValues, [xValues], [constant], [additional_statistics] ) |
| Statistical | LOGNORMDIST | Returns the cumulative lognormal distribution | OGNORMDIST(value, mean, stdDev) |
| Statistical | MAX | Returns the maximum value in a list of arguments | MAX(value1[,value2[, ...]]) |
| Statistical | MAXA | Returns the maximum value in a list of arguments, including numbers, text, and logical values | MAXA(value1[,value2[, ...]]) |
| Statistical | MEDIAN | Returns the median of the given numbers | MEDIAN(value1[,value2[, ...]]) |
| Statistical | MIN | Returns the minimum value in a list of arguments | MIN(value1[,value2[, ...]]) |
| Statistical | MINA | Returns the smallest value in a list of arguments, including numbers, text, and logical values | MINA(value1[,value2[, ...]]) |
| Statistical | MODE | Returns the most common value in a data set | MODE(value1[,value2[, ...]]) |
| Statistical | NEGBINOMDIST | Returns the negative binomial distribution | NEGBINOMDIST(failures, successes, probability) |
| Statistical | NORMDIST | Returns the normal cumulative distribution | NORMDIST(value, mean, stdDev, cumulative) |
| Statistical | NORMINV | Returns the inverse of the normal cumulative distribution | NORMINV(probability, mean, stdDev) |
| Statistical | NORMSDIST | Returns the standard normal cumulative distribution | NORMSDIST(value) |
| Statistical | NORMSINV | Returns the inverse of the standard normal cumulative distribution | NORMSINV(value) |
| Statistical | PERCENTILE | Returns the k-th percentile of values in a range | PERCENTILE(value1[,value2[, ...]],entry) |
| Statistical | PERCENTRANK | Returns the percentage rank of a value in a data set | PERCENTRANK(valueSet, value, [significance]) |
| Statistical | PERMUT | Returns the number of permutations for a given number of objects | PERMUT(number_objects, number_in_each_permutation) |
| Statistical | POISSON | Returns the Poisson distribution | POISSON(value, mean, cumulative) |
| Statistical | QUARTILE | Returns the quartile of a data set | QUARTILE(value1[,value2[, ...]],entry) |
| Statistical | RANK | Returns the rank of a number in a list of numbers | RANK( number, array, [order] ) |
| Statistical | RSQ | Returns the square of the Pearson product moment correlation coefficient | RSQ(Array(yValues), Array(xValues)) |
| Statistical | SKEW | Returns the skewness of a distribution | SKEW(array) |
| Statistical | SLOPE | Returns the slope of the linear regression line | SLOPE(Array(yValues), Array(xValues)) |
| Statistical | SMALL | Returns the k-th smallest value in a data set | SMALL(value1[,value2[, ...]],entry) |
| Statistical | STANDARDIZE | Returns a normalized value | STANDARDIZE(value, mean, stdDev) |
| Statistical | STDEVP | Calculates standard deviation based on the entire population | STDEVP(value1[,value2[, ...]]) |
| Statistical | STDEVA | Estimates standard deviation based on a sample, including numbers, text, and logical values | STDEVA(value1[,value2[, ...]]) |
| Statistical | STDEVPA | Calculates standard deviation based on the entire population, including numbers, text, and logical values | STDEVPA(value1[,value2[, ...]]) |
| Statistical | STEYX | Returns the standard error of the predicted y-value for each x in the regression | STEYX(Array(yValues), Array(xValues)) |
| Statistical | TDIST | Returns the Percentage Points (probability) for the Student t-distribution | TDIST(value, degrees, tails) |
| Statistical | TINV | Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom | TINV(probability, degrees) |
| Statistical | TREND | Returns values along a linear trend | TREND(Array(yValues), [Array(xValues), Array(new_values), logical_value]) |
| Statistical | TRIMMEAN | Returns the mean of the interior of a data set | TRIMEAN(value1[,value2[, ...]], $discard) |
| Statistical | VARP | Calculates variance based on the entire population | VARP(value1[,value2[, ...]]) |
| Statistical | VARA | Estimates variance based on a sample, including numbers, text, and logical values | VARA(value1[,value2[, ...]]) |
| Statistical | VARPA | Calculates variance based on the entire population, including numbers, text, and logical values | VARPA(value1[,value2[, ...]]) |
| Statistical | WEIBULL | Returns the Weibull distribution | WEIBULL(value, alpha, beta, cumulative) |
| Statistical | ZTEST | Returns the one-tailed probability-value of a z-test | ZTEST(dataSet, m0, [sigma]) |
| Text | CHAR | Returns the character specified by the code number | CHAR(value) |
| Text | CLEAN | Removes all nonprintable characters from text | CLEAN(value) |
| Text | CODE | Returns a numeric code for the first character in a text string | CODE(value) |
| Text | CONCATENATE | Joins several text items into one text item | CONCATENATE( text1, text2, ... text_n ) |
| Text | DOLLAR | Converts a number to text, using the $ (dollar) currency format | DOLLAR( number, [decimal_places] ) |
| Text | FIND | Finds one text value within another (case-sensitive) | FIND( substring, string, [start_position] ) |
| Text | FIXED | Formats a number as text with a fixed number of decimals | FIXED( number, [decimal_places], [no_commas] ) |
| Text | LEFT | Returns the leftmost characters from a text value | LEFT( text, [number_of_characters] ) |
| Text | LEN | Returns the number of characters in a text string | LEN(text) |
| Text | LOWER | Converts text to lowercase | LOWER(text) |
| Text | MID | Returns a specific number of characters from a text string starting at the position you specify | MID( text, start_position, number_of_characters ) |
| Text | PROPER | Capitalizes the first letter in each word of a text value | PROPER(text) |
| Text | REPLACE | Replaces characters within text | REPLACE( old_text, start, number_of_chars, new_text ) |
| Text | REPT | Repeats text a given number of times | REPT( text, number ) |
| Text | RIGHT | Returns the rightmost characters from a text value | RIGHT(text,number_of_chars) |
| Text | SEARCH | Finds one text value within another (not case-sensitive) | SEARCH( substring, string, [start_position] ) |
| Text | SUBSTITUTE | Substitutes new text for old text in a text string | SUBSTITUTE( text, old_text, new_text, [nth_appearance] ) |
| Text | T | Converts its arguments to text | T(text) |
| Text | TEXT | Formats a number and converts it to text | TEXT(text,format) |
| Text | TRIM | Removes spaces from text | TRIM(text) |
| Text | UPPER | Converts text to uppercase | UPPER(text) |
| Text | VALUE | Converts a text argument to a number | VALUE(value) |
Loading...