Uses of Interface
org.zkoss.poi.ss.formula.functions.Function3Arg

Packages that use Function3Arg

Package	Description
org.zkoss.poi.ss.formula.functions

Uses of Function3Arg in org.zkoss.poi.ss.formula.functions

Classes in org.zkoss.poi.ss.formula.functions that implement Function3Arg

Modifier and Type	Class and Description
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.