New to Telerik Document Processing? Start a free 30-day trial

NPer

Class

Calculates the number of payment periods for an investment with periodic constant payments and a constant interest rate.

Definition

Namespace:Telerik.Documents.Spreadsheet.Expressions.Functions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

C#

public class NPer : NumbersInFunction

Inheritance: objectFunctionBaseFunctionWithArgumentsFunctionWithSameTypeArguments<double>NumbersInFunctionNPer...

Inherited Members NumbersInFunction.ArgumentConversionRulesFunctionWithSameTypeArguments<double>.EvaluateOverride(FunctionEvaluationContext<object>)FunctionWithArguments.EvaluateOverride(FunctionEvaluationContext<RadExpression>)FunctionWithArguments.EvaluateLiftedElement(FunctionEvaluationContext<RadExpression>, RadExpression[], int, int)FunctionBase.IsSpillingArgument(int, RadExpression)FunctionBase.Evaluate(FunctionEvaluationContext<RadExpression>)FunctionBase.IsArgumentNumberValid(int)FunctionBase.LiftsOverArrays...

Constructors

NPer()

Initializes a new NPER function instance for calculating the number of payment periods.

C#

public NPer()

Fields

FunctionName

The name of the function.

C#

public static readonly string FunctionName

Properties

FunctionInfo

Provides metadata including category, description, and argument definitions.

C#

public override FunctionInfo FunctionInfo { get; }

Property Value:

The function info as FunctionInfo.

Overrides: FunctionBase.FunctionInfo

Name

Returns the function identifier "NPER".

C#

public override string Name { get; }

Property Value:

The name as String.

Overrides: FunctionBase.Name

Methods

EvaluateOverride(FunctionEvaluationContext<double>)

Evaluates the function by computing the number of periods from rate, payment, present value, future value, and payment timing.

C#

protected override RadExpression EvaluateOverride(FunctionEvaluationContext<double> context)

Parameters:contextFunctionEvaluationContext<double>

The context.

Returns:

Functions result as RadExpression.

Overrides: FunctionWithSameTypeArguments<double>.EvaluateOverride(FunctionEvaluationContext<double>)

In this article

Definition Constructors NPer()Fields FunctionName Properties FunctionInfo Name Methods EvaluateOverride(FunctionEvaluationContext<double>)

Not finding the help you need?

Contact Support