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 |
Date
|
class |
Datedif
|
class |
Datestring
|
class |
Datevalue
|
class |
Daverage
|
class |
Day
|
class |
Days360
|
class |
Db
|
class |
Dbcs
|
class |
Dcount
|
class |
Dcounta
|
class |
Ddb
|
class |
Degrees
|
class |
Deref
|
class |
Devsq
|
class |
Dget
|
class |
Dmax
|
class |
Dmin
|
class |
Dollar
|
class |
Dproduct
|
class |
Dstdev
|
class |
Dstdevp
|
class |
Dsum
|
class |
Dvar
|
class |
Dvarp
|
class |
Echo
|
class |
Error
|
class |
Errortype
|
class |
Evaluate
|
class |
Even
|
class |
Exact
|
class |
Exec
|
class |
Exp
|
class |
Expondist
|
class |
Fact
|
class |
False
|
class |
Fdist
|
class |
Files
|
class |
FinanceFunction
|
class |
Find
|
class |
Findb
|
class |
Finv
|
class |
Fisher
|
class |
Fisherinv
|
class |
Fixed
|
class |
Floor
|
class |
Forecast
|
class |
Formulaconvert
|
class |
Fpos
|
class |
Frequency
|
class |
Ftest
|
class |
Fv
|
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 |
Int
|
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 |
Large
|
class |
Lasterror
|
class |
Left
|
class |
Leftb
|
class |
Len
|
class |
Lenb
|
class |
Linest
|
class |
Links
|
class |
Ln
|
class |
Log
|
class |
Log10
|
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 |
Lower
|
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 |
Max
|
class |
Maxa
|
class |
Mdeterm
|
class |
Median
|
class |
Mid
An implementation of the MID function MID returns a specific number of
characters from a text string, starting at the specified position.
Syntax: MID(text, start_num,
num_chars)
|
class |
Midb
|
class |
Min
|
class |
Mina
|
class |
Minute
|
class |
Minverse
|
class |
Mirr
|
class |
Mmult
|
class |
Mod
|
class |
Mode
|
class |
Month
|
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
|
class |
Nper
|
class |
Npv
|
class |
Numberstring
|
class |
NumericFunction
|
class |
Odd
|
class |
Or
|
class |
Pearson
|
class |
Percentile
|
class |
Percentrank
|
class |
Permut
|
class |
Pi
|
class |
Pmt
Implementation for the PMT() Excel function.
Syntax:
PMT(rate, nper, pv, fv, type)
Returns the constant repayment amount required for a loan assuming a constant interest rate.
rate the loan interest rate.
nper the number of loan repayments.
pv the present value of the future payments (or principle).
fv the future value (default zero) surplus cash at the end of the loan lifetime.
type whether payments are due at the beginning(1) or end(0 - default) of each payment period.
|
class |
Poisson
|
class |
Power
|
class |
Ppmt
|
class |
Prob
|
class |
Product
|
class |
Proper
|
class |
Pv
|
class |
Quartile
|
class |
Radians
|
class |
Rand
|
class |
Rank
|
class |
Rate
|
class |
Reftext
|
class |
Relref
|
class |
Replace
An implementation of the REPLACE function:
Replaces part of a text string based on the number of characters
you specify, with another text string. |
class |
Replaceb
|
class |
Rept
|
class |
Request
|
class |
Result
|
class |
Right
|
class |
Rightb
|
class |
Roman
|
class |
Round
|
class |
Rounddown
|
class |
Roundup
|
class |
Row
|
class |
Rows
Implementation for Excel ROWS function. |
class |
Rsq
|
class |
Search
|
class |
Searchb
|
class |
Second
|
class |
Series
|
class |
Setname
|
class |
Setvalue
|
class |
Sign
|
class |
Sin
|
class |
Sinh
|
class |
Skew
|
class |
Sln
|
class |
Slope
|
class |
Small
|
class |
Sqrt
|
class |
Standardize
|
class |
Stdev
|
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 |
Sum
|
class |
Sumif
|
class |
Sumproduct
Implementation for the Excel function SUMPRODUCT
Syntax :
SUMPRODUCT ( array1[, array2[, array3[, ...]]])
array1, ...
class |
Sumsq
|
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 |
Tan
|
class |
Tanh
|
class |
Tdist
|
class |
Text
|
class |
TextFunction
|
class |
Textref
|
class |
Time
|
class |
Timevalue
|
class |
Tinv
|
class |
Today
|
class |
Transpose
|
class |
Trend
|
class |
Trim
An implementation of the TRIM function:
Removes leading and trailing spaces from value if evaluated operand
value is string. |
class |
Trimmean
|
class |
True
|
class |
Trunc
|
class |
Ttest
|
class |
Type
|
class |
Upper
|
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 |
Year
|
class |
Ztest
|
Copyright 2008 The Apache Software Foundation or
its licensors, as applicable.
| | |