Implementation for the function COUNTIF
Syntax: COUNTIF ( range, criteria )
range is the range of cells to be counted based on the criteria
criteriais used to determine which cells to count
| Countif.StringMatcher |
|
| Countifs |
Implementation for the function COUNTIFS
Syntax: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2])
|
| DateFunc |
Implementation for the Excel function DATE
|
| Days360 |
Calculates the number of days between two dates based on a 360-day year
(twelve 30-day months), which is used in some accounting calculations.
|
| Dec2Bin |
Implementation for Excel Bin2Dec() function.
|
| Dec2Hex |
Implementation for Excel DELTA() function.
|
| Delta |
Implementation for Excel DELTA() function.
|
| EDate |
Implementation for Excel EDATE () function.
|
| Errortype |
Implementation for the ERROR.TYPE() Excel function.
|
| Even |
|
| FactDouble |
Implementation for Excel FACTDOUBLE() function.
|
| Finance |
Implementation of the financial functions pmt, fv, ppmt, ipmt.
|
| FinanceFunction |
|
| FinanceLib |
|
| Fixed0ArgFunction |
Convenience base class for functions that only take zero arguments.
|
| Fixed1ArgFunction |
Convenience base class for functions that must take exactly one argument.
|
| Fixed2ArgFunction |
Convenience base class for functions that must take exactly two arguments.
|
| Fixed3ArgFunction |
Convenience base class for functions that must take exactly three arguments.
|
| Fixed4ArgFunction |
Convenience base class for functions that must take exactly four arguments.
|
| Hex2Dec |
Implementation for Excel HEX2DEC() function.
|
| Hlookup |
Implementation of the HLOOKUP() function.
|
| Hyperlink |
Implementation of Excel HYPERLINK function.
|
| IfFunc |
Implementation for the Excel function IF
|
| Imaginary |
Implementation for Excel IMAGINARY() function.
|
| ImReal |
Implementation for Excel ImReal() function.
|
| Index |
Implementation for the Excel function INDEX
Syntax :
INDEX ( reference, row_num[, column_num [, area_num]])
INDEX ( array, row_num[, column_num])
referencetypically an area reference, possibly a union of areas
arraya literal array value (currently not supported)
row_numselects the row within the array or area reference
column_numselects column within the array or area reference. default is 1
area_numused when reference is a union of areas
| Indirect |
Implementation for Excel function INDIRECT
INDIRECT() returns the cell or area reference denoted by the text argument.
|
| Intercept |
Implementation of Excel function INTERCEPT()
Calculates the INTERCEPT of the linear regression line that is used to predict y values from x values
(http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html)
Syntax:
INTERCEPT( arrayX, arrayY)
|
| IPMT |
|
| Irr |
Calculates the internal rate of return.
|
| LinearRegressionFunction |
Base class for linear regression functions.
|
| LogicalFunction |
|
| Lookup |
Implementation of Excel function LOOKUP.
|
| Match |
Implementation for the MATCH() Excel function.
|
| MinaMaxa |
|
| Mirr |
Calculates Modified internal rate of return.
|
| Mode |
|
| MultiOperandNumericFunction |
|
| Na |
Implementation of Excel function NA()
|
| NotImplementedFunction |
|
| Now |
Implementation of Excel NOW() Function
|
| Npv |
Calculates the net present value of an investment by using a discount rate
and a series of future payments (negative values) and income (positive
values).
|
| NumericFunction |
|
| NumericFunction.OneArg |
|
| NumericFunction.TwoArg |
|
| Oct2Dec |
Implementation for Excel Oct2Dec() function.
|
| Odd |
|
| Offset |
Implementation for Excel function OFFSET()
OFFSET returns an area reference that is a specified number of rows and columns from a
reference cell or area.
|
| PPMT |
Compute the interest portion of a payment.
|
| Quotient |
Implementation for Excel QUOTIENT () function.
|
| Rank |
Returns the rank of a number in a list of numbers.
|
| Rate |
Implements the Excel Rate function
|
| Replace |
An implementation of the Excel REPLACE() function:
Replaces part of a text string based on the number of characters
you specify, with another text string.
|
| Rept |
Implementation for Excel REPT () function.
|
| Roman |
Implementation for Excel WeekNum() function.
|
| RowFunc |
Implementation for the Excel function ROW
|
| Rows |
Implementation for Excel ROWS function.
|
| Slope |
Implementation of Excel function SLOPE()
Calculates the SLOPE of the linear regression line that is used to predict y values from x values
(http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html)
Syntax:
SLOPE( arrayX, arrayY)
|
| Substitute |
An implementation of the SUBSTITUTE function:
Substitutes text in a text string with new text, some number of times.
|
| Subtotal |
Implementation for the Excel function SUBTOTAL
Syntax :
SUBTOTAL ( functionCode, ref1, ref2 ... )
functionCode(1-11) Selects the underlying aggregate function to be used (see table below)
ref1, ref2 ...
| Sumif |
Implementation for the Excel function SUMIF
Syntax :
SUMIF ( range, criteria, sum_range )
rangeThe range over which criteria is applied.
| Sumifs |
Implementation for the Excel function SUMIFS
Syntax :
SUMIFS ( sum_range, criteria_range1, criteria1>,
[criteria_range2, criteria2], ...)
|
| Sumproduct |
Implementation for the Excel function SUMPRODUCT
Syntax :
SUMPRODUCT ( array1[, array2[, array3[, ...]]])
|
| Sumx2my2 |
Implementation of Excel function SUMX2MY2()
Calculates the sum of differences of squares in two arrays of the same size.
|
| Sumx2py2 |
Implementation of Excel function SUMX2PY2()
Calculates the sum of squares in two arrays of the same size.
|
| Sumxmy2 |
Implementation of Excel function SUMXMY2()
Calculates the sum of squares of differences between two arrays of the same size.
|
| T |
Implementation of Excel T() function
If the argument is a text or error value it is returned unmodified.
|
| TextFunction |
|
| TimeFunc |
Implementation for the Excel function TIME
|
| Today |
Implementation of Excel TODAY() Function
|
| Value |
Implementation for Excel VALUE() function.
|
| Vlookup |
Implementation of the VLOOKUP() function.
|
| WeekdayFunc |
Implementation for the Excel function WEEKDAY
|
| WeekNum |
Implementation for Excel WeekNum() function.
|
| XYNumericFunction |
|
Copyright 2014 The Apache Software Foundation or
its licensors, as applicable.
| | |