|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use Function3Arg | |
---|---|
org.apache.poi.ss.formula.functions |
Uses of Function3Arg in org.apache.poi.ss.formula.functions |
---|
Classes in org.apache.poi.ss.formula.functions that implement Function3Arg | |
---|---|
class |
DateFunc
Implementation for the Excel function DATE |
class |
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. |
class |
FinanceFunction
|
class |
Fixed3ArgFunction
Convenience base class for functions that must take exactly three arguments. |
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 |
IfFunc
Implementation for the Excel function IF |
class |
Index
Implementation for the Excel function INDEX |
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 |
Rank
Returns the rank of a number in a list of numbers. |
class |
Substitute
An implementation of the SUBSTITUTE function: Substitutes text in a text string with new text, some number of times. |
class |
Sumif
Implementation for the Excel function SUMIF |
class |
TimeFunc
Implementation for the Excel function TIME |
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. |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |