next up previous contents index
Next: A. Function Reference Up: 4. Built-in Functions Previous: 4.13 Computed Cell References   Contents   Index

4.14 Compatibility with Microsoft Excel Functions

Many SpreadScript functions are compatible with functions in Microsoft Excel. In most cases, the compatible functions have the same name in both SpreadScript and Excel; e.g., ``SUM().'' In a few cases, the Excel and SpreadScript functions with the same name behave differently. For example, the Excel ``IPMT()'' function returns a negative value, while the SpreadScript ``IPMT()'' function returns a positive value (of the same magnitude). When there is such a name conflict, SpreadScript provides an equivalent Excel-compatible function by prefixing the function name with ``XL.'' For example, the SpreadScript ``XLIPMT()'' function provides compatibility with the Excel version of ``IPMT().'' When SpreadScript is operating in Excel compatibility mode (see Section 3.2.1), the ``XL'' prefix is not used as the Excel-compatible version of the function will be used automatically.

Table 4.2 lists alphabetically the functions in Excel which are compatible with functions in SpreadScript. Functions not in this table should not be used when developing SpreadScript applications that are designed to be compatible with Excel. Excel compatibility is also listed for each function in the Quick Reference Guide (Section 4.11) and the detailed function reference manual in Appendix A.


Table 4.2: Excel functions which are compatible with SpreadScript
ABS INT (XLINT) RAND
ACOS IPMT (XLIPMT) RANK
ACOSH ISERR REPLACE (XLREPLACE)
AND (XLAND) ISERROR REPT
ASIN ISNUMBER RIGHT
ASINH ISTEXT ROUND
ATAN LARGE ROW
ATAN2 LEFT ROWS
ATANH LEN SECOND
AVERAGE LN SIN
CEILING (XLCEILING) LOG SINH
CHAR LOG10 SLN
CHOOSE (XLCHOOSE) LOWER SMALL
CLEAN MATCH SQRT
CODE MAX STANDARDIZE
COLUMN MEDIAN STDEV
COLUMNS MID (XLMID) STDEVP
CONCATENATE MIN SUM
CONFIDENCE MINUTE SUMPRODUCT
CORREL MIRR SYD
COS MOD (XLMOD) TAN
COSH MODE TANH
COUNT MONTH TIME
DATE NA TIMEVALUE
DATEVALUE NORMDIST TODAY
DAY NORMINV TRANSPOSE
DAYS360 NORMSDIST TRIM
EXACT NORMSINV TRUE
EXP NOT (XLNOT) TRUNC
FACT NOW UPPER
FALSE OR (XLOR) VALUE
FLOOR (XLFLOOR) PERCENTILE VAR (XLVAR)
FREQUENCY PERCENTRANK VARP
GEOMEAN PERMUT VLOOKUP (XLVLOOKUP)
HARMEAN PI YEAR
HLOOKUP (XLHLOOKUP) PRODUCT ZTEST
HOUR PROPER
IF QUARTILE



next up previous contents index
Next: A. Function Reference Up: 4. Built-in Functions Previous: 4.13 Computed Cell References   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003