Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Extract all partial matches in Excel
  • Approximate match with multiple criteria in Excel
  • How to get relative row numbers in a range in Excel
  • How to get first row number in range in Excel
  • Vlookup Examples in Excel

Data Analysis Examples

  • How to Create Thermometer Chart in Excel
  • Get column index in Excel Table
  • How to create dynamic reference table name in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • How to Use Solver Tool in Excel

Data Validation Examples

  • Excel Data validation exists in list
  • Excel Data validation with conditional list
  • Excel Data validation allow weekday only
  • Excel Data validation must begin with
  • Excel Data validation number multiple 100

Complete List of Excel Engineering Functions References and Examples

by

Excel Engineering Functions perform the most commonly used engineering calculations, many of which relate to Bessel Functions, Complex Numbers or converting between different bases.

Here’s a full list of Built-In Engineering Functions in Excel and their Descriptions below:

Click each of the function link to see detailed example.

Converting Between Units of Measurement

CONVERT Converts a number from one measurement system to another

Bessel Functions

BESSELI Calculates the modified Bessel function In(x)
BESSELJ Calculates the Bessel function Jn(x)
BESSELK Calculates the modified Bessel function Kn(x)
BESSELY Calculates the modified Bessel function Yn(x)

Converting Between Bases

BIN2DEC Converts a binary number to a decimal
BIN2HEX Converts a binary number to hexadecimal
BIN2OCT Converts a binary number to octal
DEC2BIN Converts a decimal number to binary
DEC2HEX Converts a decimal number to hexadecimal
DEC2OCT Converts a decimal number to octal
HEX2BIN Converts a hexadecimal number to binary
HEX2DEC Converts a hexadecimal number to a decimal
HEX2OCT Converts a hexadecimal number to octal
OCT2BIN Converts octal number to binary
OCT2DEC Converts octal number to a decimal
OCT2HEX Converts octal number to hexadecimal

The Error Function

ERF Returns the error function integrated between two supplied limits
ERF.PRECISE Returns the error function integrated between 0 and a supplied limit (New in Excel 2010)
ERFC Returns the complementary error function integrated between a supplied lower limit and infinity
ERFC.PRECISE Returns the complementary error function integrated between a supplied lower limit and infinity (New in Excel 2010)

Bitwise Functions

BITAND Returns a Bitwise ‘And’ of two numbers (New in Excel 2013)
BITOR Returns a Bitwise ‘Or’ of two numbers (New in Excel 2013)
BITXOR Returns a Bitwise ‘Exclusive Or’ of two numbers (New in Excel 2013)
BITLSHIFT Returns a number shifted left by a specified number of bits (New in Excel 2013)
BITRSHIFT Returns a number shifted right by a specified number of bits (New in Excel 2013)
Testing Numeric Values
DELTA Tests whether two supplied numbers are equal
GESTEP Tests whether a number is greater than a supplied threshold value

Complex Numbers

COMPLEX Converts user-supplied real and imaginary coefficients into a complex number
IMABS Returns the absolute value (the modulus) of a complex number
IMAGINARY Returns the imaginary coefficient of a complex number
IMARGUMENT Returns the argument Θ (an angle expressed in radians) of a complex number
IMCONJUGATE Returns the complex conjugate of a complex number
IMCOS Returns the cosine of a complex number
IMCOSH Returns the hyperbolic cosine of a complex number (New in Excel 2013)
IMCOT Returns the cotangent of a complex number (New in Excel 2013)
IMCSC Returns the cosecant of a complex number (New in Excel 2013)
IMCSCH Returns the hyperbolic cosecant of a complex number (New in Excel 2013)
IMDIV Returns the quotient of two supplied complex numbers
IMEXP Returns the exponential of a complex number
IMLN Returns the natural logarithm of a complex number
IMLOG10 Returns the base-10 logarithm of a complex number
IMLOG2 Returns the base-2 logarithm of a complex number
IMPOWER Calculates a complex number raised to a supplied power
IMPRODUCT Returns the product of up to 255 supplied complex numbers
IMREAL Returns the real coefficient of a complex number
IMSEC Returns the secant of a complex number (New in Excel 2013)
IMSECH Returns the hyperbolic secant of a complex number (New in Excel 2013)
IMSIN Returns the sine of a complex number
IMSINH Returns the hyperbolic sine of a complex number (New in Excel 2013)
IMSQRT Returns the square root of a complex number
IMSUB Subtracts two complex numbers
IMSUM Calculates the sum of two complex numbers
IMTAN Returns the tangent of a complex number (New in Excel 2013)

 

Post navigation

Previous Post:

Complete List of Excel Financial Functions References and Examples

Next Post:

Complete List of Excel Cube Functions References and Examples

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Excel MAX, MATCH and ADDRESS function illustration
  • Get position of 2nd 3rd and more instance of character in Excel
  • Extract most frequently occurring text in Excel
  • How to split text string at specific character in Excel
  • How to pad text to match equal length in Excel
  • Get days between dates in Excel
  • Sum race time splits in Excel
  • Calculate years between dates in Excel
  • Convert date to text in Excel
  • Get fiscal year from date in Excel
  • PRICEMAT function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate compound interest in Excel
  • DOLLARFR function: Description, Usage, Syntax, Examples and Explanation
  • DB function: Description, Usage, Syntax, Examples and Explanation
  • COUPNCD function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles