Chris Felkey posted on April 15, 2010 13:37
The following table contains MS Excel functions that are valid for use in Xcelsius.
|
ABS
|
DEVSQ
|
INDEX
|
NORMINV
|
STANDARDIZE
|
|
ACOS
|
DGET
|
INT
|
NORMSINV
|
STDEV
|
|
ACOSH
|
DIVIDE
|
INTERCEPT
|
NOT
|
SUM
|
|
AND
|
DMAX
|
IPMT
|
NOW
|
SUMIF
|
|
ASIN
|
DMIN
|
IRR
|
NPER
|
SUMPRODUCT
|
|
ASINH
|
DOLLAR
|
ISBLANK
|
NPV
|
SUMSQ
|
|
ASSIGN
|
DPRODUCT
|
ISNA
|
OFFSET
|
SUMX2MY2
|
|
ATAN
|
DSSTDEVP
|
ISNUMBER
|
OR
|
SUMX2PY2
|
|
ATAN2
|
DSTDEV
|
KURT
|
PI
|
SUMXMY2
|
|
ATANH
|
DSUM
|
LARGE
|
PMT
|
SYD
|
|
AVEDEV
|
DVAR
|
LE
|
POWER
|
TAN
|
|
AVERAGE
|
DVARP
|
LEFT
|
PPMT
|
TANH
|
|
AVERAGEA
|
EDATE
|
LEN
|
PRODUCT
|
TEXT
|
|
BETADIST
|
EOMONTH
|
LN
|
PV
|
TIME
|
|
CEILING
|
EVEN
|
LOG
|
QUOTIENT
|
TIMEVALUE
|
|
CHOOSE
|
EXACT
|
LOG10
|
RADIANS
|
TODAY
|
|
COMBIN
|
EXP
|
LOOKUP
|
RAND
|
TRUNC
|
|
CONCATENATE
|
EXPONDIST
|
LOWER
|
RANGE_COLON
|
UPPER
|
|
COS
|
FACT
|
MATCH
|
RANK
|
VALUE
|
|
COSH
|
FIND
|
MAX
|
RATE
|
VAR
|
|
COUNT
|
FISHER
|
MEDIAN
|
REPLACE
|
VDB
|
|
COUNTA
|
FISHERINV
|
MID
|
REPT
|
VLOOKUP
|
|
COUNTIF
|
FIXED
|
MIN
|
RIGHT
|
WEEKDAY
|
|
DATE
|
FLOOR
|
MINUS
|
ROUND
|
WEEKNUM
|
|
DATEVALUE
|
FORECAST
|
MINUTE
|
ROUNDDOWN
|
WORKDAY
|
|
DAVERAGE
|
FV
|
MIRR
|
ROUNDUP
|
YEAR
|
|
DAY
|
GE
|
MOD
|
SECOND
|
YEARFRAC
|
|
DAYS360
|
GEOMEAN
|
MODE
|
SIGN
|
FALSE
|
|
DB
|
GT
|
MONTH
|
SIN
|
TRUE
|
|
DCOUNT
|
HARMEAN
|
N
|
SINH
|
|
|
DCOUNTA
|
HLOOKUP
|
NE
|
SLN
|
|
|
DDB
|
HOUR
|
NETWORKDAYS
|
SMALL
|
|
|
DEGREES
|
IF
|
NORMDIST
|
SQRT
|
|
Avoid these functions.
While these functions are officially supported by Xcelsius; as a best practice we recommended that they not be used. These functions are known performance bottlenecks. If you find yourself in a situation where these must be used, try to limit them to small data sets (4 or less columns, by 50 or less rows) to mitigate the performance decrease.