class |
Countif
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
class |
Covar
|
class |
Critbinom
|
class |
Customrepeat
|
class |
Datedif
|
class |
DateFunc
|
class |
Datestring
|
class |
Datevalue
|
class |
Daverage
|
class |
Days360
|
class |
Db
|
class |
Dbcs
|
class |
Dcount
|
class |
Dcounta
|
class |
Ddb
|
class |
Deref
|
class |
Dget
|
class |
Dmax
|
class |
Dmin
|
class |
Dproduct
|
class |
Dstdev
|
class |
Dstdevp
|
class |
Dsum
|
class |
Dvar
|
class |
Dvarp
|
class |
Echo
|
class |
Error
|
class |
Errortype
Implementation for the ERROR.TYPE() Excel function.
Syntax:
ERROR.TYPE(errorValue)
Returns a number corresponding to the error type of the supplied argument.
errorValueReturn Value
#NULL!1
#DIV/0!2
#VALUE!3
#REF!4
#NAME?5
#NUM!6
#N/A!7
everything else#N/A!
Note - the results of ERROR.TYPE() are different to the constants defined in
HSSFErrorConstants.
class |
Evaluate
|
class |
Even
|
class |
Exec
|
class |
Expondist
|
class |
False
|
class |
Fdist
|
class |
Files
|
class |
FinanceFunction
|
class |
Find
|
class |
Findb
|
class |
Finv
|
class |
Fisher
|
class |
Fisherinv
|
class |
Fixed
|
class |
Forecast
|
class |
Formulaconvert
|
class |
Fpos
|
class |
Frequency
|
class |
Ftest
|
class |
Gammadist
|
class |
Gammainv
|
class |
Gammaln
|
class |
Geomean
|
class |
Goto
|
class |
Group
|
class |
Growth
|
class |
Halt
|
class |
Harmean
|
class |
Help
|
class |
Hlookup
Implementation of the HLOOKUP() function.
HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row.
Syntax:
HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)
lookup_value The value to be found in the first column of the table array.
table_array An area reference for the lookup data. |
class |
Hour
|
class |
Hyperlink
|
class |
Hypgeomdist
|
class |
If
|
class |
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.
class |
Info
|
class |
Initiate
|
class |
Input
|
class |
Intercept
|
class |
Ipmt
|
class |
Irr
|
class |
Isblank
|
class |
Iserr
|
class |
IsError
|
class |
Islogical
|
class |
IsNa
|
class |
Isnontext
|
class |
Isnumber
|
class |
Ispmt
|
class |
Isref
|
class |
Istext
|
class |
Kurt
|
class |
Lasterror
|
class |
Leftb
|
class |
Lenb
|
class |
Linest
|
class |
Links
|
class |
Logest
|
class |
LogicalFunction
|
class |
Loginv
|
class |
Lognormdist
|
class |
Lookup
Implementation of Excel function LOOKUP.
LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column. |
class |
Match
Implementation for the MATCH() Excel function.
Syntax:
MATCH(lookup_value, lookup_array, match_type)
Returns a 1-based index specifying at what position in the lookup_array the specified
lookup_value is found.
Specific matching behaviour can be modified with the optional match_type parameter. |
class |
Mdeterm
|
class |
Midb
|
class |
MinaMaxa
|
class |
Minute
|
class |
Minverse
|
class |
Mirr
|
class |
Mmult
|
class |
Mode
|
class |
MultiOperandNumericFunction
|
class |
N
|
class |
Na
Implementation of Excel function NA() |
class |
Names
|
class |
Negbinomdist
|
class |
Normdist
|
class |
Norminv
|
class |
Normsdist
|
class |
Normsinv
|
class |
Not
|
class |
Note
|
class |
NotImplementedFunction
|
class |
Now
Implementation of Excel NOW() Function |
class |
Npv
|
class |
Numberstring
|
class |
NumericFunction
|
static class |
NumericFunction.MultiArg
|
static class |
NumericFunction.OneArg
|
static class |
NumericFunction.TwoArg
|
class |
Odd
|
class |
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.
Syntax:
OFFSET(reference, rows, cols, height, width)
reference is the base reference.
rows is the number of rows up or down from the base reference.
cols is the number of columns left or right from the base reference.
height (default same height as base reference) is the row count for the returned area reference.
width (default same width as base reference) is the column count for the returned area reference.
|
class |
Or
|
class |
Pearson
|
class |
Percentile
|
class |
Percentrank
|
class |
Permut
|
class |
Pi
|
class |
Poisson
|
class |
Ppmt
|
class |
Prob
|
class |
Proper
|
class |
Quartile
|
class |
Rand
|
class |
Rank
|
class |
Rate
|
class |
Reftext
|
class |
Relref
|
class |
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.
Syntax:
REPLACE(oldText, startNum, numChars, newText)
oldText The text string containing characters to replace
startNum The position of the first character to replace (1-based)
numChars The number of characters to replace
newText The new text value to replace the removed section
|
class |
Replaceb
|
class |
Rept
|
class |
Request
|
class |
Result
|
class |
Rightb
|
class |
Roman
|
class |
Row
|
class |
Rows
Implementation for Excel ROWS function. |
class |
Rsq
|
class |
Search
|
class |
Searchb
|
class |
Second
|
class |
Series
|
class |
Setname
|
class |
Setvalue
|
class |
Skew
|
class |
Sln
|
class |
Slope
|
class |
Standardize
|
class |
Stdeva
|
class |
Stdevp
|
class |
Stdevpa
|
class |
Step
|
class |
Steyx
|
class |
Substitute
An implementation of the SUBSTITUTE function:
Substitutes text in a text string with new text, some number of times. |
class |
Subtotal
|
class |
Sumif
|
class |
Sumproduct
Implementation for the Excel function SUMPRODUCT
Syntax :
SUMPRODUCT ( array1[, array2[, array3[, ...]]])
array1, ...
class |
Sumx2my2
Implementation of Excel function SUMX2MY2()
Calculates the sum of differences of squares in two arrays of the same size.
Syntax:
SUMX2MY2(arrayX, arrayY)
result = Σi: 0..n(xi2-yi2) |
class |
Sumx2py2
Implementation of Excel function SUMX2PY2()
Calculates the sum of squares in two arrays of the same size.
Syntax:
SUMX2PY2(arrayX, arrayY)
result = Σi: 0..n(xi2+yi2) |
class |
Sumxmy2
Implementation of Excel function SUMXMY2()
Calculates the sum of squares of differences between two arrays of the same size.
Syntax:
SUMXMY2(arrayX, arrayY)
result = Σi: 0..n(xi-yi)2 |
class |
Syd
|
class |
T
|
class |
Tdist
|
class |
Text
|
class |
TextFunction
|
class |
Textref
|
class |
Time
|
class |
Timevalue
|
class |
Tinv
|
class |
Today
Implementation of Excel TODAY() Function
|
class |
Transpose
|
class |
Trend
|
class |
Trimmean
|
class |
True
|
class |
Trunc
|
class |
Ttest
|
class |
Type
|
class |
Usdollar
|
class |
Value
|
class |
Var
|
class |
Vara
|
class |
Varp
|
class |
Varpa
|
class |
Vdb
|
class |
Vlookup
Implementation of the VLOOKUP() function.
VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.
Syntax:
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
lookup_value The value to be found in the first column of the table array.
table_array An area reference for the lookup data. |
class |
Volatile
|
class |
Weekday
|
class |
Weibull
|
class |
XYNumericFunction
|
class |
Ztest
|
Copyright 2008 The Apache Software Foundation or
its licensors, as applicable.
| | | |