Supported Formula Functions"
(→Text: correct OSE supported function) |
|||
Line 1,062: | Line 1,062: | ||
|- | |- | ||
! style="width:60%"| '''Function''' | ! style="width:60%"| '''Function''' | ||
− | |||
!style="width:20%;"| '''OSE''' | !style="width:20%;"| '''OSE''' | ||
− | |||
!style="width:20%"| '''EE''' | !style="width:20%"| '''EE''' | ||
− | |||
|- | |- | ||
− | | | + | |ABS |
− | ABS | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ACOS |
− | ACOS | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ACOSH |
− | ACOSH | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ASIN |
− | ASIN | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ASINH |
− | ASINH | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ATAN |
− | ATAN | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ATAN2 |
− | ATAN2 | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ATANH |
− | ATANH | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |CEILING |
− | CEILING | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |COMBIN |
− | COMBIN | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |COS |
− | COS | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |COSH |
− | COSH | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |DEGREES |
− | DEGREES | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |EVEN |
− | EVEN | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |EXP |
− | EXP | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |FACT |
− | FACT | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |FACTDOUBLE |
− | FACTDOUBLE | + | |<center></center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |FLOOR |
− | FLOOR | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |GCD |
− | GCD | + | |<center></center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |INT |
− | INT | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |LCM |
− | LCM | + | |<center></center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |LN |
− | LN | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |LOG |
− | LOG | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |LOG10 |
− | LOG10 | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |MDETERM |
− | MDETERM | + | |<center></center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |MINVERSE |
− | MINVERSE | + | |<center></center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |MMULT |
− | MMULT | + | |<center></center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |MOD |
− | MOD | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |MROUND |
− | MROUND | + | |<center></center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |MULTINOMIAL |
− | MULTINOMIAL | + | |<center></center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ODD |
− | ODD | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |PI |
− | PI | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |POWER |
− | POWER | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |PRODUCT |
− | PRODUCT | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |QUOTIENT |
− | QUOTIENT | + | |<center></center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |RADIANS |
− | RADIANS | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |RAND |
− | RAND | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |RANDBETWEEN |
− | RANDBETWEEN | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ROMAN |
− | ROMAN | + | |<center></center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ROUND |
− | ROUND | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ROUNDDOWN |
− | ROUNDDOWN | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ROUNDUP |
− | ROUNDUP | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SIGN |
− | SIGN | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SIN |
− | SIN | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SINH |
− | SINH | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SQRT |
− | SQRT | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SQRTPI |
− | SQRTPI | + | |<center></center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SUBTOTAL |
− | SUBTOTAL | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SUM |
− | SUM | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SUMIF |
− | SUMIF | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SUMIFS |
− | SUMIFS | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SUMPRODUCT |
− | SUMPRODUCT | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SUMSQ |
− | SUMSQ | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SUMX2MY2 |
− | SUMX2MY2 | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SUMX2PY2 |
− | SUMX2PY2 | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |SUMXMY2 |
− | SUMXMY2 | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |TAN |
− | TAN | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |TANH |
− | TANH | + | |<center>Y</center> |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |TRUNC |
− | + | |<center>Y</center> | |
+ | |<center>Y</center> | ||
+ | |} | ||
− | + | == Details == | |
− | < | + | === SUMPRODUCT === |
+ | <!-- ZSS-852 --> | ||
+ | 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 = | = Statistical = |
Revision as of 04:37, 20 August 2015
Here we list all ZK Spreadsheet supported functions in OSE and EE:
Date & Time
Function | OSE | EE |
---|---|---|
DATE | ||
DATEVALUE | ||
DAY | ||
DAYS360 | ||
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 |
Details
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 | OSE | EE |
---|---|---|
AVEDEV | ||
AVERAGE | ||
AVERAGEA | ||
BINOMDIST | ||
CHIDIST | ||
CHIINV | ||
COUNT | ||
COUNTA | ||
COUNTBLANK | ||
COUNTIF | ||
DEVSQ | ||
EXPONDIST | ||
FDIST | ||
FINV | ||
GAMMADIST | ||
GAMMAINV | ||
GAMMALN | ||
GEOMEAN | ||
HARMEAN | ||
HYPGEOMDIST | ||
KURT | ||
LARGE | ||
MAX | ||
MAXA | ||
MEDIAN | ||
MIN | ||
MINA | ||
MODE | ||
NORMDIST | ||
POISSON | ||
RANK | ||
SKEW | ||
SLOPE | ||
SMALL | ||
STDEV | ||
TDIST | ||
TINV | ||
VAR | ||
VARP | ||
WEIBULL |
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 |
- For current open issues that supported functions have, please refer to our tracker.