General Information WinForms Controls ASP.NET Controls and MVC Extensions Prerequisites What's Installed Common Concepts ASP.NET WebForms Controls Getting Started Grid View Tree List Card View Reporting Chart Control Pivot Grid Spreadsheet Product Information Getting Started Concepts Spreadsheet Document Supported Formats Import and Export Cell Basics Spreadsheet 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 Pivot Table Charting Printing Mail Merge Protection Adaptivity Keyboard Shortcuts Visual Elements Rich Text Editor Scheduler Site Navigation and Layout HTML Editor Gauges Vertical Grid Data Editors Docking and Popups File Management Data and Image Navigation Multi-Use Site Controls Spell Checker Query Builder ASP.NET MVC Extensions Localization Redistribution and Deployment Get More Help API Reference 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
View this topic on docs.devexpress.com (Learn more)

# Engineering Functions

This document briefly describes engineering functions implemented in the ASPxSpreadsheet.

Name

Description

Syntax

BESSELIReturns the modified Bessel function In(x).BESSELI(X, N)
BESSELJCalculates 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.
BESSELKReturns the modified Bessel function Kn(x).BESSELK(X, N)
BESSELYReturns the Bessel function Yn(x).BESSELY(X, N)
BIN2DECConverts a binary number to decimal.BIN2DEC(number)
BIN2HEXConverts 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.
BIN2OCTConverts 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.
BITANDReturns a 'Bitwise And' of two numbers.BITAND( number1, number2)
BITLSHIFTReturns a value number shifted left by shift_amount bits.BITLSHIFT(number, shift_amount)
BITORReturns a bitwise OR of 2 numbers.BITOR(number1, number2)
BITRSHIFTReturns a value number shifted right by shift_amount bits.BITRSHIFT(number, shift_amount)
BITXORReturns a bitwise 'Exclusive Or' of two numbers.BITXOR(number1, number2)
COMPLEXConverts 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".
CONVERTConverts 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.
DEC2BINConverts 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.
DEC2HEXConverts 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.
DEC2OCTConverts 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.
DELTATests whether two values are equal.DELTA(number1, number2)
ERFReturns the error function integrated between lower_limit and upper_limit.ERF(lower_limit,[upper_limit])
ERFCReturns the complementary ERF function integrated between x and infinity.ERFC(x)
ERFC.PRECISEReturns the complementary ERF function integrated between x and infinity.ERFC.PRECISE(x)
ERF.PRECISEReturns the error function integrated between 0 and a specified limit.ERF.PRECISE(x)
GESTEPReturns 1 if number = step; returns 0 (zero) otherwise. Use this function to filter a set of values. GESTEP(number,step)
HEX2BINConverts 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.
HEX2DECConverts a hexadecimal number to decimalHEX2DEC(number)
HEX2OCTConverts 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.
IMABSReturns the absolute value (the modulus) of a complex number.IMABS(inumber)
IMAGINARYReturns the imaginary coefficient of a complex number in x + yi or x + yj text format.IMAGINARY(inumber)
IMARGUMENTReturns the argument (an angle expressed in radians) of a complex number.IMARGUMENT(inumber)
IMCONJUGATEReturns the complex conjugate of a complex number in x + yi or x + yj text format.IMCONJUGATE(inumber)
IMCOSReturns the cosine of a complex numberIMCOS(inumber)
IMCOSHReturns the hyperbolic cosine of a complex number.IMCOSH(inumber)
IMCOTReturns the cotangent of a complex number.IMCOT(inumber)
IMCSC Returns the cosecant of a complex number.IMCSC(inumber)
IMCSCHReturns the hyperbolic cosecant of a complex number.IMCSCH(inumber)
IMDIVReturns the quotient of two complex numbers in x + yi or x + yj text format.IMDIV(inumber1,inumber2)
IMEXPReturns the exponential of a complex number in x + yi or x + yj text format.IMEXP(inumber)
IMLNReturns the natural logarithm of a complex number in x + yi or x + yj text format.IMLN(inumber)
IMLOG10Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.IMLOG10(inumber)
IMLOG2Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.IMLOG2(inumber)
IMPOWERReturns a complex number raised in the specified power.IMPOWER(inumber, number)
IMPRODUCTReturns the product of complex numbers in x + yi or x + yj text format.IMPRODUCT(inumber1,inumber2,...)
IMREALReturns the real coefficient of a complex number in x + yi or x + yj text format.IMREAL(inumber)
IMSECReturns the secant of a complex number.IMSEC(inumber)
IMSECHReturns the hyperbolic secant of a complex number.IMSECH(inumber)
IMSINReturns the sine of a complex number in x + yi or x + yj text format.IMSIN(inumber)
IMSINHReturns the hyperbolic sine of a complex number.IMSINH(inumber)
IMSQRTReturns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.IMSQRT(inumber)
IMSUBReturns the difference of two complex numbers in x + yi or x + yj text format.IMSUB(inumber1,inumber2)
IMSUMReturns the sum of complex numbers.IMSUM(inumber1, inumber2, ...)
IMTANReturns the tangent of a complex number.IMTAN(number)
OCT2BINConverts 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.
OCT2DECConverts an octal number to decimal.OCT2DEC(number)
OCT2HEXConverts 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?​​​​​​​