org.formulacompiler.compiler
Enum Function

java.lang.Object
  java.lang.Enum<Function>
      org.formulacompiler.compiler.Function

All Implemented Interfaces:

java.io.Serializable, java.lang.Comparable<Function>

public enum Function
extends java.lang.Enum<Function>

Lists all the functions supported by AFC.

Author:

peo

IF

public static final Function IF

NOT

public static final Function NOT

ABS

public static final Function ABS

ACOS

public static final Function ACOS

ASIN

public static final Function ASIN

ATAN

public static final Function ATAN

ATAN2

public static final Function ATAN2

ACOSH

public static final Function ACOSH

ASINH

public static final Function ASINH

ATANH

public static final Function ATANH

COS

public static final Function COS

COSH

public static final Function COSH

GEOMEAN

public static final Function GEOMEAN

SIN

public static final Function SIN

TAN

public static final Function TAN

DEGREES

public static final Function DEGREES

RADIANS

public static final Function RADIANS

PI

public static final Function PI

CEILING

public static final Function CEILING

FLOOR

public static final Function FLOOR

ROUND

public static final Function ROUND

ROUNDDOWN

public static final Function ROUNDDOWN

ROUNDUP

public static final Function ROUNDUP

TRUNC

public static final Function TRUNC

EVEN

public static final Function EVEN

ODD

public static final Function ODD

INT

public static final Function INT

EXP

public static final Function EXP

POWER

public static final Function POWER

LN

public static final Function LN

LOG

public static final Function LOG

LOG10

public static final Function LOG10

MOD

public static final Function MOD

SQRT

public static final Function SQRT

HARMEAN

public static final Function HARMEAN

PERMUT

public static final Function PERMUT

SINH

public static final Function SINH

TANH

public static final Function TANH

SIGN

public static final Function SIGN

RAND

public static final Function RAND

FACT

public static final Function FACT

COMBIN

public static final Function COMBIN

MDETERM

public static final Function MDETERM

NPV

public static final Function NPV

MIRR

public static final Function MIRR

IRR

public static final Function IRR

DB

public static final Function DB

DDB

public static final Function DDB

SLN

public static final Function SLN

SYD

public static final Function SYD

FV

public static final Function FV

NPER

public static final Function NPER

PMT

public static final Function PMT

PV

public static final Function PV

RATE

public static final Function RATE

VDB

public static final Function VDB

RANK

public static final Function RANK

VAR

public static final Function VAR

VARP

public static final Function VARP

STDEV

public static final Function STDEV

STDEVP

public static final Function STDEVP

AVEDEV

public static final Function AVEDEV

DEVSQ

public static final Function DEVSQ

COVAR

public static final Function COVAR

SKEW

public static final Function SKEW

KURT

public static final Function KURT

CONFIDENCE

public static final Function CONFIDENCE

ERF

public static final Function ERF

ERFC

public static final Function ERFC

NORMDIST

public static final Function NORMDIST

NORMSDIST

public static final Function NORMSDIST

NORMINV

public static final Function NORMINV

NORMSINV

public static final Function NORMSINV

LOGNORMDIST

public static final Function LOGNORMDIST

LOGINV

public static final Function LOGINV

BETADIST

public static final Function BETADIST

BETAINV

public static final Function BETAINV

BINOMDIST

public static final Function BINOMDIST

CHIDIST

public static final Function CHIDIST

CHIINV

public static final Function CHIINV

CHITEST

public static final Function CHITEST

EXPONDIST

public static final Function EXPONDIST

FDIST

public static final Function FDIST

FINV

public static final Function FINV

FTEST

public static final Function FTEST

FISHER

public static final Function FISHER

FISHERINV

public static final Function FISHERINV

GAMMADIST

public static final Function GAMMADIST

GAMMAINV

public static final Function GAMMAINV

GAMMALN

public static final Function GAMMALN

HYPGEOMDIST

public static final Function HYPGEOMDIST

NEGBINOMDIST

public static final Function NEGBINOMDIST

PEARSON

public static final Function PEARSON

POISSON

public static final Function POISSON

RSQ

public static final Function RSQ

STANDARDIZE

public static final Function STANDARDIZE

TDIST

public static final Function TDIST

TINV

public static final Function TINV

TTEST

public static final Function TTEST

WEIBULL

public static final Function WEIBULL

ZTEST

public static final Function ZTEST

STDEVPA

public static final Function STDEVPA

SUMX2MY2

public static final Function SUMX2MY2

SUMX2PY2

public static final Function SUMX2PY2

SUMXMY2

public static final Function SUMXMY2

VARA

public static final Function VARA

STEYX

public static final Function STEYX

CORREL

public static final Function CORREL

INTERCEPT

public static final Function INTERCEPT

SLOPE

public static final Function SLOPE

FORECAST

public static final Function FORECAST

PROB

public static final Function PROB

CRITBINOM

public static final Function CRITBINOM

LARGE

public static final Function LARGE

MEDIAN

public static final Function MEDIAN

MODE

public static final Function MODE

PERCENTILE

public static final Function PERCENTILE

PERCENTRANK

public static final Function PERCENTRANK

QUARTILE

public static final Function QUARTILE

SMALL

public static final Function SMALL

TRIMMEAN

public static final Function TRIMMEAN

DATE

public static final Function DATE

TIME

public static final Function TIME

SECOND

public static final Function SECOND

MINUTE

public static final Function MINUTE

HOUR

public static final Function HOUR

WEEKDAY

public static final Function WEEKDAY

DAY

public static final Function DAY

MONTH

public static final Function MONTH

YEAR

public static final Function YEAR

DAYS360

public static final Function DAYS360

NOW

public static final Function NOW

TODAY

public static final Function TODAY

CHOOSE

public static final Function CHOOSE

MATCH

public static final Function MATCH

INDEX

public static final Function INDEX

LOOKUP

public static final Function LOOKUP

HLOOKUP

public static final Function HLOOKUP

VLOOKUP

public static final Function VLOOKUP

INTERNAL_MATCH_INT

public static final Function INTERNAL_MATCH_INT

CONCATENATE

public static final Function CONCATENATE

CLEAN

public static final Function CLEAN

LEN

public static final Function LEN

LENB

public static final Function LENB

MID

public static final Function MID

LEFT

public static final Function LEFT

RIGHT

public static final Function RIGHT

SUBSTITUTE

public static final Function SUBSTITUTE

REPLACE

public static final Function REPLACE

SEARCH

public static final Function SEARCH

FIND

public static final Function FIND

EXACT

public static final Function EXACT

LOWER

public static final Function LOWER

UPPER

public static final Function UPPER

PROPER

public static final Function PROPER

REPT

public static final Function REPT

TRIM

public static final Function TRIM

FIXED

public static final Function FIXED

DOLLAR

public static final Function DOLLAR

ROMAN

public static final Function ROMAN

N

public static final Function N

T

public static final Function T

VALUE

public static final Function VALUE

CHAR

public static final Function CHAR

CODE

public static final Function CODE

DATEVALUE

public static final Function DATEVALUE

TIMEVALUE

public static final Function TIMEVALUE

ASC

public static final Function ASC

TEXT

public static final Function TEXT

TEXT is volatile because all to-text conversions are considered dependent on the runtime locale/time-zone configuration.

ISBLANK

public static final Function ISBLANK

ISERR

public static final Function ISERR

ISERROR

public static final Function ISERROR

ISLOGICAL

public static final Function ISLOGICAL

ISNA

public static final Function ISNA

ISNONTEXT

public static final Function ISNONTEXT

ISNUMBER

public static final Function ISNUMBER

ISTEXT

public static final Function ISTEXT

ERRORTYPE

public static final Function ERRORTYPE

SUM

public static final Function SUM

PRODUCT

public static final Function PRODUCT

MIN

public static final Function MIN

MAX

public static final Function MAX

COUNT

public static final Function COUNT

COUNTA

public static final Function COUNTA

AVERAGE

public static final Function AVERAGE

AND

public static final Function AND

OR

public static final Function OR

SUMSQ

public static final Function SUMSQ

DSUM

public static final Function DSUM

DPRODUCT

public static final Function DPRODUCT

DCOUNT

public static final Function DCOUNT

DCOUNTA

public static final Function DCOUNTA

DMIN

public static final Function DMIN

DMAX

public static final Function DMAX

DAVERAGE

public static final Function DAVERAGE

DVARP

public static final Function DVARP

DVAR

public static final Function DVAR

DSTDEVP

public static final Function DSTDEVP

DSTDEV

public static final Function DSTDEV

DGET

public static final Function DGET

SUMIF

public static final Function SUMIF

COUNTIF

public static final Function COUNTIF

ERROR

public static final Function ERROR

ERROR() is volatile because it throws exceptions.

NA

public static final Function NA

NA() is volatile because it throws exceptions.

values

public static final Function[] values()

Returns an array containing the constants of this enum type, in the order they're declared. This method may be used to iterate over the constants as follows:

for(Function c : Function.values())
        System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they're declared

valueOf

public static Function valueOf(java.lang.String name)

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

java.lang.IllegalArgumentException - if this enum type has no constant with the specified name

getName

public java.lang.String getName()

isVolatile

public boolean isVolatile()

returnsInt

public boolean returnsInt()

aggregators

public static Function[] aggregators()