Learning SAP BusinessObjects Dashboards

Appendix A. References

Supported excel functions

A ABS ACOS ACOSH AND ASIN ASINH ASSIGN ATAN ATAN2 ATANH AVEDEV AVERAGE AVERAGEA AVERAGEIF B BETADIST C CEILING CHOOSE MODE MONTH N NE NETWORKDAYS NORMDIST NORMINV NORMSINV NOT NOW NPER NPV O ODD OFFSET OR

COMBIN CONCATENATE COS COSH COUNT COUNTA D DATE DATEVALUE DAVERAGE DAY DAYS360 DB DCOUNT DSTDEV DSTDEVP DSUM DVAR DVARP P PI PMT POWER PPMT PRODUCT PV Q QUARTILE QUOTIENT R RADIANS RAND RANGE_COLON RANK RATE

E EDATE EFFECT EOMONTH EVEN EXACT EXP EXPONDIST G GE GEOMEAN GT H HARMEAN HLOOKUP HOUR I IF INDEX REPLACE REPT RIGHT ROUND ROUNDDOWN ROUNDUP S SECOND SIGN SIN STDEV UM SUMIF SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2

I IF INDEX INT IPMT IRR ISBLANK ISERR ISERROR