Supported Formula Functions"
(→Date & Time: correct OSE supported function upon https://docs.google.com/a/potix.com/spreadsheet/ccc?key=0AioZiMi7jA5DdGQwVDljbXhQcFJWcGNaUm5iZFVRQ2c&usp=drive_web#gid=7) |
|||
Line 474: | Line 474: | ||
= Financial = | = Financial = | ||
− | {| border="2" style="width:50%;" | + | {| border="2" style="width:50%;" |- |
− | |- | ||
! style="width:60%"| '''Function''' | ! style="width:60%"| '''Function''' | ||
− | |||
!style="width:20%;"| '''OSE''' | !style="width:20%;"| '''OSE''' | ||
− | |||
!style="width:20%"| '''EE''' | !style="width:20%"| '''EE''' | ||
− | |||
|- | |- | ||
− | | | + | | ACCRINT |
− | ACCRINT | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | ACCRINTM |
− | ACCRINTM | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | AMORDEGRC |
− | AMORDEGRC | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | AMORLINC |
− | AMORLINC | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | COUPDAYBS |
− | COUPDAYBS | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | COUPDAYS |
− | COUPDAYS | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | COUPDAYSNC |
− | COUPDAYSNC | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | COUPNCD |
− | COUPNCD | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | COUPNUM |
− | COUPNUM | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | COUPPCD |
− | COUPPCD | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | CUMIPMT |
− | CUMIPMT | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | CUMPRINC |
− | CUMPRINC | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | DB |
− | DB | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | DDB |
− | DDB | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | DISC |
− | DISC | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | DOLLARDE |
− | DOLLARDE | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | DOLLARFR |
− | DOLLARFR | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | DURATION |
− | DURATION | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | EFFECT |
− | EFFECT | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | FV |
− | FV | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | FVSCHEDULE |
− | FVSCHEDULE | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | INTRATE |
− | INTRATE | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | IPMT |
− | IPMT | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | IRR |
− | IRR | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | NOMINAL |
− | NOMINAL | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | NPER |
− | NPER | + | | <center>Y</center> |
− | |||
− | | | ||
− | |||
− | |||
− | |||
− | <center>Y</center> | ||
+ | | <center>Y</center> | ||
|- | |- | ||
− | | | + | | NPV |
− | NPV | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | PMT |
− | PMT | + | | <center>Y</center> |
− | |||
− | | | ||
− | |||
− | |||
− | |||
− | <center>Y</center> | ||
+ | | <center>Y</center> | ||
|- | |- | ||
− | | | + | | PPMT |
− | PPMT | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | PRICE |
− | PRICE | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | PRICEDISC |
− | PRICEDISC | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | PRICEMAT |
− | PRICEMAT | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | PV |
− | PV | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | RATE |
− | RATE | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | RECEIVED |
− | RECEIVED | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | SLN |
− | SLN | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | SYD |
− | SYD | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | TBILLEQ |
− | TBILLEQ | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | TBILLPRICE |
− | TBILLPRICE | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | TBILLYIELD |
− | TBILLYIELD | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | XNPV |
− | XNPV | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | YIELD |
− | YIELD | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | YIELDDISC |
− | YIELDDISC | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | YIELDMAT |
− | YIELDMAT | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|} | |} | ||
− | |||
− | |||
− | |||
= Info = | = Info = |
Revision as of 01:54, 9 January 2014
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 |
|
|
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.