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

Data Analysis

  • Add Outline to Data in Excel
  • Understanding Anova in Excel
  • Filter Data Based on Date in Excel
  • How to Create Gantt Chart in Excel
  • Use Data Form to input, edit and delete records in Excel

References

  • How to use Excel INDIRECT Function
  • How to get address of first cell in range in Excel
  • Approximate match with multiple criteria in Excel
  • Excel Advanced Lookup using Index and Match Functions
  • How to calculate two-way lookup VLOOKUP in Excel Table

Data Validations

  • Excel Data validation require unique number
  • Excel Data validation number multiple 100
  • Excel Data validation with conditional list
  • Excel Data validation exists in list
  • Excel Data validation must contain specific text

Category: Engineering Functions

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

BIN2OCT function: Description, Usage, Syntax, Examples and Explanation

by

What is BIN2OCT function in Excel? BIN2OCT function is one of Engineering functions in Microsoft Excel that converts a binary number to octal. Syntax of BIN2OCT function BIN2OCT(number, [places]) The BIN2OCT function syntax has the following arguments: Number: The binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most …

Continue Reading

BIN2HEX function: Description, Usage, Syntax, Examples and Explanation

by

What is BIN2HEX function in Excel? BIN2HEX function is one of Engineering functions in Microsoft Excel that converts a binary number to hexadecimal. Syntax of BIN2HEX function BIN2HEX(number, [places]) The BIN2HEX function syntax has the following arguments: Number: The binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most …

Continue Reading

BIN2DEC function: Description, Usage, Syntax, Examples and Explanation

by

What is BIN2DEC function in Excel? BIN2DEC function is one of Engineering functions in Microsoft Excel that converts a binary number to decimal. Syntax of BIN2DEC function BIN2DEC(number) The BIN2DEC function syntax has the following arguments: Number: The binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most significant …

Continue Reading

BESSELY function: Description, Usage, Syntax, Examples and Explanation

by

What is BESSELY function in Excel? BESSELY function is one of Engineering functions in Microsoft Excel that returns the Bessel function, which is also called the Weber function or the Neumann function. Syntax of BESSELY function BESSELY(X, N) The BESSELY function syntax has the following arguments: X: The value at which to evaluate the function. N: …

Continue Reading

BESSELK function: Description, Usage, Syntax, Examples and Explanation

by

What is BESSELK function in Excel? BESSELK function is one of Engineering functions in Microsoft Excel that returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments. Syntax of BESSELK function BESSELK(X, N) The BESSELK function syntax has the following arguments: X: The value at which to evaluate the …

Continue Reading

BESSELJ function: Description, Usage, Syntax, Examples and Explanation

by

What is BESSELJ function in Excel? BESSELJ function is one of Engineering functions in Microsoft Excel that returns the Bessel function. Syntax of BESSELJ function BESSELJ(X, N) The BESSELJ function syntax has the following arguments: X: The value at which to evaluate the function. N: The order of the Bessel function. If n is not an …

Continue Reading

BESSELI function: Description, Usage, Syntax, Examples and Explanation

by

What is BESSELI function in Excel? BESSELI function is one of Engineering functions in Microsoft Excel that returns the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments. Syntax of BESSELI function BESSELI(X, N) The BESSELI function syntax has the following arguments: X: The value at which to evaluate the …

Continue Reading

HEX2BIN function: Description, Usage, Syntax, Examples and Explanation

by

What is HEX2BIN function in Excel? HEX2BIN function is one of Engineering functions in Microsoft Excel that converts a hexadecimal number to binary. Syntax of HEX2BIN function HEX2BIN(number, [places]) The HEX2BIN function syntax has the following arguments: Number    Required. The hexadecimal number you want to convert. Number cannot contain more than 10 characters. The most significant bit …

Continue Reading

GESTEP function: Description, Usage, Syntax, Examples and Explanation

by

What is GESTEP function in Excel? GESTEP function is one of Engineering functions in Microsoft Excel that returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values. For example, by summing several GESTEP functions you calculate the count of values that exceed a threshold. Syntax of GESTEP …

Continue Reading

ERFC.PRECISE function: Description, Usage, Syntax, Examples and Explanation

by

What is ERFC.PRECISE function in Excel? ERFC.PRECISE function is one of Engineering functions in Microsoft Excel that returns the complementary ERF function integrated between x and infinity. Syntax of ERFC.PRECISE function ERFC.PRECISE(x) The ERFC.PRECISE function syntax has the following arguments: X: The lower bound for integrating ERFC.PRECISE. ERFC.PRECISE formula explanation If x is nonnumeric, ERFC.PRECISE returns the …

Continue Reading

DEC2OCT function: Description, Usage, Syntax, Examples and Explanation

by

What is DEC2OCT function in Excel? DEC2OCT function is one of Engineering functions in Microsoft Excel that converts a decimal number to octal. Syntax of DEC2OCT function DEC2OCT(number, [places]) The DEC2OCT function syntax has the following arguments: Number: The decimal integer you want to convert. If number is negative, places is ignored and DEC2OCT returns a …

Continue Reading

CONVERT function: Description, Usage, Syntax, Examples and Explanation

by

What is CONVERT function in Excel? CONVERT function is one of Engineering functions in Microsoft Excel that converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. Syntax of CONVERT function CONVERT(number,from_unit,to_unit) Number     is the value in from_units to …

Continue Reading

DEC2HEX function: Description, Usage, Syntax, Examples and Explanation

by

What is DEC2HEX function in Excel? DEC2HEX function is one of Engineering functions in Microsoft Excel that converts a decimal number to hexadecimal. Syntax of DEC2HEX function DEC2HEX(number, [places]) The DEC2HEX function syntax has the following arguments: Number:  The decimal integer you want to convert. If number is negative, places is ignored and DEC2HEX returns a …

Continue Reading

IMEXP function: Description, Usage, Syntax, Examples and Explanation

by

What is IMEXP function in Excel? IMEXP function is one of Engineering functions in Microsoft Excel that returns the exponential of a complex number in x + yi or x + yj text format. Syntax of IMEXP function IMEXP(inumber) The IMEXP function syntax has the following arguments: Inumber: A complex number for which you want the exponential. …

Continue Reading

Posts navigation

  • Previous
  • 1
  • 2

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

  • How to use Excel OR Function
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • Invoice status with nested if in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel

Date Time

  • How to calculate future date say 6 months ahead in Excel
  • Get first day of previous month in Excel
  • Get days, hours, and minutes between dates in Excel
  • Create date range from two dates in Excel
  • How to calculate Quarter of Date in Excel

Grouping

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

General

  • Common Errors in Excel
  • Find, Select, Replace and Go To Special in Excel
  • 3D SUMIF for multiple worksheets in Excel
  • How to calculate percentage discount in Excel
  • Automatically fill series of cells in Excel using AutoFill
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning