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

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

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

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

Classes in org.apache.poi.hssf.record.formula.functions that implement Function4Arg
`class` | `FinanceFunction`
`class` | `Fixed4ArgFunction` Convenience base class for functions that must take exactly four 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` | `Index` Implementation for the Excel function INDEX
`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` | `Replace` An implementation of the Excel REPLACE() function: Replaces part of a text string based on the number of characters you specify, with another text string. Syntax: REPLACE(oldText, startNum, numChars, newText) oldText The text string containing characters to replace startNum The position of the first character to replace (1-based) numChars The number of characters to replace newText The new text value to replace the removed section
`class` | `Substitute` An implementation of the SUBSTITUTE function: Substitutes text in a text string with new text, some number of times.
`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

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