 General Information WinForms Controls .NET Core Support Prerequisites What's Installed Build an Application Controls and Libraries Forms and User Controls Messages, Notifications, and Dialogs Editors and Simple Controls Ribbon, Bars and Menu Application UI Manager Docking Library Data Grid Vertical Grid Property Grid Pivot Grid Tree List Gantt Control Chart Control Diagrams Gauges Map Control Scheduler Spreadsheet Product Information Product Structure Getting Started Spreadsheet Document Supported Formats Cell Basics Formulas 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 Data Presentation Data Grouping Pivot Tables Charts and Graphics Printing Events Mail Merge Protection Operation Restrictions Find and Replace Visual Elements Services Keyboard Shortcuts Examples Rich Text Editor Spell Checker Form Layout Managers Navigation Controls Printing-Exporting PDF Viewer Reporting Snap TreeMap Control Sunburst Control Common Features Get More Help API Reference ASP.NET Controls and MVC Extensions ASP.NET Bootstrap Controls ASP.NET Core Bootstrap Controls WPF Controls Xamarin Controls Windows 10 App Controls Office File API Reporting Report and Dashboard Server Dashboard eXpressApp Framework eXpress Persistent Objects CodeRush CodeRush Classic Cross-Platform Core Libraries Tools and Utilities End-User Documentation     # 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.