Skip to main content
BuyLog In
ASP.NET Web Forms Controls
Search in…
Docs > Components > Spreadsheet > Formulas > Functions > Engineering Functions
All docs
V24.1
ASP.NET Web Forms Controls
Prerequisites
Supported Browsers
What's Installed
Get Started
Upgrade to a New Version
Common Concepts
Components
Card View
Chart Control
Data and Image Navigation
Data Editors
Diagram
Docking and Popups
File Management
Gantt
Gauges
Grid View
HTML Editor
Multi-Use Site Controls
Pivot Grid
Reporting
Rich Text Editor
Scheduler
Site Navigation and Layout
Spell Checker
Spreadsheet
Supported Formats
Document Management
Document Structure
Import and Export
Appearance
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)
Operators
Array Formulas
Defined Names
Data Validation
Data Presentation
Custom Ribbon
Pivot Table
Charting
Printing
Mail Merge
Modify Documents in Code
Protection
Adaptivity
Keyboard Shortcuts
Localization
Visual Elements
Deployment
Tree List
Vertical Grid
Query Builder
Security Considerations
Redistribution and Deployment
Troubleshooting
Get More Help
.NET Framework API Reference
Client API Reference
Download CHM

Engineering Functions

  • 5 minutes to read

This document briefly describes engineering functions implemented in the ASPxSpreadsheet.

BESSELI(X, N)
Returns the modified Bessel function In(x).
BESSELJ(X, N)

Calculates the Bessel function Jn(x).

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(X, N)
Returns the modified Bessel function Kn(x).
BESSELY(X, N)
Returns the Bessel function Yn(x).
BIN2DEC(number)
Converts a binary number to decimal.
BIN2HEX(number, [places])

Converts a binary number to hexadecimal.

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(number, [places])

Converts a binary number to octal.

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( number1, number2)
Returns a ‘Bitwise And’ of two numbers.
BITLSHIFT(number, shift_amount)
Returns a value number shifted left by shift_amount bits.
BITOR(number1, number2)
Returns a bitwise OR of 2 numbers.
BITRSHIFT(number, shift_amount)
Returns a value number shifted right by shift_amount bits.
BITXOR(number1, number2)
Returns a bitwise ‘Exclusive Or’ of two numbers.
COMPLEX(real_num,i_num,suffix)

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

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(number, from_unit, to_unit)

Converts a number from one measurement system to another.

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(number, [places])

Converts a decimal number to binary.

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(number, [places])

Converts a decimal number to hexadecimal.

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(number, [places])

Converts a decimal number to octal.

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(number1, number2)
Tests whether two values are equal.
ERF(lower_limit,[upper_limit])
Returns the error function integrated between lower_limit and upper_limit.
ERFC(x)
Returns the complementary ERF function integrated between x and infinity.
ERFC.PRECISE(x)
Returns the complementary ERF function integrated between x and infinity.
ERF.PRECISE(x)
Returns the error function integrated between 0 and a specified limit.
GESTEP(number,step)
Returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values.
HEX2BIN(number, [places])

Converts a hexadecimal number to binary.

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(number)
Converts a hexadecimal number to decimal
HEX2OCT(number, [places])

Converts a hexadecimal number to octal.

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(inumber)
Returns the absolute value (the modulus) of a complex number.
IMAGINARY(inumber)
Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.
IMARGUMENT(inumber)
Returns the argument (an angle expressed in radians) of a complex number.
IMCONJUGATE(inumber)
Returns the complex conjugate of a complex number in x + yi or x + yj text format.
IMCOS(inumber)
Returns the cosine of a complex number
IMCOSH(inumber)
Returns the hyperbolic cosine of a complex number.
IMCOT(inumber)
Returns the cotangent of a complex number.
IMCSC(inumber)
Returns the cosecant of a complex number.
IMCSCH(inumber)
Returns the hyperbolic cosecant of a complex number.
IMDIV(inumber1,inumber2)
Returns the quotient of two complex numbers in x + yi or x + yj text format.
IMEXP(inumber)
Returns the exponential of a complex number in x + yi or x + yj text format.
IMLN(inumber)
Returns the natural logarithm of a complex number in x + yi or x + yj text format.
IMLOG10(inumber)
Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
IMLOG2(inumber)
Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.
IMPOWER(inumber, number)
Returns a complex number raised in the specified power.
IMPRODUCT(inumber1,inumber2,...)
Returns the product of complex numbers in x + yi or x + yj text format.
IMREAL(inumber)
Returns the real coefficient of a complex number in x + yi or x + yj text format.
IMSEC(inumber)
Returns the secant of a complex number.
IMSECH(inumber)
Returns the hyperbolic secant of a complex number.
IMSIN(inumber)
Returns the sine of a complex number in x + yi or x + yj text format.
IMSINH(inumber)
Returns the hyperbolic sine of a complex number.
IMSQRT(inumber)
Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
IMSUB(inumber1,inumber2)
Returns the difference of two complex numbers in x + yi or x + yj text format.
IMSUM(inumber1, inumber2, ...)
Returns the sum of complex numbers.
IMTAN(number)
Returns the tangent of a complex number.
OCT2BIN(number, [places])

Converts an octal number to binary.

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(number)
Converts an octal number to decimal.
OCT2HEX(number, [places])

Converts an octal number to hexadecimal.

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.