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

Data Analysis

  • How to sum a total in multiple Excel tables
  • How To Create Frequency Distribution in Excel
  • How to count table columns in Excel
  • Reverse List in Excel
  • Get column index in Excel Table

References

  • How to get relative row numbers in a range in Excel
  • How to get first column number in range in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • How to get last row in text data in Excel
  • Merge tables with VLOOKUP in Excel

Data Validations

  • How To Create Drop-down List in Excel
  • Excel Data validation no punctuation
  • Excel Data validation exists in list
  • Excel Data validation allow uppercase only
  • Data validation must not exist in list

Category: Excel Functions

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

by

What is EDATE function in Excel? EDATE function is one of Date and Time functions in Microsoft Excel that returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of …

Continue Reading

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

by

What is DAYS360 function in Excel? DAYS360 function is one of Date and Time functions in Microsoft Excel that returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve …

Continue Reading

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

by

What is MONTH function in Excel? MONTH function is one of Date and Time functions in Microsoft Excel that returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December). Syntax of MONTH function MONTH(serial_number) The MONTH function syntax has the following arguments: Serial_number    Required. …

Continue Reading

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

by

What is NETWORKDAYS function in Excel? NETWORKDAYS function is one of Date and Time functions in Microsoft Excel that returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during …

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

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

by

What is COMPLEX function in Excel? COMPLEX function is one of Engineering functions in Microsoft Excel that converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. Syntax of COMPLEX function COMPLEX(real_num, i_num, [suffix]) The COMPLEX function syntax has the following arguments: Real_num: The real coefficient of the …

Continue Reading

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

by

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

Continue Reading

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

by

What is BITLSHIFT function in Excel? BITLSHIFT function is one of Engineering functions in Microsoft Excel that returns a number shifted left by the specified number of bits. Syntax of BITLSHIFT function BITLSHIFT(number, shift_amount) The BITLSHIFT function syntax has the following arguments. Number    Required. Number must be an integer greater than or equal to 0. Shift_amount    …

Continue Reading

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

by

What is BITAND function in Excel? BITAND function is one of Engineering functions in Microsoft Excel that returns a bitwise ‘AND’ of two numbers. Syntax of BITAND function BITAND( number1, number2) The BITAND function syntax has the following arguments. Number1: Must be in decimal form and greater than or equal to 0. Number2: Must be in …

Continue Reading

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

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

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

by

What is BITXOR function in Excel? BITXOR function is one of Engineering functions in Microsoft Excel that returns a bitwise ‘XOR’ of two numbers. Syntax of BITXOR function BITXOR(number1, number2) The BITXOR function syntax has the following arguments. Number1: Must be greater than or equal to 0. Number2: Must be greater than or equal to 0. BITXOR …

Continue Reading

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

by

What is BITRSHIFT function in Excel? BITRSHIFT function is one of Engineering functions in Microsoft Excel that returns a number shifted right by the specified number of bits. Syntax of BITRSHIFT function BITRSHIFT(number, shift_amount) The BITRSHIFT function syntax has the following arguments. Number: Must be an integer greater than or equal to 0. Shift_amount: Must be …

Continue Reading

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

by

What is BITOR function in Excel? BITOR function is one of Engineering functions in Microsoft Excel that returns a bitwise ‘OR’ of two numbers. Syntax of BITOR function BITOR(number1, number2) The BITOR function syntax has the following arguments. Number1: Must be in decimal form and greater than or equal to 0. Number2: Must be in decimal …

Continue Reading

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

by

What is DELTA function in Excel? DELTA function is one of Engineering functions in Microsoft Excel that tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. …

Continue Reading

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

by

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

Continue Reading

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

by

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

Continue Reading

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

by

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

Continue Reading

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

by

What is IMARGUMENT function in Excel? IMARGUMENT function is one of Engineering functions in Microsoft Excel that returns the argument  (theta), an angle expressed in radians, such that: Syntax of IMARGUMENT function IMARGUMENT(inumber) The IMARGUMENT function syntax has the following arguments: Inumber: A complex number for which you want the argument  . IMARGUMENT formula explanation Use COMPLEX to …

Continue Reading

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

by

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

Continue Reading

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

by

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

Continue Reading

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

by

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

Continue Reading

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

by

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

Continue Reading

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

by

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

Continue Reading

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

by

What is ERF.PRECISE function in Excel? IMCOT function is one of Engineering functions in Microsoft Excel that returns the error function. Syntax of ERF.PRECISE function ERF.PRECISE(x) The ERF.PRECISE function syntax has the following argument: X:  The lower bound for integrating ERF.PRECISE. ERF.PRECISE formula expalantion If lower_limit is nonnumeric, ERF.PRECISE returns the #VALUE! error value. Example of ERF.PRECISE function …

Continue Reading

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

by

What is ERF function in Excel? ERF function is one of Engineering functions in Microsoft Excel that returns the error function integrated between lower_limit and upper_limit. Syntax of ERF function ERF(lower_limit,[upper_limit]) The ERF function syntax has the following arguments: Lower_limit: The lower bound for integrating ERF. Upper_limit(Optional): The upper bound for integrating ERF. If omitted, ERF integrates …

Continue Reading

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

by

What is OCT2HEX function in Excel? OCT2HEX function is one of Engineering functions in Microsoft Excel that converts an octal number to hexadecimal. Syntax of OCT2HEX function OCT2HEX(number, [places]) The OCT2HEX function syntax has the following arguments: Number: The octal number you want to convert. Number may not contain more than 10 octal characters (30 bits). The …

Continue Reading

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

by

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

Continue Reading

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

by

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

Continue Reading

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

by

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

Continue Reading

Posts navigation

  • Previous
  • 1
  • 2
  • 3
  • 4
  • 5
  • …
  • 21
  • Next

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

  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • How to return blank in place of #DIV/0! error in Excel
  • Complete List of Excel Logical Functions, References and Examples
  • OR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate nth day of year in Excel
  • Two ways to sum time over 30 minutes in Excel
  • Get days, hours, and minutes between dates in Excel
  • Convert date to text in Excel

Grouping

  • How to randomly assign people to groups in Excel
  • Group numbers with VLOOKUP in Excel
  • How to randomly assign data to groups in Excel
  • Group arbitrary text values in Excel
  • Categorize text with keywords in Excel

General

  • How to count total number of cells in a rectangular range in Excel
  • How to calculate percent variance in Excel
  • Check if range contains a value not in another range in Excel
  • Split Cell Content Using Text to Columns in Excel
  • Basic numeric sort formula in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning