# Package org.apache.poi.ss.formula.functions

- Interface Summary
  Interface | Description
  --- | ---
  ArrayFunction |
  ArrayMode | Interface for those functions that evaluate arguments in array mode depending on context.
  FreeRefFunction | For most Excel functions, involving references ((cell, area), (2d, 3d)), the references are passed in as arguments, and the exact location remains fixed.
  Function | Common interface for all implementations of Excel built-in functions.
  Function0Arg | Implemented by all functions that can be called with zero arguments
  Function1Arg | Implemented by all functions that can be called with one argument
  Function2Arg | Implemented by all functions that can be called with two arguments
  Function3Arg | Implemented by all functions that can be called with three arguments
  Function4Arg | Implemented by all functions that can be called with four arguments
  IDStarAlgorithm | Interface specifying how an algorithm to be used by `DStarRunner` should look like.
  XYNumericFunction.Accumulator |

- Class Summary
  Class | Description
  --- | ---
  Address | Creates a text reference as text, given specified row and column numbers.
  AggregateFunction |
  Areas | Returns the number of areas in a reference.
  BaseNumberUtils | Some utils for converting from and to any base
  Bin2Dec | Implementation for Excel Bin2Dec() function.
  BooleanFunction | Here are the general rules concerning Boolean functions: Blanks are ignored (not either true or false) Strings are ignored if part of an area ref or cell ref, otherwise they must be 'true' or 'false' Numbers: 0 is false.
  CalendarFieldFunction | Implementation of Excel functions Date parsing functions: Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECOND
  Choose |
  Code | Implementation for Excel CODE () function.
  Column |
  Columns | Implementation for Excel COLUMNS function.
  Complex | Implementation for Excel COMPLEX () function.
  Count | Counts the number of cells that contain numeric data within the list of arguments.
  Counta | Counts the number of cells that contain data within the list of arguments.
  Countblank | Implementation for the function COUNTBLANK
  Countif | Implementation for the function COUNTIF
  Countif.ErrorMatcher |
  Countif.StringMatcher |
  Countifs | Implementation for the function COUNTIFS
  DateFunc | Implementation for the Excel function DATE
  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.
  Dec2Bin | Implementation for Excel Bin2Dec() function.
  Dec2Hex | Implementation for Excel DELTA() function.
  Delta | Implementation for Excel DELTA() function.
  DGet | Implementation of the DGet function: Finds the value of a column in an area with given conditions.
  DMax | Implementation of the DMax function: Finds the maximum value of a column in an area with given conditions.
  DMin | Implementation of the DMin function: Finds the minimum value of a column in an area with given conditions.
  DStarRunner | This class performs a D* calculation.
  DSum | Implementation of the DSum function: Finds the total value of matching values in a column in an area with given conditions.
  EDate | Implementation for Excel EDATE () function.
  EOMonth | Implementation for the Excel EOMONTH() function.
  Errortype | Implementation for the ERROR.TYPE() Excel function.
  Even |
  FactDouble | Implementation for Excel FACTDOUBLE() function.
  Finance | Implementation of the financial functions pmt, fv, ppmt, ipmt.
  FinanceFunction |
  FinanceLib |
  Fixed |
  Fixed0ArgFunction | Convenience base class for functions that only take zero arguments.
  Fixed1ArgFunction | Convenience base class for functions that must take exactly one argument.
  Fixed2ArgFunction | Convenience base class for functions that must take exactly two arguments.
  Fixed3ArgFunction | Convenience base class for functions that must take exactly three arguments.
  Fixed4ArgFunction | Convenience base class for functions that must take exactly four arguments.
  Frequency | Implementation of Excel 'Analysis ToolPak' function FREQUENCY() Returns a frequency distribution as a vertical array
  Hex2Dec | Implementation for Excel HEX2DEC() function.
  Hlookup | Implementation of the HLOOKUP() function.
  Hyperlink | Implementation of Excel HYPERLINK function.
  IfFunc | Implementation for the Excel function IF
  Imaginary | Implementation for Excel IMAGINARY() function.
  ImReal | Implementation for Excel ImReal() function.
  Index | Implementation for the Excel function INDEX
  Indirect | Implementation for Excel function INDIRECT
  Intercept | Implementation of Excel function INTERCEPT()
  IPMT |
  Irr | Calculates the internal rate of return.
  LinearRegressionFunction | Base class for linear regression functions.
  LogicalFunction | Implementation of the various ISxxx Logical Functions, which take a single expression argument, and return True or False.
  Lookup | Implementation of Excel function LOOKUP.
  Match | Implementation for the MATCH() Excel function.
  MatrixFunction |
  MatrixFunction.MutableValueCollector |
  MatrixFunction.OneArrayArg |
  MatrixFunction.TwoArrayArg |
  MinaMaxa |
  Mirr | Calculates Modified internal rate of return.
  Mode |
  MultiOperandNumericFunction | This is the super class for all excel function evaluator classes that take variable number of operands, and where the order of operands does not matter
  Na | Implementation of Excel function NA()
  NotImplementedFunction | This is the default implementation of a Function class.
  Now | Implementation of Excel NOW() Function
  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).
  NumericFunction |
  NumericFunction.OneArg |
  NumericFunction.TwoArg |
  Oct2Dec | Implementation for Excel Oct2Dec() function.
  Odd |
  Offset | Implementation for Excel function OFFSET()
  PPMT | Compute the interest portion of a payment.
  Quotient | Implementation for Excel QUOTIENT () function.
  Rank | Returns the rank of a number in a list of numbers.
  Rate | Implements the Excel Rate function
  Replace | An implementation of the Excel REPLACE() function:
  Rept | Implementation for Excel REPT () function.
  Roman | Implementation for Excel WeekNum() function.
  RowFunc | Implementation for the Excel function ROW
  Rows | Implementation for Excel ROWS function.
  Slope | Implementation of Excel function SLOPE()
  Substitute | An implementation of the SUBSTITUTE function:
  Subtotal | Implementation for the Excel function SUBTOTAL
  Sumif | Implementation for the Excel function SUMIF
  Sumifs | Implementation for the Excel function SUMIFS
  Sumproduct | Implementation for the Excel function SUMPRODUCT
  Sumx2my2 | Implementation of Excel function SUMX2MY2()
  Sumx2py2 | Implementation of Excel function SUMX2PY2()
  Sumxmy2 | Implementation of Excel function SUMXMY2()
  T | Implementation of Excel T() function
  TextFunction |
  TimeFunc | Implementation for the Excel function TIME
  Today | Implementation of Excel TODAY() Function
  Trend | Implementation for the Excel function TREND
  Value | Implementation for Excel VALUE() function.
  Vlookup | Implementation of the VLOOKUP() function.
  WeekdayFunc | Implementation for the Excel function WEEKDAY
  WeekNum | Implementation for Excel WeekNum() function.
  XYNumericFunction |

- Enum Summary
  Enum | Description
  --- | ---
  DStarRunner.DStarAlgorithmEnum | Enum for convenience to identify and source implementations of the D* functions
  LinearRegressionFunction.FUNCTION |
  MultiOperandNumericFunction.Policy |

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