Check out the new formula page

Latest modified blog articles

How to use the AGGREGATE function

The AGGREGATE function allows you to calculate different specific functions to a list or database. A special AGGREGATE function feature […]

How to use the JOIN function [VBA]

The JOIN function concatenates a set of substrings in an array, the image shows a user-defined function entered in cell […]

How to use the RANDARRAY function

The RANDARRAY function returns a table of random numbers across rows and columns. It is located in the Math and […]

Working with COMBO BOXES [Form Controls]

This blog post demonstrates how to create, populate and change comboboxes (form control) programmatically. Form controls are not as flexible […]

How to use the UNIQUE function

The UNIQUE function is a very versatile Excel function, it lets you extract both unique and unique distinct values and […]

How to use the NOT function

The NOT function returns the boolean opposite to the given argument. TRUE returns FALSE and FALSE returns TRUE. Formula in […]

How to use the OR function

The OR function allows you to carry out a logical test in each argument and if at least one argument returns […]

How to use the AND function

The image above demonstrates the AND function with two logical expressions. If the value in column B is equal to […]

How to use the XOR function

The XOR function was introduced in Excel 2013 and calculates the logical exclusive OR meaning if at least one of the […]

Rearrange values in a cell range to a single column

This article demonstrates formulas that rearrange values in a cell range to a single column. Table of Contents Rearrange cells […]

How to use the COMBIN function

The COMBIN function returns the number of combinations for a specific number of elements out of a larger number of […]

How to use the RANGE.FIND method

The Range.Find method returns a range object for the first cell that matches the lookup value. Macro used in workbook above The […]

How to use the PERMUT function

The PERMUT function returns the number of permutations for a set of elements that can be selected from a larger […]

How to use the TRIM function

The picture above shows you values that have multiple leading and trailing blanks, sometimes also multiple blanks between words. The […]

How to use the MIN function

The MIN function allows you to retrieve the smallest number in a cell range. The formula in cell D3 extracts […]

How to use the INDEX function

Gets a value in a specific cell range based on a row and column number.

How to use the STOCKHISTORY function

The STOCKHISTORY function lets you get stock prices based on a stock quote. It is in the Lookup and reference […]

Unique distinct values sorted based on frequency

What's on this page Unique distinct values sorted based on frequency Unique distinct values sorted based on frequency - Excel […]

Extract a unique distinct list across multiple columns and rows sorted based on frequency

Cell range B2:E11 contains values, the formula in cell B15 extracts unique distinct values in B2:E11, ignores blanks, and returns […]

How to use the SMALL function

The SMALL function lets you extract a number in a cell range based on how small it is compared to the other numbers in the group.

How to use the CHOOSE function

The CHOOSE function lets you get a value based on a number, the number determines which value to get. The […]

How to use the TEXTJOIN function

The TEXTJOIN function is a relatively new function introduced in Excel 2019, it is like the CONCATENATE function on steroids […]

How to use the CONCATENATE function

The CONCATENATE function lets you add text strings into one single text string. The function has been replaced by the […]

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 AVEDEV function

The AVEDEV function calculates the average of the absolute deviations of data points from their mean. The absolute deviation from the […]

How to use the STANDARDIZE function

The STANDARDIZE function calculates a normalized value from a distribution characterized by mean and standard_dev. Formula in cell C5: =STANDARDIZE(C2, […]

How to use the NORM.INV function

The NORM.INV function calculates the inverse of the normal cumulative distribution for a given mean and standard deviation. Formula in […]

How to use the PHI function

The PHI function calculates a number of the density function for a standard normal distribution. Formula in cell C3: =PHI(B3) Excel […]

How to use the NORM.DIST function

The NORM.DIST function calculates the normal distribution for a given mean and standard deviation. Formula in cell C7: =NORM.DIST(C2,C3,C4,C5) Excel […]

How to use the LOGNORMDIST function

The LOGNORMDIST function calculates the cumulative lognormal distribution of argument x, based on a normally distributed ln(x) with the arguments of […]

How to use the LOGNORM.DIST function

The LOGNORMDIST function calculates the lognormal distribution of argument x, based on a normally distributed ln(x) with the arguments of mean and standard_dev. This […]

How to use the GAMMA.DIST function

The GAMMA.DIST function calculates the gamma often used in queuing analysis (probability statistics) that may have a skewed distribution. This […]

How to use the CONFIDENCE.T function

The CONFIDENCE.T function calculates the confidence range for a population mean using a Student's t distribution. Formula in cell C7: […]

How to use the FDIST function

The FDIST function calculates the F probability of the right-tailed distribution for two tests. This function is outdated and is […]

How to use the EXPON.DIST function

The EXPON.DIST function calculates the exponential distribution representing an outcome in the form of probability. This function was introduced in Excel […]

How to use the CRITBINOM function

The CRITBINOM function calculates the minimum value for which the binomial distribution is equal to or greater than a given […]

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 CHITEST function

The CHITEST function calculates the test for independence, the value returned from the chi-squared statistical distribution and the correct degrees […]

How to use the CHISQ.TEST function

The CHISQ.TEST function calculates the test for independence, the value returned from the chi-squared statistical distribution and the correct degrees […]

How to use the CHISQ.INV function

The CHISQ.INV function was introduced in Excel 2010 and calculates the inverse of the left-tailed probability of the chi-squared distribution. […]

How to use the CHISQ.DIST.RT function

The CHISQ.DIST.RT function was introduced in Excel 2010 and calculates the right-tailed probability of the chi-squared distribution. It has replaced the […]

How to use the CHISQ.DIST function

The CHISQ.DIST function calculates the probability of the chi-squared distribution. Use this function to check if a hypothesize is valid. It […]

How to use the CHIDIST function

The CHIDIST function calculates the probability of the chi-squared distribution. Use this function to check if a hypothesize is valid. The […]

How to use the BINOMDIST function

The BINOMDIST function calculates the individual term binomial distribution probability, use this function when the success probability is constant through […]

How to use the BINOM.INV function

The BINOM.INV  function calculates the minimum value for which the binomial distribution is equal to or greater than a given […]

How to use the BINOM.DIST function

The BINOM.DIST function calculates the individual term binomial distribution probability, use this function when the success probability is constant through […]

How to use the BETADIST function

The BETADIST function calculates the beta distribution representing an outcome in the form of probability. This function is in the compatibility […]

How to use the BETA.INV function

The BETA.INV function calculates the inverse of the cumulative beta distribution. This function has replaced the BETA.INV function and was […]

How to use the BETA.DIST function

The BETA.DIST function calculates the beta distribution. It represents outcomes in the form of probabilities. This function was introduced in Excel […]

How to use the YIELD function

The YIELD function calculates the yield for a security that pays interest. The YIELD function is designed to calculate the […]

How to use the RATE function

The RATE function returns the interest rate per period of an annuity. Formula in cell E3: =RATE(B3,C3,D3) Excel Function Syntax […]

How to use the PRICEMAT function

The PRICEMAT function calculates the price per $100 nominal value of a bond that pays interest at maturity. Formula in […]

How to use the PPMT function

The PPMT function calculates the principal payment for a specific period for an investment based on repeated constant payments and a […]

How to use the PMT function

The PMT function returns the payment amount needed for borrowing a fixed sum of money based on constant payments and […]

How to use the NOMINAL function

The NOMINAL function calculates the nominal annual interest rate based on the effective rate and the number of compounding periods […]

How to use the ISPMT function

The ISPMT calculates the interest paid during a specific period of an investment. Formula in cell B3: =ISPMT(0.1/12,1,4*12,10000) Excel Function […]

How to use the IPMT function

The IPMT function calculates the interest payment for a specific period for an investment based on repeated constant payments and a […]

How to use the FV function

The FV function returns the future value of an investment based on a constant interest rate. You can use FV […]

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 CUMIPMT function

The CUMIPMT function calculates the accumulated interest based on a start and end period on a loan. The image above shows […]

How to use the ACCRINTM function

The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity. Formula in cell C7: =ACCRINTM(C2,C3,C4,C5,C6) […]

How to use the ACCRINT function

The ACCRINT function calculates the accrued interest for a security that pays periodic interest. Formula in cell C9: =ACCRINT(C2,C3,C4,C5,C6,C7,C8) Excel […]

How to use the VDB function

The VDB function calculates the depreciation of an asset for a given period using the double-declining balance method or based […]

How to use the SYD function

The SYD function calculates the yearly asset depreciation of a given year. Formula in cell C6: =SYD(C2,C3,C4,C5) Excel Function Syntax […]

How to use the DDB function

The DDB function calculates the depreciation of an asset for a given period using the double-declining balance method or based […]

How to use the DB function

The DB function calculates the depreciation of an asset for a given period using the fixed-declining balance method. Formula in […]

How to use the AMORLINC function

The AMORLINC function calculates the depreciation for each accounting period. This function is designed for the French accounting system. Formula […]

How to use the AMORDEGRC function

The AMORDEGRC function calculates the depreciation for each accounting period. This function is designed for the French accounting system. Formula […]

How to use the BITXOR function

The BITXOR function calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. XOR […]

How to use the BITRSHIFT function

The BITRSHIFT function calculates the number where the binary equivalent is shifted right by a specified number of bits and […]

How to use the BITOR function

The BITOR function performs a bitwise 'OR' of two numbers. Bitwise meaning each digit in the binary equivalent. Formula in […]

How to use the BITAND function

The BITAND function calculates a bitwise 'AND' of two numbers. The function performs AND logic bit by bit on the numbers […]

How to use the BITLSHIFT function

The BITLSHIFT function calculates a number whose binary representation is shifted left by a specified number of bits. Formula in […]

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 BIN2OCT function

The BIN2OCT function converts a binary number to octal. Formula in cell B3: =BIN2OCT(11001) Excel Function Syntax BIN2OCT(number,[places]) Arguments number […]

How to use the BIN2DEC function

The BIN2DEC function converts a binary number to decimal. Formula in cell B3: =BIN2DEC(11001) Excel Function Syntax BIN2DEC(number) Arguments number […]

How to use the BIN2HEX function

The BIN2HEX function converts a binary number to hexadecimal. Formula in cell B3: =BIN2HEX(11001) Excel Function Syntax BIN2HEX(number,[places]) Arguments number […]

How to use the CHOOSECOLS function

The CHOOSECOLS function returns given columns from a cell range or array. Dynamic array formula in cell B9: =CHOOSECOLS(B2:D5, 2, […]

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 create random numbers, text strings, dates and time values

The RAND() function In Excel returns a number greater than or equal to 0 (zero) and less than 1. Combining […]

How to use the YEARFRAC function

The YEARFRAC function returns the fraction of the year based on the number of whole days between a start date […]

How to use the YEAR function

The YEAR function converts a date to a number representing the year in the date. The number is between 1900 […]

How to use the WORKDAY function

The WORKDAY function returns a date based on a start date and a given number of working days (nonweekend and […]

How to use the TODAY function

The TODAY function returns the Excel date (serial number) of the current date. Warning! This function is volatile meaning it […]

How to use the NETWORKDAYS function

The NETWORKDAYS function returns the number of working days between two dates, excluding weekends. It also allows you to ignore […]

How to use the MONTH function

The MONTH function extracts the month as a number from an Excel date. 1 - January 2 - February 3 […]

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 EDATE function

The EDATE function returns a date determined by a start date and a number representing how many months. Use EDATE […]

How to use the DAYS function

The DATE function calculates the number of days between two dates. Formula in cell D3: =DAYS(B3,C3) Excel Function Syntax DAYS(end_date, […]

How to use the DAY function

The DAY function extracts the day as a number from an Excel date. Table of Contents DAY Function Syntax DAY […]

How to use the DATEDIF function

The DATEDIF function returns the number of days, months, or years between two dates. The DATEDIF function exists in order to […]

How to use the DATE function

The DATE function returns a number that acts as a date in the Excel environment. The image above shows you […]

How to use the DATEVALUE function

The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. Excel Function Syntax […]

How to use the INDIRECT function

The INDIRECT function returns the cell reference based on a text string and shows the content of that cell reference. […]

How to use the ABS function

Converts negative numbers to positive numbers, in other words, the ABS function removes the sign. Table of Contents ABS Function […]

How to use the SORT function

The SORT function lets you sort values from a cell range or array. It returns an array with a size […]

Improve your VLOOKUP formula and return multiple values

Question: How do i return multiple results for one lookup value? I have tried to use multiple vlookups, with no […]

How to use the PERCENTRANK.INC function

The PERCENTRANK.INC function calculates the percent rank of a given number compared to the whole data set. The image above […]