Package org.apache.poi.hssf.record.formula.functions

Interface Summary
Function  
 

Class Summary
Abs  
Absref  
Acos  
Acosh  
Activecell  
Address  
And  
Areas  
Argument  
Asc  
Asin  
Asinh  
Atan  
Atan2  
Atanh  
Avedev  
Average  
Averagea  
Betadist  
Betainv  
Binomdist  
BooleanFunction  
Call  
Caller  
Ceiling  
Cell  
Char  
Chidist  
Chiinv  
Chitest  
Choose  
Clean  
Code  
Column  
Columns  
Combin  
Concatenate  
Confidence  
Correl  
Cos  
Cosh  
Count  
Counta  
Countblank  
Countif  
Covar  
Critbinom  
Customrepeat  
Date  
Datedif  
Datestring  
Datevalue  
Daverage  
Day  
Days360  
Db  
Dbcs  
Dcount  
Dcounta  
Ddb  
Degrees  
Deref  
Devsq  
Dget  
Dmax  
Dmin  
Dollar  
Dproduct  
Dstdev  
Dstdevp  
Dsum  
Dvar  
Dvarp  
Echo  
Error  
Errortype  
Evaluate  
Even  
Exact  
Exec  
Exp  
Expondist  
Fact  
False  
Fdist  
Files  
FinanceFunction  
FinanceLib  
Find  
Findb  
Finv  
Fisher  
Fisherinv  
Fixed  
Floor  
Forecast  
Formulaconvert  
Fpos  
Frequency  
Ftest  
Fv  
Gammadist  
Gammainv  
Gammaln  
Geomean  
Goto  
Group  
Growth  
Halt  
Harmean  
Help  
Hlookup  
Hour  
Hyperlink  
Hypgeomdist  
If  
Index  
Indirect  
Info  
Initiate  
Input  
Int  
Intercept  
Ipmt  
Irr  
Isblank  
Iserr  
IsError  
Islogical  
IsNa  
Isnontext  
Isnumber  
Ispmt  
Isref  
Istext  
Kurt  
Large  
Lasterror  
Left  
Leftb  
Len  
Lenb  
Linest  
Links  
Ln  
Log  
Log10  
Logest  
LogicalFunction  
Loginv  
Lognormdist  
Lookup  
Lower  
Match  
MathX  
Max  
Maxa  
Mdeterm  
Median  
Mid An implementation of the MID function: Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
Midb  
Min  
Mina  
Minute  
Minverse  
Mirr  
Mmult  
Mod  
Mode  
Month  
MultiOperandNumericFunction  
N  
Na  
Names  
Negbinomdist  
Normdist  
Norminv  
Normsdist  
Normsinv  
Not  
Note  
NotImplementedFunction  
Now  
Nper  
Npv  
Numberstring  
NumericFunction  
Odd  
Offset  
Or  
Pearson  
Percentile  
Percentrank  
Permut  
Pi  
Pmt  
Poisson  
Power  
Ppmt  
Prob  
Product  
Proper  
Pv  
Quartile  
Radians  
Rand  
Rank  
Rate  
Reftext  
Relref  
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.
Replaceb  
Rept  
Request  
Result  
Right  
Rightb  
Roman  
Round  
Rounddown  
Roundup  
Row  
Rows  
Rsq  
Search  
Searchb  
Second  
Series  
Setname  
Setvalue  
Sign  
Sin  
Sinh  
Skew  
Sln  
Slope  
Small  
Sqrt  
Standardize  
StatsLib  
Stdev  
Stdeva  
Stdevp  
Stdevpa  
Step  
Steyx  
Substitute An implementation of the SUBSTITUTE function: Substitutes text in a text string with new text, some number of times.
Subtotal  
Sum  
Sumif  
Sumproduct  
Sumsq  
Sumx2my2  
Sumx2py2  
Sumxmy2  
Syd  
T  
Tan  
Tanh  
Tdist  
Text  
TextFunction  
Textref  
Time  
Timevalue  
Tinv  
Today  
Transpose  
Trend  
Trim An implementation of the TRIM function: Removes leading and trailing spaces from value if evaluated operand value is string.
Trimmean  
True  
Trunc  
Ttest  
Type  
Upper  
Usdollar  
Value  
Var  
Vara  
Varp  
Varpa  
Vdb  
Vlookup  
Volatile  
Weekday  
Weibull  
XYNumericFunction  
Year  
Ztest  
 



Copyright 2008 The Apache Software Foundation or its licensors, as applicable.