General Information WinForms Controls 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 Chart Control Diagrams Gauges Map Control Scheduler Spreadsheet Product Information Product Structure Getting Started Spreadsheet Document Supported Formats 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) Real Time Data (RTD) function Operators Array Formulas Calculation Formula Engine Formula AutoComplete Defined Names Data Binding Data Validation Data Presentation Data Grouping Pivot Table Overview Charting Overview Shapes Printing Events Mail Merge Overview Protection Find and Replace Visual Elements Services 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

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.