How to use the EOMONTH function

The EOMONTH function returns an Excel date for the last day of a given month using a number and a start […]

How to use the EOMONTH function

The EOMONTH function returns an Excel date for the last day of a given month using a number and a start […]

How to use the ENCODEURL function

The ENCODEURL function returns a URL-encoded string. Formula in cell C3: =ENCODEURL(B3) Excel Function Syntax ENCODEURL(text) Arguments text Required. The […]

How to use the EFFECT function

The EFFECT function calculates the effective annual interest rate, given the nominal annual interest rate and the number of compounding […]

How to use the DEC2OCT function

The DEC2OCT function converts a decimal number to an octal number. Formula in cell D3: =DEC2OCT(B3,C3) Excel Function Syntax DEC2OCT(number, […]

How to use the DEC2HEX function

The DEC2HEX function converts a decimal number to a hexadecimal number. Formula in cell D3: =DEC2HEX(B3,C3) Excel Function Syntax DEC2HEX(number, […]

How to use the DEC2BIN function

The DEC2BIN function converts a decimal number to a binary number. Formula in cell D3: =DEC2BIN(B3,C3) Excel Function Syntax DEC2BIN(number, […]

How to use the DECIMAL function

The DECIMAL function converts a text representation of a number in a given base into a decimal number. Formula in […]

How to use the CONVERT function

The CONVERT function converts a number from one measurement system to another. Formula in cell E3: =CONVERT(B3, C3, D3) The […]

DATEVALUE function not working

The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. However, it must […]

How to use the CONFIDENCE function

The CONFIDENCE function calculates the confidence interval for a population mean, using a normal distribution. Formula in cell B6: =CONFIDENCE(B3, […]

How to use the CORREL function

The CORREL function calculates the correlation between two groups of numbers. Formula in cell B12: =CORREL(C3:C9, D3:D9) The value in cell […]

How to use the CONCAT function

The CONCAT function concatenates values from multiple cells. There is, however, no delimiting character or a way to ignore empty […]

How to use the COMPLEX function

The COMPLEX function returns a complex number based on a real and imaginary number. Formula in cell B3: =COMPLEX(2,3) Excel […]

How to use the CEILING function

The CEILING function rounds a number up to its nearest multiple. The number is rounded down if both the number […]

How to use the AVERAGEA function

The AVERAGEA function returns the average of a group of values. Text and boolean value FALSE evaluates to 0. TRUE to […]

How to use the TIMEVALUE function

The TIMEVALUE function returns a decimal number based on a text string. Excel uses decimal numbers between 0 and 0.99988426 […]

Match a range value containing both text and numerical characters

Formula in cell C11: =LOOKUP(MID(C10, 4, 999)*1, MID(B3:B8, 4, 999)*1, D3:D8) This formula is an array formula. To enter an array […]

How to use the SWITCH function

The SWITCH function returns a given value determined by an expression and a list of values. If the expression matches […]

How to use the STDEVA function

The STDEVA function estimates the standard deviation from a sample of values. Standard deviation shows how much the values differ […]

How to use the SHEETS function

The SHEETS function returns the number of sheets in a reference. It returns the number of sheets in a workbook if […]

How to use the MROUND function

The MROUND function calculates a number rounded to a given multiple. Formula in cell D3: =MROUND(B3,C3) Excel Function Syntax MROUND(number, […]

SMALL function with multiple cell ranges

Today I learned how to sort numbers from multiple cell ranges thanks to Sam Miller. It is surprisingly simple and easy. […]

The SIGN function returns the sign of a number. 1 for a positiv number, 0 (zero) for a 0 (zero) […]

How to use the MODEMULT function

The MODE.MULT function calculates the most frequent number in a cell range. It will return multiple numbers if they are equally […]

How to use the MEDIAN function

The MEDIAN function calculates the median based on a group of numbers. The median is the middle number of a […]

How to use the PERMUTATIONA function

The PERMUTATIONA function returns the number of permutations for a specific number of elements that can be selected from a […]

How to use the COMBINA function

The COMBINA function calculates the number of combinations for a given number of elements from a larger group of elements. Formula in […]

How to filter using OR logic between columns [Formula]

The filter feature in Excel won't allow you to do OR logic between columns, however, you can if you allow […]

How to filter using OR logic between columns [Advanced Filter]

The built-in filter feature in Excel is a powerful tool, however, it won't allow you to filter with OR logic […]

How to use the PRODUCT function

The PRODUCT function returns the product of the numbers given in the argument. Formula in cell D3: =PRODUCT(B3:C3) Excel Function […]

Rearrange cells in a cell range to vertically distributed values

The formula in cell B8 uses a named range to calculate the row and column needed to extract the correct […]