Supported Formula Functions
Here we list all built-in functions in Keikai OSE and EE:
Check Microsoft Excel function list for details.
Date & Time
Function |
OSE |
EE |
---|---|---|
DATE |
Y |
Y |
DATEDIF since 5.8.0 |
Y |
|
DATEVALUE |
Y |
|
DAY |
Y |
Y |
DAYS360 |
Y |
Y |
EOMONTH |
Y |
|
HOUR |
Y |
Y |
MINUTE |
Y |
Y |
MONTH |
Y |
Y |
NETWORKDAYS |
Y |
Y |
NOW |
Y |
Y |
SECOND |
Y |
Y |
TIME |
Y |
Y |
TODAY |
Y |
Y |
WEEKDAY |
Y |
Y |
WORKDAY |
Y |
Y |
YEAR |
Y |
Y |
YEARFRAC |
Y |
Y |
Engineering
Function |
OSE |
EE |
---|---|---|
BESSELI |
|
Y |
BESSELJ |
|
Y |
BESSELK |
|
Y |
BESSELY |
|
Y |
BIN2DEC |
|
Y |
BIN2HEX |
|
Y |
BIN2OCT |
|
Y |
COMPLEX |
|
Y |
DEC2BIN |
|
Y |
DEC2HEX |
|
Y |
DEC2OCT |
|
Y |
DELTA |
|
Y |
ERF |
|
Y |
ERFC |
|
Y |
GESTEP |
|
Y |
HEX2BIN |
|
Y |
HEX2DEC |
|
Y |
HEX2OCT |
|
Y |
IMABS |
|
Y |
IMAGINARY |
|
Y |
IMARGUMENT |
|
Y |
IMCONJUGATE |
|
Y |
IMCOS |
|
Y |
IMDIV |
|
Y |
IMEXP |
|
Y |
IMLN |
|
Y |
IMLOG10 |
|
Y |
IMLOG2 |
|
Y |
IMPOWER |
|
Y |
IMPRODUCT |
|
Y |
IMREAL |
|
Y |
IMSIN |
|
Y |
IMSQRT |
|
Y |
IMSUB |
|
Y |
IMSUM |
|
Y |
OCT2BIN |
|
Y |
OCT2DEC |
|
Y |
OCT2HEX |
|
Y |
Financial
Function |
OSE |
EE |
---|---|---|
ACCRINT |
Y |
|
ACCRINTM |
Y |
|
AMORDEGRC |
Y |
|
AMORLINC |
Y |
|
COUPDAYBS |
Y |
|
COUPDAYS |
Y |
|
COUPDAYSNC |
Y |
|
COUPNCD |
Y |
|
COUPNUM |
Y |
|
COUPPCD |
Y |
|
CUMIPMT |
Y |
|
CUMPRINC |
Y |
|
DB |
Y |
|
DDB |
Y |
|
DISC |
Y |
|
DOLLARDE |
Y |
|
DOLLARFR |
Y |
|
DURATION |
Y |
|
EFFECT |
Y |
|
FV |
Y |
Y |
FVSCHEDULE |
Y |
|
INTRATE |
Y |
|
IPMT |
Y |
|
IRR |
Y |
Y |
NOMINAL |
Y |
|
NPER |
Y |
Y |
NPV |
Y |
Y |
PMT |
Y |
Y |
PPMT |
Y |
|
PRICE |
Y |
|
PRICEDISC |
Y |
|
PRICEMAT |
Y |
|
PV |
Y |
Y |
RATE |
Y |
Y |
RECEIVED |
Y |
|
SLN |
Y |
|
SYD |
Y |
|
TBILLEQ |
Y |
|
TBILLPRICE |
Y |
|
TBILLYIELD |
Y |
|
XNPV |
Y |
|
YIELD |
Y |
|
YIELDDISC |
Y |
|
YIELDMAT |
Y |
Info
Function |
OSE |
EE |
---|---|---|
ERROR.TYPE |
Y |
Y |
ISBLANK |
Y |
Y |
ISERR |
Y |
|
ISERROR |
Y |
Y |
ISEVEN |
Y |
Y |
ISLOGICAL |
Y |
Y |
ISNA |
Y |
Y |
ISNONTEXT |
Y |
Y |
ISNUMBER |
Y |
Y |
ISODD |
Y |
Y |
ISREF |
Y |
Y |
ISTEXT |
Y |
Y |
N |
Y |
|
NA |
Y |
Y |
TYPE |
Y |
Logical
Function |
OSE |
EE |
---|---|---|
AND |
Y |
Y |
FALSE |
Y |
Y |
IF |
Y |
Y |
IFERROR |
Y |
|
NOT |
Y |
Y |
OR |
Y |
Y |
TRUE |
Y |
Y |
Lookup & Reference
Function |
OSE |
EE |
---|---|---|
ADDRESS |
Y |
Y |
CHOOSE |
Y |
Y |
COLUMN |
Y |
Y |
COLUMNS |
Y |
Y |
HLOOKUP |
Y |
Y |
HYPERLINK |
Y |
Y |
INDEX |
Y |
Y |
INDIRECT |
Y |
Y |
LOOKUP |
Y |
Y |
MATCH |
Y |
Y |
OFFSET |
Y |
Y |
ROW |
Y |
Y |
ROWS |
Y |
Y |
VLOOKUP |
Y |
Y |
Mathematical
Function |
OSE |
EE |
---|---|---|
ABS |
Y |
Y |
ACOS |
Y |
Y |
ACOSH |
Y |
Y |
ASIN |
Y |
Y |
ASINH |
Y |
Y |
ATAN |
Y |
Y |
ATAN2 |
Y |
Y |
ATANH |
Y |
Y |
CEILING |
Y |
Y |
COMBIN |
Y |
Y |
COS |
Y |
Y |
COSH |
Y |
Y |
DEGREES |
Y |
Y |
EVEN |
Y |
Y |
EXP |
Y |
Y |
FACT |
Y |
Y |
FACTDOUBLE |
Y |
|
FLOOR |
Y |
Y |
GCD |
Y |
|
INT |
Y |
Y |
LCM |
Y |
|
LN |
Y |
Y |
LOG |
Y |
Y |
LOG10 |
Y |
Y |
MDETERM |
Y |
|
MINVERSE |
Y |
|
MMULT |
Y |
|
MOD |
Y |
Y |
MROUND |
Y |
|
MULTINOMIAL |
Y |
|
ODD |
Y |
Y |
PI |
Y |
Y |
POWER |
Y |
Y |
PRODUCT |
Y |
Y |
QUOTIENT |
Y |
|
RADIANS |
Y |
Y |
RAND |
Y |
Y |
RANDBETWEEN |
Y |
Y |
ROMAN |
Y |
|
ROUND |
Y |
Y |
ROUNDDOWN |
Y |
Y |
ROUNDUP |
Y |
Y |
SIGN |
Y |
Y |
SIN |
Y |
Y |
SINH |
Y |
Y |
SQRT |
Y |
Y |
SQRTPI |
Y |
|
SUBTOTAL |
Y |
Y |
SUM |
Y |
Y |
SUMIF |
Y |
Y |
SUMIFS |
Y |
Y |
SUMPRODUCT |
Y |
Y |
SUMSQ |
Y |
Y |
SUMX2MY2 |
Y |
Y |
SUMX2PY2 |
Y |
Y |
SUMXMY2 |
Y |
Y |
TAN |
Y |
Y |
TANH |
Y |
Y |
TRUNC |
Y |
Y |
SUMPRODUCT
You can specify a condition 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)
SUBTOTAL
Keikai follows Microsoft SUBTOTAL function.
Regarding the 1st argument, “1-11 includes manually-hidden rows, while 101-111 excludes them; filtered-out cells are always excluded”.
- If you enable the auto filter in a sheet, Keikai treats all hidden rows as filtered-out cells.
- If you don’t enable the auto filter, Keikai treats all hidden rows as manually-hidden rows.
Statistical
Function |
New Name since Excel 2010 |
OSE |
EE |
---|---|---|---|
AVEDEV |
- |
Y |
Y |
AVERAGE |
- |
Y |
Y |
AVERAGEA |
- |
Y |
|
AVERAGEIF |
- |
Y |
|
BETADIST |
BETA.DIST |
Y |
|
BETAINV |
BETA.INV |
Y |
|
BINOMDIST |
BINOM.DIST |
Y |
|
CORREL |
Y |
||
CRITBINOM |
BINOM.INV |
Y |
|
CHIDIST |
CHISQ.DIST.RT |
Y |
|
CHIINV |
CHISQ.INV.RT |
Y |
|
- |
CHISQ.DIST |
Y |
|
- |
CHISQ.INV |
Y |
|
COUNT |
- |
Y |
Y |
COUNTA |
- |
Y |
Y |
COUNTBLANK |
- |
Y |
Y |
COUNTIF |
- |
Y |
Y |
DEVSQ |
- |
Y |
Y |
EXPONDIST |
EXPON.DIST |
Y |
|
FDIST |
F.DIST.RT |
Y |
|
FINV |
F.INV.RT |
Y |
|
GAMMADIST |
GAMMA.DIST |
Y |
|
GAMMAINV |
GAMMA.INV |
Y |
|
GAMMALN |
- |
Y |
|
GEOMEAN |
- |
Y |
|
HARMEAN |
- |
Y |
|
HYPGEOMDIST |
HYPGEOM.DIST |
Y |
|
KURT |
- |
Y |
|
LARGE |
- |
Y |
Y |
MAX |
- |
Y |
Y |
MAXA |
- |
Y |
Y |
MEDIAN |
- |
Y |
Y |
MIN |
- |
Y |
Y |
MINA |
- |
Y |
Y |
MODE |
MODE.SNGL |
Y |
Y |
NEGBINOMDIST |
NEGBINOM.DIST |
Y |
|
NORMDIST |
NORM.DIST |
Y |
|
NORMINV |
NORM.INV |
Y |
|
NORMSDIST |
NORM.S.DIST |
Y |
|
NORMSINV |
NORM.S.INV |
Y |
|
LOGNORMDIST |
LOGNORM.DIST |
Y |
|
LOGINV |
LOGNORM.INV |
Y |
Y |
POISSON |
POISSON.DIST |
Y |
Y |
RANK |
RANK.EQ |
Y |
Y |
SKEW |
- |
Y |
|
SLOPE |
- |
Y |
|
SMALL |
- |
Y |
Y |
STDEV |
STDE.V |
Y |
Y |
- |
T.DIST.2T |
Y |
|
TDIST |
T.DIST.RT |
Y |
|
TINV |
T.INV.2T |
Y |
|
VAR |
VAR.S |
Y |
Y |
VARP |
VAR.P |
Y |
Y |
WEIBULL |
WEIBULL.DIST |
Y |
Note: Keikai supports both function names listed here. .
Text
Function |
OSE |
EE |
---|---|---|
CHAR |
Y |
Y |
CLEAN |
Y |
Y |
CODE |
Y |
|
CONCATENATE |
Y |
Y |
DOLLAR |
Y |
Y |
EXACT |
Y |
Y |
FIND |
Y |
Y |
FIXED |
Y |
|
LEFT |
Y |
Y |
LEN |
Y |
Y |
LOWER |
Y |
Y |
MID |
Y |
Y |
PROPER |
Y |
|
REPLACE |
Y |
Y |
REPT |
Y |
|
RIGHT |
Y |
Y |
SEARCH |
Y |
Y |
SUBSTITUTE |
Y |
Y |
T |
Y |
Y |
TEXT |
Y |
Y |
TRIM |
Y |
Y |
UPPER |
Y |
Y |
VALUE |
Y |
Y |
Unsupported Functions
Keikai doesn’t support Cube, Database, Web functions and formulas that generate Arrays of results.
Locale Support
- Keikai supports 2 separator: comma
,
and semi-color;
depeneding on the locale. - You can only use a function in English.
Relative Position Evaluation
When evaluating a row area (e.g. A1:B1
) or column area (e.g. A1:A2
), keikai will select a single cell from an area depending on the coordinates of the calling cell. Here is an example demonstrating both selection from a single row area and a single column area in the same formula.
A | B | C | D | |
---|---|---|---|---|
1 | 15 | 20 | 25 | |
2 | 200 | |||
3 | 300 | |||
4 | 400 |
If the formula =1000+A1:B1+D2:D3
is put into the 9 cells from A2 to C4, the spreadsheet
will look like this:
A | B | C | D | |
---|---|---|---|---|
1 | 15 | 20 | 25 | |
2 | 1215 | 1220 | #VALUE! | 200 |
3 | 1315 | 1320 | #VALUE! | 300 |
4 | #VALUE! | #VALUE! | #VALUE! | 400 |
Note that the row area (A1:B1) does not include column C and the column area (D2:D3) does not include row 4, so the values in C1(=25) and D4(=400) are not accessible to the formula as written, but in the 4 cells A2:B3, the row and column selection works ok.
The same concept is extended to references across sheets, such that even multi-row, multi-column areas can be useful.
Comments