[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gantt Control
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Collapse]Formulas
    [Collapse]Functions
      Mathematical Functions
      Statistical Functions
      Date and Time Functions
      Text Functions
      Financial Functions
      Logical Functions
      Lookup and Reference Functions
      Engineering Functions
      Information Functions
      Compatibility Functions
      Database Functions
      Web Functions
      User-Defined Functions (UDF)
      Real Time Data (RTD) function
     Operators
     Array Formulas
     Calculation Process
     Formula Engine
     Formula AutoComplete
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Tables
   [Expand]Charts and Graphics
    Printing
    Events
   [Expand]Mail Merge
    Protection
    Operation Restrictions
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Keyboard Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Engineering Functions

This document briefly describes engineering functions implemented in the XtraSpreadsheet.

Name

Description

Syntax

BESSELI

Returns the modified Bessel function In(x).

BESSELI(X, N)

BESSELJ

Calculates the Bessel function Jn(x).

BESSELJ(X, N)

X is the value at which to evaluate the function. N is the order of the Bessel function. If n is not an integer, it is truncated.

BESSELK

Returns the modified Bessel function Kn(x).

BESSELK(X, N)

BESSELY

Returns the Bessel function Yn(x).

BESSELY(X, N)

BIN2DEC

Converts a binary number to decimal.

BIN2DEC(number)

BIN2HEX

Converts a binary number to hexadecimal.

BIN2HEX(number, [places])

Number is the binary number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

BIN2OCT

Converts a binary number to octal.

BIN2OCT(number, [places])

Number is the binary number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

BITAND

Returns a 'Bitwise And' of two numbers.

BITAND( number1, number2)

BITLSHIFT

Returns a value number shifted left by shift_amount bits.

BITLSHIFT(number, shift_amount)

BITOR

Returns a bitwise OR of 2 numbers.

BITOR(number1, number2)

BITRSHIFT

Returns a value number shifted right by shift_amount bits.

BITRSHIFT(number, shift_amount)

BITXOR

Returns a bitwise 'Exclusive Or' of two numbers.

BITXOR(number1, number2)

COMPLEX

Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.

COMPLEX(real_num,i_num,suffix)

Real_num is the real coefficient of the complex number. I_num is the imaginary coefficient of the complex number. Suffix is the suffix for the imaginary component of the complex number. If omitted, suffix is assumed to be "i".

CONVERT

Converts a number from one measurement system to another.

CONVERT(number, from_unit, to_unit)

Number is the number to be converted. From_unit is a text string, denoting the current unit. From_unit is a text string, denoting the unit to which the number will be cconverted.

DEC2BIN

Converts a decimal number to binary.

DEC2BIN(number, [places])

Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

DEC2HEX

Converts a decimal number to hexadecimal.

DEC2HEX(number, [places])

Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

DEC2OCT

Converts a decimal number to octal.

DEC2OCT(number, [places])

Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

DELTA

Tests whether two values are equal.

DELTA(number1, number2)

ERF

Returns the error function integrated between lower_limit and upper_limit.

ERF(lower_limit,[upper_limit])

ERFC

Returns the complementary ERF function integrated between x and infinity.

ERFC(x)

ERFC.PRECISE

Returns the complementary ERF function integrated between x and infinity.

ERFC.PRECISE(x)

ERF.PRECISE

Returns the error function integrated between 0 and a specified limit.

ERF.PRECISE(x)

GESTEP

Returns 1 if number = step; returns 0 (zero) otherwise. Use this function to filter a set of values.

GESTEP(number,step)

HEX2BIN

Converts a hexadecimal number to binary.

HEX2BIN(number, [places])

Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

HEX2DEC

Converts a hexadecimal number to decimal

HEX2DEC(number)

HEX2OCT

Converts a hexadecimal number to octal.

HEX2OCT(number, [places])

Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

IMABS

Returns the absolute value (the modulus) of a complex number.

IMABS(inumber)

IMAGINARY

Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.

IMAGINARY(inumber)

IMARGUMENT

Returns the argument (an angle expressed in radians) of a complex number.

IMARGUMENT(inumber)

IMCONJUGATE

Returns the complex conjugate of a complex number in x + yi or x + yj text format.

IMCONJUGATE(inumber)

IMCOS

Returns the cosine of a complex number

IMCOS(inumber)

IMCOSH

Returns the hyperbolic cosine of a complex number.

IMCOSH(inumber)

IMCOT

Returns the cotangent of a complex number.

IMCOT(inumber)

IMCSC

Returns the cosecant of a complex number.

IMCSC(inumber)

IMCSCH

Returns the hyperbolic cosecant of a complex number.

IMCSCH(inumber)

IMDIV

Returns the quotient of two complex numbers in x + yi or x + yj text format.

IMDIV(inumber1,inumber2)

IMEXP

Returns the exponential of a complex number in x + yi or x + yj text format.

IMEXP(inumber)

IMLN

Returns the natural logarithm of a complex number in x + yi or x + yj text format.

IMLN(inumber)

IMLOG10

Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.

IMLOG10(inumber)

IMLOG2

Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.

IMLOG2(inumber)

IMPOWER

Returns a complex number raised in the specified power.

IMPOWER(inumber, number)

IMPRODUCT

Returns the product of complex numbers in x + yi or x + yj text format.

IMPRODUCT(inumber1,inumber2,...)

IMREAL

Returns the real coefficient of a complex number in x + yi or x + yj text format.

IMREAL(inumber)

IMSEC

Returns the secant of a complex number.

IMSEC(inumber)

IMSECH

Returns the hyperbolic secant of a complex number.

IMSECH(inumber)

IMSIN

Returns the sine of a complex number in x + yi or x + yj text format.

IMSIN(inumber)

IMSINH

Returns the hyperbolic sine of a complex number.

IMSINH(inumber)

IMSQRT

Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.

IMSQRT(inumber)

IMSUB

Returns the difference of two complex numbers in x + yi or x + yj text format.

IMSUB(inumber1,inumber2)

IMSUM

Returns the sum of complex numbers.

IMSUM(inumber1, inumber2, ...)

IMTAN

Returns the tangent of a complex number.

IMTAN(number)

OCT2BIN

Converts an octal number to binary.

OCT2BIN(number, [places])

Number is the octal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

OCT2DEC

Converts an octal number to decimal.

OCT2DEC(number)

OCT2HEX

Converts an octal number to hexadecimal.

OCT2HEX(number, [places])

Number is the octal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used.

Is this topic helpful?​​​​​​​