Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

## Uses of Interface
org.apache.poi.hssf.record.formula.functions.Function3Arg

Packages that use Function3Arg
org.apache.poi.hssf.record.formula.functions |

Uses of Function3Arg in org.apache.poi.hssf.record.formula.functions

Classes in org.apache.poi.hssf.record.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` | `Npv` Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).
`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.

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES