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 […]
Check out the new formula page
Latest modified blog articles
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 […]
The NOT function returns the boolean opposite to the given argument. TRUE returns FALSE and FALSE returns TRUE. Formula in […]
The OR function allows you to carry out a logical test in each argument and if at least one argument returns […]
The image above demonstrates the AND function with two logical expressions. If the value in column B is equal to […]
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 […]
The picture above shows you values that have multiple leading and trailing blanks, sometimes also multiple blanks between words. The […]
The MIN function allows you to retrieve the smallest number in a cell range. The formula in cell D3 extracts […]
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 […]
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 […]
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: […]
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 […]
The YIELD function calculates the yield for a security that pays interest. The YIELD function is designed to calculate the […]
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 […]
The PPMT function calculates the principal payment for a specific period for an investment based on repeated constant payments and a […]
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 […]
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 […]
The IPMT function calculates the interest payment for a specific period for an investment based on repeated constant payments and a […]
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 […]
The VDB function calculates the depreciation of an asset for a given period using the double-declining balance method or based […]
The SYD function calculates the yearly asset depreciation of a given year. Formula in cell C6: =SYD(C2,C3,C4,C5) Excel Function Syntax […]
The DDB function calculates the depreciation of an asset for a given period using the double-declining balance method or based […]
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 […]
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 […]
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 […]
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 […]
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 […]
The EDATE function returns a date determined by a start date and a number representing how many months. Use EDATE […]
The DATE function calculates the number of days between two dates. Formula in cell D3: =DAYS(B3,C3) Excel Function Syntax DAYS(end_date, […]
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 […]
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. […]
Converts negative numbers to positive numbers, in other words, the ABS function removes the sign. Table of Contents ABS 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 […]