Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  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]Pivot Grid
  [Expand]Tree List
  [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]Spreadsheet 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
     Formula Engine
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Printing
    Events
   [Expand]Mail Merge Overview
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]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]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]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.

How would you rate this topic?​​​​​​​