Supported Formula Functions
Here we list all ZK Spreadsheet supported functions in OSE and EE:
Date & Time
Function | OSE | EE |
---|---|---|
DATE | ||
DATEVALUE | ||
DAY | ||
DAYS360 | ||
EOMONTH | ||
HOUR | ||
MINUTE | ||
MONTH | ||
NETWORKDAYS | ||
NOW | ||
SECOND | ||
TIME | ||
TODAY | ||
WEEKDAY | ||
WORKDAY | ||
YEAR | ||
YEARFRAC |
Engineering
Function | OSE | EE |
---|---|---|
BESSELI |
|
|
BESSELJ |
|
|
BESSELK |
|
|
BESSELY |
|
|
BIN2DEC |
|
|
BIN2HEX |
|
|
BIN2OCT |
|
|
COMPLEX |
|
|
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
Function | OSE | EE |
---|---|---|
ACCRINT | ||
ACCRINTM | ||
AMORDEGRC | ||
AMORLINC | ||
COUPDAYBS | ||
COUPDAYS | ||
COUPDAYSNC | ||
COUPNCD | ||
COUPNUM | ||
COUPPCD | ||
CUMIPMT | ||
CUMPRINC | ||
DB | ||
DDB | ||
DISC | ||
DOLLARDE | ||
DOLLARFR | ||
DURATION | ||
EFFECT | ||
FV | ||
FVSCHEDULE | ||
INTRATE | ||
IPMT | ||
IRR | ||
NOMINAL | ||
NPER | ||
NPV | ||
PMT | ||
PPMT | ||
PRICE | ||
PRICEDISC | ||
PRICEMAT | ||
PV | ||
RATE | ||
RECEIVED | ||
SLN | ||
SYD | ||
TBILLEQ | ||
TBILLPRICE | ||
TBILLYIELD | ||
XNPV | ||
YIELD | ||
YIELDDISC | ||
YIELDMAT |
Info
Function | OSE | EE |
---|---|---|
ERROR.TYPE |
|
|
ISBLANK |
|
|
ISERR |
|
|
ISERROR |
|
|
ISEVEN |
|
|
ISLOGICAL |
|
|
ISNA |
|
|
ISNONTEXT |
|
|
ISNUMBER |
|
|
ISODD |
|
|
ISREF |
|
|
ISTEXT |
|
|
N |
|
|
NA |
|
|
TYPE |
|
|
Logical
Function | OSE | EE |
---|---|---|
AND |
|
|
FALSE |
|
|
IF |
|
|
IFERROR |
|
|
NOT |
|
|
OR |
|
|
TRUE |
|
|
Lookup & Reference
Function | OSE | EE |
---|---|---|
ADDRESS |
|
|
CHOOSE |
|
|
COLUMN |
|
|
COLUMNS |
|
|
HLOOKUP |
|
|
HYPERLINK |
|
|
INDEX |
|
|
INDIRECT |
|
|
LOOKUP |
|
|
MATCH |
|
|
OFFSET |
|
|
ROW |
|
|
ROWS |
|
|
VLOOKUP |
|
|
Mathematical
Function | OSE | EE |
---|---|---|
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 | ||
SIGN | ||
SIN | ||
SINH | ||
SQRT | ||
SQRTPI | ||
SUBTOTAL | ||
SUM | ||
SUMIF | ||
SUMIFS | ||
SUMPRODUCT | ||
SUMSQ | ||
SUMX2MY2 | ||
SUMX2PY2 | ||
SUMXMY2 | ||
TAN | ||
TANH | ||
TRUNC |
SUMPRODUCT
since 3.7.0
You can specify a condition for an array formula to just calculate partial cells in a given range. For example,
=SUMPRODUCT(--(A1:A3="John"),(B1:B3),(C1:C3))
or simpler
=SUMPRODUCT((F12:F21=1)*(G12:G21="Z")*H12:H21)
Statistical
Function | New Name since Excel 2010 | OSE | EE |
---|---|---|---|
AVEDEV | - | ||
AVERAGE | - | ||
AVERAGEA | - | ||
BETADIST | BETA.DIST | ||
BETAINV | BETA.INV | ||
BINOMDIST | BINOM.DIST | ||
CORREL | |||
CRITBINOM | BINOM.INV | ||
CHIDIST | CHISQ.DIST.RT | ||
CHIINV | CHISQ.INV.RT | ||
- | CHISQ.DIST | ||
- | CHISQ.INV | ||
COUNT | - | ||
COUNTA | - | ||
COUNTBLANK | - | ||
COUNTIF | - | ||
DEVSQ | - | ||
EXPONDIST | EXPON.DIST | ||
FDIST | F.DIST.RT | ||
FINV | F.INV.RT | ||
GAMMADIST | GAMMA.DIST | ||
GAMMAINV | GAMMA.INV | ||
GAMMALN | - | ||
GEOMEAN | - | ||
HARMEAN | - | ||
HYPGEOMDIST | HYPGEOM.DIST | ||
KURT | - | ||
LARGE | - | ||
MAX | - | ||
MAXA | - | ||
MEDIAN | - | ||
MIN | - | ||
MINA | - | ||
MODE | MODE.SNGL | ||
NEGBINOMDIST | NEGBINOM.DIST | ||
NORMDIST | NORM.DIST | ||
NORMINV | NORM.INV | ||
NORMSDIST | NORM.S.DIST | ||
NORMSINV | NORM.S.INV | ||
LOGNORMDIST | LOGNORM.DIST | ||
LOGINV | LOGNORM.INV | ||
POISSON | POISSON.DIST | ||
RANK | RANK.EQ | ||
SKEW | - | ||
SLOPE | - | ||
SMALL | - | ||
STDEV | STDE.V | ||
- | T.DIST.2T | ||
TDIST | T.DIST.RT | ||
TINV | T.INV.2T | ||
VAR | VAR.S | ||
VARP | VAR.P | ||
WEIBULL | WEIBULL.DIST |
- Microsoft change some statistical function names since Excel 2010, ZSS supports both function names listed above.
Text
Function | OSE | EE |
---|---|---|
CHAR | ||
CLEAN | ||
CODE | ||
CONCATENATE | ||
DOLLAR | ||
EXACT | ||
FIND | ||
FIXED | ||
LEFT | ||
LEN | ||
LOWER | ||
MID | ||
PROPER | ||
REPLACE | ||
REPT | ||
RIGHT | ||
SEARCH | ||
SUBSTITUTE | ||
T | ||
TEXT | ||
TRIM | ||
UPPER | ||
VALUE |
Not Supported Functions
ZSS doesn't support Cube, Database, and Web functions.
For current open issues that supported functions have, please refer to our tracker.
All source code listed in this book is at Github.