Supported Formula Functions"
(Created page with "{{ZKSpreadsheetEssentials3PageHeader}} Here we list all ZK Spreadsheet supported functions in OSE and EE: = Date & Time = {| border="2" style="width:50%;" |- ! style="width...") |
|||
(18 intermediate revisions by the same user not shown) | |||
Line 14: | Line 14: | ||
|- | |- | ||
− | | | + | | DATE |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | + | |- |
− | <center>Y</center> | + | | DATEVALUE |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | | DAY | |
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | DAYS360 | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | EOMONTH | ||
+ | | <center> </center> | ||
+ | | <center>Y</center> | ||
|- | |- | ||
− | | | + | | HOUR |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | MINUTE |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | MONTH |
− | + | | <center>Y</center> | |
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | NETWORKDAYS | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | NOW | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | SECOND | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | TIME | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | TODAY | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | WEEKDAY | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | WORKDAY | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | YEAR | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | YEARFRAC | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |} | ||
+ | |||
+ | = Engineering = | ||
+ | {| border="2" style="width:50%;" | ||
+ | |- | ||
+ | ! style="width:60%"| '''Function''' | ||
− | | | + | !style="width:20%;"| '''OSE''' |
− | |||
− | | | + | !style="width:20%"| '''EE''' |
− | |||
|- | |- | ||
| | | | ||
− | + | BESSELI | |
| | | | ||
− | + | | |
| | | | ||
Line 65: | Line 104: | ||
|- | |- | ||
| | | | ||
− | + | BESSELJ | |
| | | | ||
− | + | | |
| | | | ||
Line 75: | Line 114: | ||
|- | |- | ||
| | | | ||
− | + | BESSELK | |
| | | | ||
− | + | | |
| | | | ||
Line 85: | Line 124: | ||
|- | |- | ||
| | | | ||
− | + | BESSELY | |
| | | | ||
− | + | | |
| | | | ||
Line 95: | Line 134: | ||
|- | |- | ||
| | | | ||
− | + | BIN2DEC | |
| | | | ||
− | + | | |
| | | | ||
Line 105: | Line 144: | ||
|- | |- | ||
| | | | ||
− | + | BIN2HEX | |
| | | | ||
− | + | | |
| | | | ||
Line 115: | Line 154: | ||
|- | |- | ||
| | | | ||
− | + | BIN2OCT | |
| | | | ||
− | + | | |
| | | | ||
Line 125: | Line 164: | ||
|- | |- | ||
| | | | ||
− | + | COMPLEX | |
| | | | ||
− | + | | |
| | | | ||
Line 135: | Line 174: | ||
|- | |- | ||
| | | | ||
− | + | DEC2BIN | |
| | | | ||
− | + | | |
| | | | ||
Line 145: | Line 184: | ||
|- | |- | ||
| | | | ||
− | + | DEC2HEX | |
| | | | ||
− | + | | |
| | | | ||
Line 155: | Line 194: | ||
|- | |- | ||
| | | | ||
− | + | DEC2OCT | |
| | | | ||
− | + | | |
| | | | ||
Line 165: | Line 204: | ||
|- | |- | ||
| | | | ||
− | + | DELTA | |
| | | | ||
− | + | | |
| | | | ||
<center>Y</center> | <center>Y</center> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
| | | | ||
− | + | ERF | |
| | | | ||
Line 198: | Line 224: | ||
|- | |- | ||
| | | | ||
− | + | ERFC | |
| | | | ||
Line 208: | Line 234: | ||
|- | |- | ||
| | | | ||
− | + | GESTEP | |
| | | | ||
Line 218: | Line 244: | ||
|- | |- | ||
| | | | ||
− | + | HEX2BIN | |
| | | | ||
Line 228: | Line 254: | ||
|- | |- | ||
| | | | ||
− | + | HEX2DEC | |
| | | | ||
Line 238: | Line 264: | ||
|- | |- | ||
| | | | ||
− | + | HEX2OCT | |
| | | | ||
Line 248: | Line 274: | ||
|- | |- | ||
| | | | ||
− | + | IMABS | |
| | | | ||
Line 258: | Line 284: | ||
|- | |- | ||
| | | | ||
− | + | IMAGINARY | |
| | | | ||
Line 268: | Line 294: | ||
|- | |- | ||
| | | | ||
− | + | IMARGUMENT | |
| | | | ||
Line 278: | Line 304: | ||
|- | |- | ||
| | | | ||
− | + | IMCONJUGATE | |
| | | | ||
Line 288: | Line 314: | ||
|- | |- | ||
| | | | ||
− | + | IMCOS | |
| | | | ||
Line 298: | Line 324: | ||
|- | |- | ||
| | | | ||
− | + | IMDIV | |
| | | | ||
Line 308: | Line 334: | ||
|- | |- | ||
| | | | ||
− | + | IMEXP | |
| | | | ||
Line 318: | Line 344: | ||
|- | |- | ||
| | | | ||
− | + | IMLN | |
| | | | ||
Line 328: | Line 354: | ||
|- | |- | ||
| | | | ||
− | + | IMLOG10 | |
| | | | ||
Line 338: | Line 364: | ||
|- | |- | ||
| | | | ||
− | + | IMLOG2 | |
| | | | ||
Line 348: | Line 374: | ||
|- | |- | ||
| | | | ||
− | + | IMPOWER | |
| | | | ||
Line 358: | Line 384: | ||
|- | |- | ||
| | | | ||
− | + | IMPRODUCT | |
| | | | ||
Line 368: | Line 394: | ||
|- | |- | ||
| | | | ||
− | + | IMREAL | |
| | | | ||
Line 378: | Line 404: | ||
|- | |- | ||
| | | | ||
− | + | IMSIN | |
| | | | ||
Line 388: | Line 414: | ||
|- | |- | ||
| | | | ||
− | + | IMSQRT | |
| | | | ||
Line 398: | Line 424: | ||
|- | |- | ||
| | | | ||
− | + | IMSUB | |
| | | | ||
Line 408: | Line 434: | ||
|- | |- | ||
| | | | ||
− | + | IMSUM | |
| | | | ||
Line 418: | Line 444: | ||
|- | |- | ||
| | | | ||
− | + | OCT2BIN | |
| | | | ||
Line 428: | Line 454: | ||
|- | |- | ||
| | | | ||
− | + | OCT2DEC | |
| | | | ||
Line 438: | Line 464: | ||
|- | |- | ||
| | | | ||
− | + | OCT2HEX | |
| | | | ||
Line 446: | Line 472: | ||
<center>Y</center> | <center>Y</center> | ||
− | | | + | |} |
− | + | ||
− | |||
− | |||
− | |||
− | + | = Financial = | |
− | |||
+ | {| border="2" style="width:50%;" |- | ||
+ | ! style="width:60%"| '''Function''' | ||
+ | !style="width:20%;"| '''OSE''' | ||
+ | !style="width:20%"| '''EE''' | ||
|- | |- | ||
− | | | + | | ACCRINT |
− | + | | <center></center> | |
− | + | | <center>Y</center> | |
− | | | + | |- |
− | + | | ACCRINTM | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | | AMORDEGRC | |
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | AMORLINC | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
|- | |- | ||
− | | | + | | COUPDAYBS |
− | + | | <center></center> | |
− | + | | <center>Y</center> | |
− | | | ||
− | |||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | COUPDAYS |
− | + | | <center></center> | |
− | + | | <center>Y</center> | |
− | | | ||
− | |||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | COUPDAYSNC |
− | + | | <center></center> | |
− | + | | <center>Y</center> | |
− | | | + | |- |
− | + | | COUPNCD | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | + | |- |
+ | | COUPNUM | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | COUPPCD | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | CUMIPMT | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | CUMPRINC | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | DB | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | DDB | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | DISC | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | DOLLARDE | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | DOLLARFR | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | DURATION | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | EFFECT | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | FV | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | FVSCHEDULE | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | INTRATE | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | IPMT | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | IRR | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | NOMINAL | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | NPER | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | NPV | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
|- | |- | ||
− | | | + | | PMT |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | + | |- | |
+ | | PPMT | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | PRICE | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | PRICEDISC | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | PRICEMAT | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | PV | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | RATE | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | RECEIVED | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | SLN | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | SYD | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | TBILLEQ | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | TBILLPRICE | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | TBILLYIELD | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | XNPV | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | YIELD | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | YIELDDISC | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | YIELDMAT | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |} | ||
− | + | = Info = | |
− | |||
+ | {| border="2" style="width:50%;" | ||
|- | |- | ||
− | | | + | ! style="width:60%"| '''Function''' |
− | |||
− | | | + | !style="width:20%;"| '''OSE''' |
− | |||
− | | | + | !style="width:20%"| '''EE''' |
− | |||
|- | |- | ||
| | | | ||
− | + | ERROR.TYPE | |
| | | | ||
− | + | <center>Y</center> | |
| | | | ||
Line 528: | Line 684: | ||
|- | |- | ||
| | | | ||
− | + | ISBLANK | |
| | | | ||
− | + | <center>Y</center> | |
| | | | ||
Line 538: | Line 694: | ||
|- | |- | ||
| | | | ||
− | + | ISERR | |
| | | | ||
− | + | <center></center> | |
| | | | ||
Line 548: | Line 704: | ||
|- | |- | ||
| | | | ||
− | + | ISERROR | |
| | | | ||
− | + | <center>Y</center> | |
| | | | ||
Line 558: | Line 714: | ||
|- | |- | ||
| | | | ||
− | + | ISEVEN | |
| | | | ||
− | + | <center>Y</center> | |
| | | | ||
<center>Y</center> | <center>Y</center> | ||
− | | | + | |- |
+ | | | ||
+ | ISLOGICAL | ||
+ | | | ||
+ | <center>Y</center> | ||
+ | | | ||
+ | <center>Y</center> | ||
− | |||
− | |||
− | |||
|- | |- | ||
− | + | | | |
+ | ISNA | ||
− | + | | | |
+ | <center>Y</center> | ||
− | + | | | |
+ | <center>Y</center> | ||
|- | |- | ||
| | | | ||
− | + | ISNONTEXT | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 592: | Line 754: | ||
|- | |- | ||
| | | | ||
− | + | ISNUMBER | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 602: | Line 764: | ||
|- | |- | ||
| | | | ||
− | + | ISODD | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 612: | Line 774: | ||
|- | |- | ||
| | | | ||
− | + | ISREF | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 622: | Line 784: | ||
|- | |- | ||
| | | | ||
− | + | ISTEXT | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 632: | Line 794: | ||
|- | |- | ||
| | | | ||
− | + | N | |
| | | | ||
Line 642: | Line 804: | ||
|- | |- | ||
| | | | ||
− | + | NA | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 652: | Line 814: | ||
|- | |- | ||
| | | | ||
− | + | TYPE | |
| | | | ||
Line 659: | Line 821: | ||
| | | | ||
<center>Y</center> | <center>Y</center> | ||
+ | |||
+ | |} | ||
+ | |||
+ | |||
+ | |||
+ | = Logical = | ||
+ | |||
+ | {| border="2" style="width:50%;" | ||
+ | |- | ||
+ | ! style="width:60%"| '''Function''' | ||
+ | |||
+ | !style="width:20%;"| '''OSE''' | ||
+ | |||
+ | !style="width:20%"| '''EE''' | ||
|- | |- | ||
| | | | ||
− | + | AND | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 672: | Line 848: | ||
|- | |- | ||
| | | | ||
− | + | FALSE | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 682: | Line 858: | ||
|- | |- | ||
| | | | ||
− | + | IF | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 692: | Line 868: | ||
|- | |- | ||
| | | | ||
− | + | IFERROR | |
| | | | ||
Line 702: | Line 878: | ||
|- | |- | ||
| | | | ||
− | + | NOT | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 712: | Line 888: | ||
|- | |- | ||
| | | | ||
− | + | OR | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 722: | Line 898: | ||
|- | |- | ||
| | | | ||
− | + | TRUE | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
<center>Y</center> | <center>Y</center> | ||
+ | |||
+ | |} | ||
+ | |||
+ | = Lookup & Reference = | ||
+ | |||
+ | {| border="2" style="width:50%;" | ||
+ | |- | ||
+ | ! style="width:60%"| '''Function''' | ||
+ | |||
+ | !style="width:20%;"| '''OSE''' | ||
+ | |||
+ | !style="width:20%"| '''EE''' | ||
|- | |- | ||
| | | | ||
− | + | ADDRESS | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 742: | Line 930: | ||
|- | |- | ||
| | | | ||
− | + | CHOOSE | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 752: | Line 940: | ||
|- | |- | ||
| | | | ||
− | + | COLUMN | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 762: | Line 950: | ||
|- | |- | ||
| | | | ||
− | + | COLUMNS | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 772: | Line 960: | ||
|- | |- | ||
| | | | ||
− | + | HLOOKUP | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 782: | Line 970: | ||
|- | |- | ||
| | | | ||
− | + | HYPERLINK | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 792: | Line 980: | ||
|- | |- | ||
| | | | ||
− | + | INDEX | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 802: | Line 990: | ||
|- | |- | ||
| | | | ||
− | + | INDIRECT | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 812: | Line 1,000: | ||
|- | |- | ||
| | | | ||
− | + | LOOKUP | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 822: | Line 1,010: | ||
|- | |- | ||
| | | | ||
− | + | MATCH | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 832: | Line 1,020: | ||
|- | |- | ||
| | | | ||
− | + | OFFSET | |
| | | | ||
Line 842: | Line 1,030: | ||
|- | |- | ||
| | | | ||
− | + | ROW | |
| | | | ||
− | <center></center> | + | <center>Y</center> |
| | | | ||
Line 852: | Line 1,040: | ||
|- | |- | ||
| | | | ||
− | + | ROWS | |
| | | | ||
Line 862: | Line 1,050: | ||
|- | |- | ||
| | | | ||
− | + | VLOOKUP | |
− | |||
− | |||
− | |||
| | | | ||
<center>Y</center> | <center>Y</center> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| | | | ||
<center>Y</center> | <center>Y</center> | ||
− | | | + | |} |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
+ | = Mathematical = | ||
+ | {| border="2" style="width:50%;" | ||
|- | |- | ||
− | | | + | ! style="width:60%"| '''Function''' |
− | + | !style="width:20%;"| '''OSE''' | |
− | + | !style="width:20%"| '''EE''' | |
− | | | + | |- |
− | <center></center> | + | |ABS |
− | + | |<center>Y</center> | |
− | | | + | |<center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | |ACOS | |
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |ACOSH | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
|- | |- | ||
− | | | + | |ASIN |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ASINH |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ATAN |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | + | |- |
− | <center></center> | + | |ATAN2 |
− | + | |<center>Y</center> | |
− | | | + | |<center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | |ATANH | |
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |CEILING | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |COMBIN | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
|- | |- | ||
− | | | + | |COS |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |COSH |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |DEGREES |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | + | |- |
− | <center></center> | + | |EVEN |
− | + | |<center>Y</center> | |
− | | | + | |<center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | |EXP | |
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |FACT | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |FACTDOUBLE | ||
+ | |<center></center> | ||
+ | |<center>Y</center> | ||
|- | |- | ||
− | | | + | |FLOOR |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |GCD |
− | + | |<center></center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |INT |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | + | |- |
− | <center></center> | + | |LCM |
− | + | |<center></center> | |
− | | | + | |<center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | |LN | |
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |LOG | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |LOG10 | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
|- | |- | ||
− | | | + | |MDETERM |
− | + | |<center></center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |MINVERSE |
− | + | |<center></center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |MMULT |
− | + | |<center></center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
− | + | |MOD | |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | |||
− | |||
− | |||
|- | |- | ||
− | | | + | |MROUND |
− | + | |<center></center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |MULTINOMIAL |
− | + | |<center></center> | |
− | + | |<center>Y</center> | |
− | | | + | |- |
− | <center>Y</center> | + | |ODD |
− | + | |<center>Y</center> | |
− | | | + | |<center>Y</center> |
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |PI |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |POWER |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |PRODUCT |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | + | |- |
− | <center>Y</center> | + | |QUOTIENT |
− | + | |<center></center> | |
− | | | + | |<center>Y</center> |
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |RADIANS |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |RAND |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |RANDBETWEEN |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | + | |- |
− | <center>Y</center> | + | |ROMAN |
− | + | |<center></center> | |
− | | | + | |<center>Y</center> |
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ROUND |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ROUNDDOWN |
− | + | |<center>Y</center> | |
− | + | |<center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | |ROUNDUP |
− | + | |<center>Y</center> | |
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SIGN | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SIN | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SINH | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SQRT | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SQRTPI | ||
+ | |<center></center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SUBTOTAL | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SUM | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SUMIF | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SUMIFS | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SUMPRODUCT | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SUMSQ | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SUMX2MY2 | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SUMX2PY2 | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |SUMXMY2 | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |TAN | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |TANH | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |- | ||
+ | |TRUNC | ||
+ | |<center>Y</center> | ||
+ | |<center>Y</center> | ||
+ | |} | ||
+ | |||
+ | == 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 = | ||
+ | {| border="2" style="width:50%;" | ||
|- | |- | ||
− | | | + | ! style="width:60%"| '''Function''' |
− | + | ||
+ | ! style="width:60%"| '''New Name since Excel 2010''' | ||
− | | | + | !style="width:20%;"| '''OSE''' |
− | |||
− | | | + | !style="width:20%"| '''EE''' |
− | |||
|- | |- | ||
− | | | + | | AVEDEV |
− | + | | - | |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | AVERAGE |
− | + | | - | |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | AVERAGEA |
− | + | | - | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center></center> | + | |- |
− | + | | BETADIST | |
− | | | + | | BETA.DIST |
− | <center>Y</center> | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | + | |- |
− | + | | BETAINV | |
− | + | | BETA.INV | |
− | + | | <center></center> | |
− | + | | <center>Y</center> | |
− | + | |- | |
− | + | | BINOMDIST | |
+ | | BINOM.DIST | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | CORREL | ||
+ | | | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
|- | |- | ||
− | + | | CRITBINOM | |
− | + | | BINOM.INV | |
− | + | | <center></center> | |
− | + | | <center>Y</center> | |
− | |||
− | |||
|- | |- | ||
− | | | + | | CHIDIST |
− | + | | CHISQ.DIST.RT | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | | CHIINV | |
− | | | + | | CHISQ.INV.RT |
− | <center>Y</center> | + | | <center></center> |
− | + | | <center>Y</center> | |
+ | |- | ||
+ | | - | ||
+ | | CHISQ.DIST | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
|- | |- | ||
− | | | + | | - |
− | + | | CHISQ.INV | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | COUNT |
− | + | | - | |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | COUNTA |
− | + | | - | |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center></center> | + | |- |
− | + | | COUNTBLANK | |
− | | | + | | - |
− | <center>Y</center> | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
+ | |- | ||
+ | | COUNTIF | ||
+ | | - | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
|- | |- | ||
− | | | + | | DEVSQ |
− | + | | - | |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | EXPONDIST |
− | + | | EXPON.DIST | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | FDIST |
− | + | | F.DIST.RT | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
− | + | | FINV | |
− | + | | F.INV.RT | |
− | + | | <center></center> | |
− | + | | <center>Y</center> | |
− | |||
− | |||
|- | |- | ||
− | | | + | | GAMMADIST |
− | + | | GAMMA.DIST | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | GAMMAINV |
− | + | | GAMMA.INV | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | | GAMMALN | |
− | | | + | | - |
− | <center>Y</center> | + | | <center></center> |
− | + | | <center>Y</center> | |
|- | |- | ||
− | | | + | | GEOMEAN |
− | + | | - | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | HARMEAN |
− | + | | - | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | HYPGEOMDIST |
− | + | | HYPGEOM.DIST | |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | | KURT | |
− | | | + | | - |
− | <center>Y</center> | + | | <center></center> |
− | + | | <center>Y</center> | |
|- | |- | ||
− | | | + | | LARGE |
− | + | | - | |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | MAX |
− | + | | - | |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | MAXA |
− | + | | - | |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | | MEDIAN | |
− | | | + | | - |
− | <center>Y</center> | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
|- | |- | ||
− | | | + | | MIN |
− | + | | - | |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | MINA |
− | + | | - | |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | MODE |
− | + | | MODE.SNGL | |
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | NEGBINOMDIST | ||
+ | | NEGBINOM.DIST | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | NORMDIST | ||
+ | | NORM.DIST | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | NORMINV | ||
+ | | NORM.INV | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | NORMSDIST | ||
+ | | NORM.S.DIST | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | NORMSINV | ||
+ | | NORM.S.INV | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | LOGNORMDIST | ||
+ | | LOGNORM.DIST | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | LOGINV | ||
+ | | LOGNORM.INV | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | POISSON | ||
+ | | POISSON.DIST | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | RANK | ||
+ | | RANK.EQ | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | SKEW | ||
+ | | - | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | SLOPE | ||
+ | | - | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | SMALL | ||
+ | | - | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | STDEV | ||
+ | | STDE.V | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | - | ||
+ | | T.DIST.2T | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | TDIST | ||
+ | | T.DIST.RT | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | TINV | ||
+ | | T.INV.2T | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | VAR | ||
+ | | VAR.S | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | VARP | ||
+ | | VAR.P | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | WEIBULL | ||
+ | | WEIBULL.DIST | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |} | ||
− | + | * [https://support.office.com/en-us/article/What-s-New-Changes-made-to-Excel-functions-355d08c8-8358-4ecb-b6eb-e2e443e98aac?ui=en-US&rs=en-US&ad=US&fromAR=1#bm2 Microsoft change some statistical function names since Excel 2010], ZSS supports both function names listed above. | |
− | |||
− | + | = Text= | |
− | |||
+ | {| border="2" style="width:50%;" | ||
|- | |- | ||
− | | | + | ! style="width:60%"| '''Function''' |
− | |||
− | | | + | !style="width:20%;"| '''OSE''' |
− | |||
− | | | + | !style="width:20%"| '''EE''' |
− | |||
|- | |- | ||
− | | | + | | CHAR |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | + | |- |
− | <center>Y</center> | + | | CLEAN |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | | CODE | |
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | CONCATENATE | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | DOLLAR | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | EXACT | ||
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
|- | |- | ||
− | | | + | | FIND |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | + | |- |
− | <center>Y</center> | + | | FIXED |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | | LEFT | |
− | | | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
− | + | | LEN | |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | |||
− | |||
− | |||
|- | |- | ||
− | | | + | | LOWER |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | MID |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | + | |- |
− | <center>Y</center> | + | | PROPER |
− | + | | <center></center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | | REPLACE | |
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
+ | |- | ||
+ | | REPT | ||
+ | | <center></center> | ||
+ | | <center>Y</center> | ||
|- | |- | ||
− | | | + | | RIGHT |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | SEARCH |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | SUBSTITUTE |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | + | |- |
− | <center>Y</center> | + | | T |
− | + | | <center>Y</center> | |
− | | | + | | <center>Y</center> |
− | <center>Y</center> | + | |- |
− | + | | TEXT | |
+ | | <center>Y</center> | ||
+ | | <center>Y</center> | ||
|- | |- | ||
− | | | + | | TRIM |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | UPPER |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | VALUE |
− | + | | <center>Y</center> | |
− | + | | <center>Y</center> | |
− | + | |} | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | = Not Supported Functions = | |
− | + | ZSS doesn't support Cube, Database, and Web functions. | |
− | + | For current open issues that supported functions have, please refer to [http://tracker.zkoss.org/secure/IssueNavigator.jspa?mode=hide&requestId=12600 our tracker]. | |
− | + | {{ZKSpreadsheetEssentialsPageFooter}} |
Latest revision as of 01:21, 26 November 2019
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.