Internal functions

Function	Syntax
Banding	`Banding(Argument, StartAt, StopAt, Size)`
BandingC	`BandingC(Argument, StartAt, StopAt, BandCount)`
BandingP	`BandingP (Argument, Boundary1, Boundary2, Boundary3...BoundaryN)`
Case	`Case (Condition1, ReturnValue1, Condition2, ReturnValue2, ..., DefaultValue)`
CaseV	`CaseV (Argument, Value1, Result1, Value2, Result2, ..., DefaultResult)`

Null/Zero functions

Function	Syntax
NullToZero	`NullToZero(Argument)`
ZeroToNull	`ZeroToNull(Argument)`

Financial functions

Function	Syntax
Accrint	`Accrint <Par = 1000, Basis = 0> (Issue, FirstInterest, Settlement, Rate, Frequency)`
Accrintm	`Accrintm <Par = 1000, Basis =0 > (Issue, Maturity, Rate)`
Coupdaybs	`Coupdaybs <Basis = 0> (Settlement, Maturity, Frequency)`
Coupdays	`Coupdays <Basis = 0> (Settlement, Maturity, Frequency)`
Coupdaysnc	`Coupdaysnc <Basis = 0> (Settlement, Maturity, Frequency)`
Coupncd	`Coupncd <Basis = 0> (Settlement, Maturity, Frequency)`
Coupnum	`Coupnum <Basis = 0> (Settlement, Maturity, Frequency)`
Couppcd	`Couppcd <Basis = 0> (Settlement, Maturity, Frequency)`
Cumipmt	`Cumipmt <Type = 0> (Rate, Nper, Pv, Start, End)`
Cumprinc	`Cumprinc <Type = 0> (Rate, Nper, Pv, Start, End)`
Db	`Db <Month = 12> (Cost, Salvage, Life, Period)`
Ddb	`Ddb <Factor = 2> (Cost, Salvage, Life, Period)`
Disc	`Disc <Basis = 0> (Settlement, Maturity, Price, Redemption)`
Dollarde	`Dollarde (FractionalDollar, Decimal)`
Dollarfr	`Dollarfr (DecimalDollar, Fraction)`
Duration	`Duration <Basis = 0> (Settlement, Maturity, CouponRate, YieldRate, Frequency)`
Effect	`Effect(NominalRate, Npery)`
Fv	`Fv <Type = 0> (Rate, Nper, Pmt, Pv)`
Intrate	`Intrate <Basis = 0> (Settlement, Maturity, Investment, Redemption)`
Ipmt	`Ipmt < FV = 0, Type = 0 > (Rate, Period, Nperiod, PV)`
Mduration	`Mduration <Basis = 0> (Settlement, Maturity, CouponRate, YieldRate, Frequency)`
Nominal	`Nominal(EffectiveRate, Npery)`
Nper	`Nper <Type = 0> (Rate, Pmt, PV, FV)`
Oddfprice	`Oddfprice <Basis = 0> (Settlement, Maturity, Issue, FirstCoupon, CouponRate, YieldRate, Redemption, Frequency)`
Oddfyield	`Oddfyield <Basis = 0> (Settlement, Maturity, Issue, FirstCoupon, CouponRate, Price, Redemption, Frequency)`
Oddlprice	`Oddlprice <Basis = 0> (Settlement, Maturity, LastInterest, CouponRate, YieldRate, Redemption, Frequency)`
Oddlyield	`Oddlyield <Basis = 0> (Settlement, Maturity, LastInterest, CouponRate, Price, Redemption, Frequency)`
Pmt	`Pmt <FV = 0, Type = 0> (Rate, Nper, PV)`
Ppmt	`Ppmt <Type = 0> (Rate, Per, Nper, PV, FV)`
Price	`Price <Basis = 0> (Settlement, Maturity, CouponRate, YieldRate, Redemption, Frequency)`
Pricedisc	`Pricedisc <Basis = 0> (Settlement, Maturity, DiscRate, Redemption)`
Pricemat	`Pricemat <Basis = 0> (Settlement, Maturity, Issue, CouponRate, YieldRate)`
Pv	`Pv <Type = 0> (Rate, Nper, Pmt, FV)`
Rate	`Rate <FV = 0, Type = 0, Guess = 0 > (Nperiod, Payment, PV)`
Received	`Received <Basis = 0> (Settlement, Maturity, Investment, Discount)`
Sln	`Sln(Cost, Salvage, Life)`
Syd	`Syd < > (Cost, Salvage, Life, Period)`
Tbilleq	`Tbilleq(Settlement, Maturity, Discount)`
Tbillprice	`Tbillprice(Settlement, Maturity, Discount)`
Tbillyield	`Tbillyield < > (Settlement, Maturity, Price)`
Yield	`Yield <Basis = 0> (Settlement, Maturity, CouponRate, Price, Redemption, Frequency)`
Yielddisc	`Yielddisc <Basis = 0> (Settlement, Maturity, Price, Redemption)`
Yieldmat	`Yieldmat < Basis = 0 > (Settlement, Maturity, Issue, Rate, Price)`
Vdb	`Vdb <Factor = 2> (Cost, Salvage, Life, Period)`

Math functions

Function	Syntax
Abs	`Abs(Argument)`
Acos	`Abs(Argument)`
Acosh	`Acosh(Argument)`
Asin	`Asin(Argument)`
Asinh	`Asinh(Argument)`
Atan	`Atan(Number)`
Atan2	`Atan2(x_num, y_num)`
Banding	`Banding(Argument, StartAt, StopAt, Size)`
BandingC	`BandingC(Argument, StartAt, StopAt, BandCount)`
BandingP	`BandingP (Argument, Boundary1, Boundary2, Boundary3...BoundaryN)`
Ceiling	`Ceiling(Argument)`
Combine	`Combine(Number, Number_Chosen)`
Cos	`Cos(Argument)`
Cosh	`Cosh(Argument)`
Cumipmt	`Cumipmt <Type = 0> (Rate, Nper, Pv, Start, End)`
Cumprinc	`Cumprinc <Type = 0> (Rate, Nper, Pv, Start, End)`
Db	`Db <Month = 12> (Cost, Salvage, Life, Period)`
Ddb	`Ddb <Factor = 2> (Cost, Salvage, Life, Period)`
Degrees	`Degrees(Argument)`
Exp	`Exp(Argument)`
Factorial	`Factorial(Argument)`
Floor	`Floor(Argument)`
Fv	`Fv <Type = 0> (Rate, Nper, Pmt, Pv)`
Int	`Int(Argument)`
Ipmt	`Ipmt < FV = 0, Type = 0 > (Rate, Period, Nperiod, PV)`
Ln	`Ln(Argument)`
Log	`Log(Argument, Base)`
Log10	`Log10(Argument)`
Mod	`Mod(Argument, Divisor)`
Power	`Power(Argument, Power)`
Quotient	`Quotient(numerator, denominator)`
Radians	`Radians(Argument)`
Randbetween	`Randbetween(bottom, top)`
Round	`Round(Argument)`
Round2	`Round2(Argument, Precision)`
Sin	`Sin(Argument)`
Sinh	`Sinh(Argument)`
Sqrt	`Sqrt(Argument)`
Tan	`Tan(Argument)`
Tanh	`Tanh(Argument)`
Trunc	`Trunc(Argument)`

Statistical functions

Function	Syntax
BetaDistribution	`BetaDistribution < Lower Bound = 0, Upper Bound = 1 > (x, alpha, beta)`
BinomialDistribution	`BinomialDistribution <Cumulative = 0> (x, n, p)`
ChiSquareDistribution	`ChiSquareDistribution(x, df)`
Confidence	`Confidence(alpha, stdev, size)`
CritBinomial	`CritBinomial(trials, probability_s, alpha)`
ExponentialDistribution	`ExponentialDistribution <Cumulative = 0> (x, lambda)`
FDistribution	`FDistribution(x, df1, df2)`
Fisher	`Fisher (x)`
GammaDistribution	`GammaDistribution <Cumulative = 0> (x, alpha, beta)`
HypergeometricDistribution	`HypergeometricDistribution(x, n, M, N)`
InverseBetaDistribution	`InverseBetaDistribution < Lower Bound = 0, Upper Bound = 1 > (probability, x, alpha, beta)`
InverseChiDistribution	`InverseChiDistribution(x, df)`
InverseFDistribution	`InverseFDistribution (x, df1, df2)`
InverseFisher	`InverseFisher(x)`
InverseGammaDistribution	`InverseGammaDistribution (x, alpha, beta)`
InverseLognormalDistribution	`InverseLognormalDistribution(x, mean, stdev)`
InverseNormDistribution	`InverseNormDistribution(x, mean, stdev)`
InverseNormSDistribution	`InverseNormSDistribution(x)`
InverseTDistribution	`InverseTDistribution(probability, df)`
LogNormalDistribution	`LognormalDistribution(x, mean, stdev)`
NegativeBinomialDistribution	`NegativeBinomialDistribution(f, s, p)`
NormalDistribution	`NormalDistribution <Cumulative = 0> (x, mean, stdev)`
Permut	`Permut(n, m)`
PoissonDistribution	`PoissonDistribution <Cumulative=0> (x, lambda)`
Standardize	`Standardize(x,mean,stdev)`
StandardNormalDistribution	`StandardNormalDistribution (Argument)`
TDistribution	`TDistribution(x, df)`
WeibullDistribution	`WeibullDistribution <Cumulative = 0> (x, alpha, beta)`