Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to combine 2 or more chart types in a single chart in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to Create Column Chart in Excel
  • How To Perform and Interpret Regression Analysis in Excel

References

  • How to get relative column numbers in a range in Excel
  • Extract data with helper column in Excel
  • Multi-criteria lookup and transpose in Excel
  • Two-way lookup with VLOOKUP in Excel
  • How to get last row in mixed data with blanks in Excel

Data Validations

  • Excel Data validation allow uppercase only
  • Excel Data validation date in next 30 days
  • Data validation must not exist in list
  • Excel Data validation date in specific year
  • Excel Data validation only dates between

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:

VLOOKUP without #N/A error in Excel

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

Logical Functions

  • Not Equal To ‘<>‘ operator in Excel
  • IF with wildcards in Excel
  • OR function Examples in Excel
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel OR Function

Date Time

  • Add decimal hours to time in Excel
  • Get days before a date in Excel
  • Get project midpoint in Excel
  • How to calculate Quarter of Date in Excel
  • How to calculate workdays per month in Excel

Grouping

  • Group times into 3 hour buckets in Excel
  • Categorize text with keywords in Excel
  • Group times into unequal buckets in Excel
  • If cell contains one of many things in Excel
  • Group numbers at uneven intervals in Excel

General

  • How to calculate percent variance in Excel
  • Hide and Unhide Columns or Rows in Excel
  • How to set or clear a print area in Excel Worksheet
  • 231 Keyboard Shortcut Keys In Excel
  • Using Existing Templates in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning