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

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.

 



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