Built-in functions in ZSS 1.0.0 RC1 Following functions are compatible with EXCEL , Detail information , you can refer to http://office.microsoft.com/en-us/excel/HP052042111033.aspx Date and time functions: DATE DATEVALUE DAY DAYS360 HOUR MINUTE MONTH NOW SECOND TIME TODAY WEEKDAY YEAR YEARFRAC Engineering functions: BESSELI BESSELJ BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT COMPLEX CONVERT DEC2BIN DEC2HEX DEC2OCT DELTA ERF ERFC GESTEP HEX2BIN HEX2DEC HEX2OCT IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSIN IMSQRT IMSUB IMSUM OCT2BIN OCT2DEC OCT2HEX Financial functions: ACCRINT ACCRINTM AMORDEGRC AMORLINC COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMPRINC DB DDB DISC DOLLARDE DOLLARFR DURATION EFFECT FV FVSCHEDULE INTRATE IPMT NOMINAL NPER NPV PMT PPMT PRICE PRICEDISC PRICEMAT PV RECEIVED SLN SYD TBILLEQ TBILLPRICE TBILLYIELD XNPV YIELD YIELDDISC YIELDMAT Information functions: ERROR.TYPE ISBLANK ISERR ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISTEXT N NA TYPE Logical functions: AND FALSE IF NOT OR TRUE Math and trigonometry functions: ABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING COMBIN COS COSH DEGREES EVEN EXP FACT FACTDOUBLE FLOOR GCD INT LCM LN LOG LOG10 MDETERM MINVERSE MMULT MOD MROUND MULTINOMIAL ODD PI POWER PRODUCT QUOTIENT RADIANS RAND RANDBETWEEN ROMAN ROUND ROUNDDOWN ROUNDUP SERIESSUM SIGN SIN SINH SQRT SQRTPI SUBTOTAL SUM SUMIF SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TAN TANH TRUNC Statistical functions AVEDEV AVERAGE AVERAGEA CHIDIST CHIINV COUNT COUNTA EXPONDIST FDIST FINV GAMMADIST GAMMAINV GAMMALN GEOMEAN HARMEAN HYPGEOMDIST KURT MAX MIN NORMDIST NORMSDIST POISSON SKEW SLOPE STDEV STDEVP TDIST TINV VAR WEIBULL Text functions: CHAR CODE CONCATENATE DOLLAR EXACT FIND FIXED LEFT LEN LOWER MID PROPER REPLACE REPT RIGHT SEARCH SUBSTITUTE T TEXT TRIM UPPER