Formula Functions

Spread WinRT provides these built-in functions, listed alphabetically.

ABS ACCRINT ACCRINTM
ACOS ACOSH ADDRESS
AMORDEGRC AMORLINC AND
ASIN ASINH ATAN
ATAN2 ATANH AVEDEV
AVERAGE AVERAGEA AVERAGEIF
AVERAGEIFS BESSELI BESSELJ
BESSELK BESSELY BETADIST
BETAINV BIN2DEC BIN2HEX
BIN2OCT BINOMDIST CEILING
CHAR CHIDIST CHIINV
CHITEST CHOOSE CLEAN
CODE COLUMN COLUMNS
COMBIN COMPLEX CONCATENATE
CONFIDENCE CONVERT CORREL
COS COSH COUNT
COUNTA COUNTBLANK COUNTIF
COUNTIFS COUPDAYBS COUPDAYS
COUPDAYSNC COUPNCD COUPNUM
COUPPCD COVAR CRITBINOM
CUMIPMT CUMPRINC  

DATE DATEDIF DATEVALUE
DAVERAGE DAY DAYS360
DB DCOUNT DCOUNTA
DDB DEC2BIN DEC2HEX
DEC2OCT DEGREES DELTA
DEVSQ DGET DISC
DMAX DMIN DOLLAR
DOLLARDE DOLLARFR DPRODUCT
DSTDEV DSTDEVP DSUM
DURATION DVAR DVARP
EDATE EFFECT EOMONTH
ERF ERFC ERROR.TYPE
EURO EUROCONVERT EVEN
EXACT EXP EXPONDIST

FACT FACTDOUBLE FALSE
FDIST FIND FINV
FISHER FISHERINV FIXED
FLOOR FORECAST FREQUENCY
FTEST FV FVSCHEDULE
GAMMADIST GAMMAINV GAMMALN
GCD GEOMEAN GESTEP
GROWTH HARMEAN HEX2BIN
HEX2DEC HEX2OCT HLOOKUP
HOUR HYPGEOMDIST  

IF IFERROR IMABS
IMAGINARY IMARGUMENT IMCONJUGATE
IMCOS IMDIV IMEXP
IMLN IMLOG2 IMLOG10
IMPOWER IMPRODUCT IMREAL
IMSIN IMSQRT IMSUB
IMSUM INDEX INT
INTERCEPT INTRATE IPMT
IRR ISBLANK ISERR
ISERROR ISEVEN ISLOGICAL
ISNA ISNONTEXT ISNUMBER
ISODD ISPMT ISREF
ISTEXT KURT LARGE
LCM LEFT LEN
LINEST LN LOG
LOG10 LOGEST LOGINV
LOGNORMDIST LOOKUP LOWER

MATCH MAX MAXA
MDETERM MDURATION MEDIAN
MID MIN MINA
MINUTE MINVERSE MIRR
MMULT MOD MODE
MONTH MROUND MULTINOMIAL
N NA NEGBINOMDIST
NETWORKDAYS NOMINAL NORMDIST
NORMINV NORMSDIST NORMSINV
NOT NOW NPER
NPV OCT2BIN OCT2DEC
OCT2HEX ODD ODDFPRICE
ODDFYIELD ODDLPRICE ODDLYIELD
OFFSET OR OFFSET
PEARSON PERCENTILE PERCENTRANK
PERMUT PI PMT
POISSON POWER PPMT
PRICE PRICEDISC PRICEMAT
PROB PRODUCT PROPER
PV QUARTILE QUOTIENT
RADIANS RAND RANDBETWEEN
RANK RATE RECEIVED
REPLACE REPT RIGHT
ROMAN ROUND ROUNDDOWN
ROUNDUP ROW ROWS
RSQ    
SEARCH SECOND SERIESSUM
SIGN SIN SINH
SKEW SLN SLOPE
SMALL SQRT SQRTPI
STANDARDIZE STDEV STDEVA
STDEVP STDEVPA STEYX
SUBSTITUTE SUBTOTAL SUM
SUMIF SUMIFS SUMPRODUCT
SUMSQ SUMX2MY2 SUMX2PY2
SUMXMY2 SYD T
TAN TANH TBILLEQ
TBILLPRICE TBILLYIELD TDIST
TEXT TIME TIMEVALUE
TINV TODAY TRANSPOSE
TREND TRIM TRIMMEAN
TRUE TRUNC TTEST
TYPE TTEST TYPE
UPPER VALUE VAR
VAR.P VAR.S VARA
VARP VARPA VDB
VLOOKUP WEEKDAY WEEKNUM
WEIBULL WORKDAY XIRR
XNPV YEAR YEARFRAC
YIELD YIELDDISC YIELDMAT
ZTEST    

 

 


Copyright © GrapeCity, inc. All rights reserved.