Last modified by eMDPlugins - 2 years ago
107 Views
13 min read

Calculated Attribute Functions

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)







CategoryNameDefinitionParameters
Date and timeDATEReturns the serial number of a particular dateDATE(year,month,day)
Date and timeDATEDIFCalculates 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 timeDATEVALUEConverts a date in the form of text to a serial numberDATEVALUE(dateValue)
Date and timeDAYConverts a serial number to a day of the monthDAY(dateValue)
Date and timeDAYS360Calculates the number of days between two dates based on a 360-day yearDAYS360(startDate,endDate[,method])
Date and timeEDATEReturns the serial number of the date that is the indicated number of months before or after the start dateEDATE(dateValue,adjustmentMonths)
Date and timeEOMONTHReturns the serial number of the last day of the month before or after a specified number of monthsEOMONTH(dateValue,adjustmentMonths)
Date and timeHOURConverts a serial number to an hourHOUR(timeValue)
Date and timeMINUTEConverts a serial number to a minuteMINUTE(timeValue)
Date and timeMONTHConverts a serial number to a monthMONTH(dateValue)
Date and timeNETWORKDAYSReturns the number of whole workdays between two datesNETWORKDAYS(startDate,endDate[,holidays[,holiday[,...]]])
Date and timeNOWReturns the serial number of the current date and timeNOW()
Date and timeSECONDConverts a serial number to a secondSECOND(timeValue)
Date and timeTIMEReturns the serial number of a particular timeTIME(hour,minute,second)
Date and timeTIMEVALUEConverts a time in the form of text to a serial numberTIMEVALUE(timeValue)
Date and timeTODAYReturns the serial number of today's dateTODAY()
Date and timeWEEKDAYConverts a serial number to a day of the weekWEEKDAY(dateValue[,style])
Date and timeWEEKNUMConverts a serial number to a number representing where the week falls numerically with a yearWEEKNUM(dateValue[,style])
Date and timeWORKDAYReturns the serial number of the date before or after a specified number of workdaysWORKDAY(startDate,endDays[,holidays[,holiday[,...]]])
Date and timeYEARConverts a serial number to a yearYEAR(dateValue)
Date and timeYEARFRACReturns the year fraction representing the number of whole days between start_date and end_dateYEARFRAC(startDate,endDate[,method])
EngineeringBESSELIReturns the modified Bessel function In(x)BESSELI(x,ord)
EngineeringBESSELJReturns the Bessel function Jn(x) BESSELJ(x,ord)
EngineeringBESSELKReturns the modified Bessel function Kn(x)BESSELK(x,ord)
EngineeringBESSELYReturns the Bessel function Yn(x)BESSELY(x,ord)
EngineeringBIN2DECConverts a binary number to decimalBIN2DEC(x)
EngineeringBIN2HEXConverts a binary number to hexadecimalBIN2HEX(x[,places])
EngineeringBIN2OCTConverts a binary number to octalBIN2OCT(x[,places])
EngineeringCOMPLEXConverts real and imaginary coefficients into a complex numberCOMPLEX(realNumber,imaginary[,places])
EngineeringCONVERTConverts a number from one measurement system to anotherCONVERT(value,fromUOM,toUOM)
EngineeringDEC2BINConverts a decimal number to binaryDEC2BIN(x[,places])
EngineeringDEC2HEXConverts a decimal number to hexadecimalDEC2HEX(x[,places])
EngineeringDEC2OCTConverts a decimal number to octalDEC2OCT(x[,places])
EngineeringDELTATests whether two values are equal DELTA(a[,b])
EngineeringERFReturns the error functionERF(lower[,upper])
EngineeringERFCReturns the complementary error functionERFC(x)
EngineeringGESTEPTests whether a number is greater than a threshold valueGESTEP(number[,step])
EngineeringHEX2BINConverts a hexadecimal number to binaryHEX2BIN(x[,places])
EngineeringHEX2DECConverts a hexadecimal number to decimalHEX2DEC(x)
EngineeringHEX2OCTConverts a hexadecimal number to octalHEX2OCT(x[,places])
EngineeringIMABSReturns the absolute value (modulus) of a complex numberIMABS(complexNumber)
EngineeringIMAGINARYReturns the imaginary coefficient of a complex numberIMAGINARY(complexNumber)
EngineeringIMARGUMENTReturns the argument theta, an angle expressed in radiansIMARGUMENT(complexNumber)
EngineeringIMCONJUGATEReturns the complex conjugate of a complex numberIMCONJUGATE(complexNumber)
EngineeringIMCOSReturns the cosine of a complex numberIMCOS(complexNumber)
EngineeringIMDIVReturns the quotient of two complex numbersIMDIV(complexDividend,complexDivisor)
EngineeringIMEXPReturns the exponential of a complex numberIMEXP(complexNumber)
EngineeringIMLNReturns the natural logarithm of a complex numberIMLN(complexNumber)
EngineeringIMLOG10Returns the base-10 logarithm of a complex numberIMLOG10(complexNumber)
EngineeringIMLOG2Returns the base-2 logarithm of a complex numberIMLOG2(complexNumber)
EngineeringIMPOWERReturns a complex number raised to an integer powerIMPOWER(complexNumber,realNumber)
EngineeringIMPRODUCTReturns the product of complex numbersIMPRODUCT(complexNumber[,complexNumber[,...]])
EngineeringIMREALReturns the real coefficient of a complex numberIMREAL(complexNumber)
EngineeringIMSINReturns the sine of a complex numberIMSIN(complexNumber)
EngineeringIMSQRTReturns the square root of a complex numberIMSQRT(complexNumber)
EngineeringIMSUBReturns the difference between two complex numbersIMSUB(complexNumber1,complexNumber2)
EngineeringIMSUMReturns the sum of complex numbersIMSUM(complexNumber[,complexNumber[,...]])
EngineeringOCT2BINConverts an octal number to binaryOCT2BIN(x[,places])
EngineeringOCT2DECConverts an octal number to decimalOCT2DEC(x)
EngineeringOCT2HEXConverts an octal number to hexadecimalOCT2HEX(x[,places])
FinancialACCRINTReturns the accrued interest for a security that pays periodic interestACCRINT(issue,firstinterest,settlement,rate,par,frequency[,basis])
FinancialACCRINTMReturns the accrued interest for a security that pays interest at maturityACCRINTM(issue,settlement,rate[,par[,basis]])
FinancialAMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientAMORDEGRC(cost,purchased,firstPeriod,salvage,period,rate[,basis])
FinancialAMORLINCReturns the depreciation for each accounting periodAMORLINC(cost,purchased,firstPeriod,salvage,period,rate[,basis])
FinancialCOUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateCOUPDAYBS(settlement,maturity,frequency[,basis])
FinancialCOUPDAYSReturns the number of days in the coupon period that contains the settlement dateCOUPDAYS(settlement,maturity,frequency[,basis])
FinancialCOUPDAYSNCReturns the number of days from the settlement date to the next coupon dateCOUPDAYSNC(settlement,maturity,frequency[,basis])
FinancialCOUPNCDReturns the next coupon date after the settlement dateCOUPNCD(settlement,maturity,frequency[,basis])
FinancialCOUPNUMReturns the number of coupons payable between the settlement date and maturity dateCOUPNUM(settlement,maturity,frequency[,basis])
FinancialCOUPPCDReturns the previous coupon date before the settlement dateCOUPPCD(settlement,maturity,frequency[,basis])
FinancialCUMIPMTReturns the cumulative interest paid between two periodsCUMIPMT(rate,nper,pv,start,end[,type])
FinancialCUMPRINCReturns the cumulative principal paid on a loan between two periodsCUMPRINC(rate,nper,pv,start,end[,type])
FinancialDBReturns the depreciation of an asset for a specified period by using the fixed-declining balance methodB(cost,salvage,life,period[,month])
FinancialDDBReturns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specifyDDB(cost,salvage,life,period[,factor])
FinancialDISCReturns the discount rate for a securityDISC(settlement,maturity,price,redemption[,basis])
FinancialDOLLARDEConverts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal numberDOLLARDE(fractional_dollar,fraction)
FinancialDOLLARFRConverts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fractionDOLLARFR(decimal_dollar,fraction)
FinancialEFFECTReturns the effective annual interest rateEFFECT(nominal_rate,npery)
FinancialFVReturns the future value of an investmentFV(rate,nper,pmt[,pv[,type]])
FinancialFVSCHEDULEReturns the future value of an initial principal after applying a series of compound interest ratesFVSCHEDULE(principal,schedule)
FinancialINTRATEReturns the interest rate for a fully invested securityINTRATE(settlement,maturity,investment,redemption[,basis])
FinancialIPMTReturns the interest payment for an investment for a given periodIPMT(rate,per,nper,pv[,fv][,type])
FinancialIRRReturns the internal rate of return for a series of cash flowsIRR(Array(values)[,guess])
FinancialISPMTCalculates the interest paid during a specific period of an investmentISPMT(interest_rate, period, number_payments, PV)
FinancialMIRRReturns the internal rate of return where positive and negative cash flows are financed at different ratesMIRR(values,finance_rate, reinvestment_rate)
FinancialNOMINALReturns the annual nominal interest rateNOMINAL(effect_rate, number_payments_per_year)
FinancialNPERReturns the number of periods for an investmentNPER(interest_rate, periodic_payment, present_value[,future_value,payment_type])
FinancialNPVReturns the net present value of an investment based on a series of periodic cash flows and a discount rateNPV(discount_rate, value1, [value2, ... value_n])
FinancialPMTReturns the periodic payment for an annuityPMT(interest_rate,number_of_periods,present_value[,future_value,payment_type])
FinancialPPMTReturns the payment on the principal for an investment for a given periodPPMT( interest_rate, period, number_payments, PV, [FV], [Type] )
FinancialPRICEReturns the price per $100 face value of a security that pays periodic interestPRICE(settlement, maturity, rate, yield, redemption, frequency, [basis ])
FinancialPRICEDISCReturns the price per $100 face value of a discounted securityPRICEDISC(settlement, maturity, discount, redemption, [basis])
FinancialPRICEMATReturns the price per $100 face value of a security that pays interest at maturityPRICEMAT(settlement, maturity, issue, rate, yield, [basis])
FinancialPVReturns the present value of an investmentPV( interest_rate, number_payments, payment, [FV], [Type] )
FinancialRATEReturns the interest rate per period of an annuityRATE(nper,pmt,pv[,fv[,type[,guess]]])
FinancialRECEIVEDReturns the amount received at maturity for a fully invested securityRECEIVED(settlement, maturity, investment, discount, [basis])
FinancialSLNReturns the straight-line depreciation of an asset for one periodSLN(cost, salvage, life)
FinancialSYDReturns the sum-of-years' digits depreciation of an asset for a specified periodSLN(cost, salvage, life, period)
FinancialTBILLEQReturns the bond-equivalent yield for a Treasury billTBILLEQ(settlement, maturity, discount)
FinancialTBILLPRICEReturns the price per $100 face value for a Treasury billTBILLPRICE(settlement, maturity, discount)
FinancialTBILLYIELDReturns the yield for a Treasury billTBILLYIELD(settlement, maturity, discount)
FinancialXIRRReturns the internal rate of return for a schedule of cash flows that is not necessarily periodicXIRR(Array(values),Array(dates)[,$guess])
FinancialXNPVReturns the net present value for a schedule of cash flows that is not necessarily periodicXNPV(rate,Array(values),Array(dates))
FinancialYIELDDISCReturns the annual yield for a discounted security; for example, a Treasury billYIELDDISC(settlement, maturity, price, redemption, basis)
FinancialYIELDMATReturns the annual yield of a security that pays interest at maturityYIELDMAT(settlement, maturity, issue, rate, price, basis)
InformationERROR.TYPEReturns a number corresponding to an error typeERROR.TYPE(value)
InformationISBLANKReturns TRUE if the value is blankISBLANK(value)
InformationISERRReturns TRUE if the value is any error value except #N/AISERR(value)
InformationISERRORReturns TRUE if the value is any error valueISERROR(value)
InformationISEVENReturns TRUE if the number is evenISEVEN(value)
InformationISLOGICALReturns TRUE if the value is a logical valueISLOGICAL(value)
InformationISNAReturns TRUE if the value is the #N/A error valueISNA(value)
InformationISNONTEXTReturns TRUE if the value is not textISNONTEXT(value)
InformationISNUMBERReturns TRUE if the value is a numberISNUMBER(value)
InformationISODDReturns TRUE if the number is oddISODD(value)
InformationISTEXTReturns TRUE if the value is textISTEXT(value)
InformationNReturns a value converted to a numberN(value)
InformationNAReturns the error value #N/ANA()
InformationTYPEReturns a number indicating the data type of a valueTYPE(value)
LogicalANDReturns TRUE if all of its arguments are TRUEAND(logical1[,logical2[, ...]])
LogicalFALSEReturns the logical value FALSEFALSE()
LogicalIFSpecifies a logical test to performIF(condition[,returnIfTrue[,returnIfFalse]])
LogicalIFERRORReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formulaIFERROR(testValue,errorpart)
LogicalNOTReverses the logic of its argumentNOT(logical)
LogicalORReturns TRUE if any argument is TRUEOR(logical1[,logical2[, ...]])
LogicalTRUEReturns the logical value TRUETRUE()
Math and trigonometrySQRTReturns a positive square rootSQRT(number)
Math and trigonometryABSReturns the absolute value of a numberABS(number)
Math and trigonometryACOSReturns the arccosine of a numberACOS(number)
Math and trigonometryACOSHReturns the inverse hyperbolic cosine of a numberACOSH(number)
Math and trigonometryASINReturns the arcsine of a numberASIN(number)
Math and trigonometryASINHReturns the inverse hyperbolic sine of a numberASINH(number)
Math and trigonometryATANReturns the arctangent of a numberATAN(number)
Math and trigonometryATAN2Returns the arctangent from x- and y-coordinatesATAN2(xCoordinate,yCoordinate)
Math and trigonometryATANHReturns the inverse hyperbolic tangent of a numberATANH(number)
Math and trigonometryCEILINGRounds a number to the nearest integer or to the nearest multiple of significanceCEILING(number[,significance])
Math and trigonometryCOMBINReturns the number of combinations for a given number of objectsCOMBIN(numObjs,numInSet)
Math and trigonometryCOSReturns the cosine of a numberCOS(number)
Math and trigonometryCOSHReturns the hyperbolic cosine of a numberCOSH(number)
Math and trigonometryDEGREESConverts radians to degreesDEGREES( radians )
Math and trigonometryEVENRounds a number up to the nearest even integerEVEN(number)
Math and trigonometryEXPReturns e raised to the power of a given numberEXP(number)
Math and trigonometryFACTReturns the factorial of a numberFACT(factVal)
Math and trigonometryFACTDOUBLEReturns the double factorial of a numberFACTDOUBLE(factVal)
Math and trigonometryFLOORRounds a number down, to the nearest integer or to the nearest multiple of significanceFLOOR(number[,significance])
Math and trigonometryGCDReturns the greatest common divisorGCD(number1[,number2[, ...]])
Math and trigonometryINTRounds a number down to the nearest integerINT(number)
Math and trigonometryLCMReturns the least common multipleLCM(number1[,number2[, ...]])
Math and trigonometryLNReturns the natural logarithm of a numberLN(number)
Math and trigonometryLOGReturns the logarithm of a number to a specified baseLOG(number[,base])
Math and trigonometryLOG10Returns the base-10 logarithm of a numberLOG10(number)
Math and trigonometryMDETERMReturns the matrix determinant of an arrayMDETERM(Array(values))
Math and trigonometryMINVERSEReturns the matrix inverse of an arrayMINVERSE(array)
Math and trigonometryMMULTReturns the matrix product of two arraysMMULT(Array(Values1), Array(Values2))
Math and trigonometryMODReturns the remainder from divisionMOD(number,divisor)
Math and trigonometryMROUNDReturns a number rounded to the desired multipleMROUND(number, multiple)
Math and trigonometryMULTINOMIALReturns the multinomial of a set of numbersMULTINOMIAL(array)
Math and trigonometryODDRounds a number up to the nearest odd integerODD(number)
Math and trigonometryPIReturns the value of piPI(number)
Math and trigonometryPOWERReturns the result of a number raised to a powerPOWER(number,power)
Math and trigonometryPRODUCTMultiplies its argumentsPRODUCT(value1[,value2[, ...]])
Math and trigonometryQUOTIENTReturns the integer portion of a divisionQUOTIENT(value1[,value2[, ...]])
Math and trigonometryRADIANSConverts degrees to radiansRADIANS(degrees)
Math and trigonometryRANDReturns a random number between 0 and 1RAND()
Math and trigonometryRANDBETWEENReturns a random number between the numbers you specifyRAND(number1,number2)
Math and trigonometryROMANConverts an arabic numeral to roman, as textROMAN(number,type)
Math and trigonometryROUNDRounds a number to a specified number of digitsROUND(number)
Math and trigonometryROUNDDOWNRounds a number down, toward zeroROUNDDOWN(number,digits)
Math and trigonometryROUNDUPRounds a number up, away from zeroROUNDUP(number,digits)
Math and trigonometrySERIESSUMReturns the sum of a power series based on the formulaSERIESSUM( x, n, m, coefficients )
Math and trigonometrySIGNReturns the sign of a numberSIGN(number)
Math and trigonometrySINReturns the sine of the given angleSIN(number)
Math and trigonometrySINHReturns the hyperbolic sine of a numberSINH(number)
Math and trigonometrySQRTPIReturns the square root of (number * pi)SQRTPI(number)
Math and trigonometrySUBTOTALReturns a subtotal in a list or databaseSUBTOTAL(method, range1, [range2, ... range_n])
Math and trigonometrySUMAdds its argumentsSUM(value1[,value2[, ...]])
Math and trigonometrySUMIFAdds the cells specified by a given criteriaSUMIF(value1[,value2[, ...]],condition)
Math and trigonometrySUMPRODUCTReturns the sum of the products of corresponding array componentsSUMPRODUCT(value1[,value2[, ...]])
Math and trigonometrySUMSQReturns the sum of the squares of the argumentsSUMSQ(value1[,value2[, ...]])
Math and trigonometrySUMX2MY2Returns the sum of the difference of squares of corresponding values in two arraysSUMX2MY2(Array(Values1), Array(Values2))
Math and trigonometrySUMX2PY2Returns the sum of the sum of squares of corresponding values in two arraysSUMX2PY2(Array(Values1), Array(Values2))
Math and trigonometrySUMXMY2Returns the sum of squares of differences of corresponding values in two arraysSUMXMY2(Array(Values1), Array(Values2))
Math and trigonometryTANReturns the tangent of a numberTAN(number)
Math and trigonometryTANHReturns the hyperbolic tangent of a numberTANH(number)
Math and trigonometryTRUNCTruncates a number to an integerTRUNC(number, [digits] )
StatisticalAVEDEVReturns the average of the absolute deviations of data points from their meanAVEDEV(value1[,value2[, ...]])
StatisticalAVERAGEReturns the average of its argumentsAVERAGE(value1[,value2[, ...]])
StatisticalAVERAGEAReturns the average of its arguments, including numbers, text, and logical valuesAVERAGEA(value1[,value2[, ...]])
StatisticalAVERAGEIFReturns the average (arithmetic mean) of all the cells in a range that meet a given criteriaAVERAGEIF(value1[,value2[, ...]],condition)
StatisticalBETADISTReturns the beta cumulative distribution functionBETADIST( x, alpha, beta, [lower_bound], [upper_bound] )
StatisticalBETAINVReturns the inverse of the cumulative distribution function for a specified beta distributionBETAINV( probability, alpha, beta, [lower_bound], [upper_bound] )
StatisticalBINOMDISTReturns the individual term binomial distribution probabilityBINOMDIST( number_success, number_trial, prob_success, cumulative )
StatisticalCONFIDENCEReturns the confidence interval for a population meanCONFIDENCE(alpha, standard_deviation, size)
StatisticalCORRELReturns the correlation coefficient between two data setsCORREL(Array(yValues), [Array(xValues)])
StatisticalCOUNTCounts how many numbers are in the list of argumentsCOUNT(value1[,value2[, ...]])
StatisticalCOUNTACounts how many values are in the list of argumentsCOUNTA(value1[,value2[, ...]])
StatisticalCOUNTBLANKCounts the number of blank cells within a rangeCOUNTBLANK(value1[,value2[, ...]])
StatisticalCOUNTIFCounts the number of cells within a range that meet the given criteriaCOUNTIF(value1[,value2[, ...]],condition)
StatisticalCOVARReturns covariance, the average of the products of paired deviationsCOVAR(Array(yValues), Array(xValues))
StatisticalDEVSQReturns the sum of squares of deviationsDEVSQ(value1[,value2[, ...]])
StatisticalEXPONDISTReturns the exponential distributionEXPONDIST(value, lambda, cumulative)
StatisticalFISHERReturns the Fisher transformationFISHER(value)
StatisticalFISHERINVReturns the inverse of the Fisher transformationFISHERINV(value)
StatisticalFORECASTReturns a value along a linear trend.FORECAST( x-value, Array(known_y_values), Array(known_x_values) )
StatisticalGAMMADISTReturns the gamma distributionGAMMADIST($value, a, b, cumulative)
StatisticalGAMMAINVReturns the inverse of the gamma cumulative distributionGAMMAINV(probability, alpha, beta)
StatisticalGAMMALNReturns the natural logarithm of the gamma function, Γ(x)GAMMALN(value)
StatisticalGEOMEANReturns the geometric meanGEOMEAN(value1[,value2[, ...]])
StatisticalGROWTHReturns values along an exponential trendGROWTH(Array(known_y_values), [Array(known_x_values)], [Array(new_x_values)], [constant] )
StatisticalHARMEANReturns the harmonic meanHARMEAN(value1[,value2[, ...]])
StatisticalHYPGEOMDISTReturns the hypergeometric distributionHYPGEOMDIST(sample_successes, sample_number, population_successes, population_number)
StatisticalINTERCEPTReturns the intercept of the linear regression lineINTERCEPT(Array(yValues), Array(xValues))
StatisticalKURTReturns the kurtosis of a data setKURT(array)
StatisticalLARGEReturns the k-th largest value in a data setLARGE(value1[,value2[, ...]],entry)
StatisticalLINESTReturns the parameters of a linear trendLINEST( yValues, [xValues], [constant], [additional_statistics] )
StatisticalLOGESTReturns the parameters of an exponential trendLOGEST( yValues, [xValues], [constant], [additional_statistics] )
StatisticalLOGNORMDISTReturns the cumulative lognormal distributionOGNORMDIST(value, mean, stdDev)
StatisticalMAXReturns the maximum value in a list of argumentsMAX(value1[,value2[, ...]])
StatisticalMAXAReturns the maximum value in a list of arguments, including numbers, text, and logical valuesMAXA(value1[,value2[, ...]])
StatisticalMEDIANReturns the median of the given numbersMEDIAN(value1[,value2[, ...]])
StatisticalMINReturns the minimum value in a list of argumentsMIN(value1[,value2[, ...]])
StatisticalMINAReturns the smallest value in a list of arguments, including numbers, text, and logical valuesMINA(value1[,value2[, ...]])
StatisticalMODEReturns the most common value in a data setMODE(value1[,value2[, ...]])
StatisticalNEGBINOMDISTReturns the negative binomial distributionNEGBINOMDIST(failures, successes, probability)
StatisticalNORMDISTReturns the normal cumulative distributionNORMDIST(value, mean, stdDev, cumulative)
StatisticalNORMINVReturns the inverse of the normal cumulative distributionNORMINV(probability, mean, stdDev)
StatisticalNORMSDISTReturns the standard normal cumulative distributionNORMSDIST(value)
StatisticalNORMSINVReturns the inverse of the standard normal cumulative distributionNORMSINV(value)
StatisticalPERCENTILEReturns the k-th percentile of values in a rangePERCENTILE(value1[,value2[, ...]],entry)
StatisticalPERCENTRANKReturns the percentage rank of a value in a data setPERCENTRANK(valueSet, value, [significance])
StatisticalPERMUTReturns the number of permutations for a given number of objectsPERMUT(number_objects, number_in_each_permutation)
StatisticalPOISSONReturns the Poisson distributionPOISSON(value, mean, cumulative)
StatisticalQUARTILEReturns the quartile of a data setQUARTILE(value1[,value2[, ...]],entry)
StatisticalRANKReturns the rank of a number in a list of numbersRANK( number, array, [order] )
StatisticalRSQReturns the square of the Pearson product moment correlation coefficientRSQ(Array(yValues), Array(xValues))
StatisticalSKEWReturns the skewness of a distributionSKEW(array)
StatisticalSLOPEReturns the slope of the linear regression lineSLOPE(Array(yValues), Array(xValues))
StatisticalSMALLReturns the k-th smallest value in a data setSMALL(value1[,value2[, ...]],entry)
StatisticalSTANDARDIZEReturns a normalized valueSTANDARDIZE(value, mean, stdDev)
StatisticalSTDEVPCalculates standard deviation based on the entire populationSTDEVP(value1[,value2[, ...]])
StatisticalSTDEVAEstimates standard deviation based on a sample, including numbers, text, and logical valuesSTDEVA(value1[,value2[, ...]])
StatisticalSTDEVPACalculates standard deviation based on the entire population, including numbers, text, and logical values STDEVPA(value1[,value2[, ...]])
StatisticalSTEYXReturns the standard error of the predicted y-value for each x in the regressionSTEYX(Array(yValues), Array(xValues))
StatisticalTDISTReturns the Percentage Points (probability) for the Student t-distributionTDIST(value, degrees, tails)
StatisticalTINVReturns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedomTINV(probability, degrees)
StatisticalTRENDReturns values along a linear trendTREND(Array(yValues), [Array(xValues), Array(new_values), logical_value])
StatisticalTRIMMEANReturns the mean of the interior of a data setTRIMEAN(value1[,value2[, ...]], $discard)
StatisticalVARPCalculates variance based on the entire populationVARP(value1[,value2[, ...]])
StatisticalVARAEstimates variance based on a sample, including numbers, text, and logical valuesVARA(value1[,value2[, ...]])
StatisticalVARPACalculates variance based on the entire population, including numbers, text, and logical valuesVARPA(value1[,value2[, ...]])
StatisticalWEIBULLReturns the Weibull distributionWEIBULL(value, alpha, beta, cumulative)
StatisticalZTESTReturns the one-tailed probability-value of a z-testZTEST(dataSet, m0, [sigma])
TextCHARReturns the character specified by the code numberCHAR(value)
TextCLEANRemoves all nonprintable characters from textCLEAN(value)
TextCODEReturns a numeric code for the first character in a text stringCODE(value)
TextCONCATENATEJoins several text items into one text itemCONCATENATE( text1, text2, ... text_n )
TextDOLLARConverts a number to text, using the $ (dollar) currency formatDOLLAR( number, [decimal_places] )
TextFINDFinds one text value within another (case-sensitive)FIND( substring, string, [start_position] )
TextFIXEDFormats a number as text with a fixed number of decimalsFIXED( number, [decimal_places], [no_commas] )
TextLEFTReturns the leftmost characters from a text valueLEFT( text, [number_of_characters] )
TextLENReturns the number of characters in a text stringLEN(text)
TextLOWERConverts text to lowercaseLOWER(text)
TextMIDReturns a specific number of characters from a text string starting at the position you specifyMID( text, start_position, number_of_characters )
TextPROPERCapitalizes the first letter in each word of a text valuePROPER(text)
TextREPLACEReplaces characters within textREPLACE( old_text, start, number_of_chars, new_text )
TextREPTRepeats text a given number of timesREPT( text, number )
TextRIGHTReturns the rightmost characters from a text valueRIGHT(text,number_of_chars)
TextSEARCHFinds one text value within another (not case-sensitive)SEARCH( substring, string, [start_position] )
TextSUBSTITUTESubstitutes new text for old text in a text stringSUBSTITUTE( text, old_text, new_text, [nth_appearance] )
TextTConverts its arguments to textT(text)
TextTEXTFormats a number and converts it to textTEXT(text,format)
TextTRIMRemoves spaces from textTRIM(text)
TextUPPERConverts text to uppercaseUPPER(text)
TextVALUEConverts a text argument to a numberVALUE(value)
Was this information helpful?