SAP Knowledge Base Article - Public

1300927 - What are the supported excel functions in Xcelsius 2008?

Symptom

  • What is the list of supported Excel functions in Xcelsius?

Reproducing the Issue

  • Xcelsius 2008

Resolution

List of the Microsoft Excel functions that Xcelsius 2008 supports:

  • ABS
  • ACOS
  • ACOSH
  • AND
  • ASIN
  • ASINH
  • ASSIGN
  • ATAN
  • ATAN2
  • ATANH
  • AVEDEV
  • AVERAGE
  • AVERAGEA
  • BETADIST
  • CEILING
  • CHOOSE
  • COMBIN
  • CONCATENATE
  • COS
  • COSH
  • COUNT
  • COUNTA
  • COUNTIF
  • DATE
  • DATEVALUE
  • DAVERAGE
  • DAY
  • DAYS360
  • DB
  • DCOUNT
  • DCOUNTA
  • DDB
  • DEGREES
  • DEVSQ
  • DGET
  • DIVIDE
  • DMAX
  • DMIN
  • DOLLAR
  • DPRODUCT
  • DSTDEV
  • DSSTDEVP
  • DSUM
  • DVAR
  • DVARP
  • EDATE
  • EOMONTH
  • EVEN
  • EXACT
  • EXP
  • EXPONDIST
  • FACT
  • FALSE
  • FIND
  • FISHER
  • FISHERINV
  • FIXED
  • FLOOR
  • FORECAST
  • FV
  • GE
  • GEOMEAN
  • GT
  • HARMEAN
  • HLOOKUP
  • HOUR
  • IF
  • INDEX
  • INT
  • INTERCEPT
  • IPMT
  • IRR
  • ISBLANK
  • ISNA
  • ISNUMBER
  • KURT
  • LARGE
  • LE
  • LEFT
  • LEN
  • LN
  • LOG
  • LOG10
  • LOOKUP
  • LOWER
  • MATCH
  • MAX
  • MEDIAN
  • MID
  • MIN
  • MINUS
  • MINUTE
  • MIRR
  • MOD
  • MODE
  • MONTH
  • N
  • NE
  • NETWORKDAYS
  • NORMDIST
  • NORMINV
  • NORMSINV
  • NOT
  • NOW
  • NPER
  • NPV
  • OFFSET
  • OR
  • PI
  • PMT
  • POWER
  • PPMT
  • PRODUCT
  • PV
  • QUOTIENT
  • RADIANS
  • RAND
  • RANGE_COLON
  • RANK
  • RATE
  • REPLACE
  • REPT
  • RIGHT
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • SECOND
  • SIGN
  • SIN
  • SINH
  • SLN
  • SMALL
  • SQRT
  • STANDARDIZE
  • STDEV
  • SUM
  • SUMIF
  • SUMPRODUCT
  • SUMSQ
  • SUMX2MY2
  • SUMX2PY2
  • SUMXMY2
  • SYD
  • TAN
  • TANH
  • TEXT
  • TIME
  • TIMEVALUE
  • TODAY
  • TRUE
  • TRUNC
  • UPPER
  • VALUE
  • VAR
  • VDB
  • VLOOKUP
  • WEEKDAY
  • WEEKNUM
  • WORKDAY
  • YEAR
  • YEARFRAC

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Xcelsius Enterprise 2008