### MUNIT function

MUNIT function Munit function has been introduced with Excel 2013.  It returns the unit matrix for the specifid dimension. For example, you can ...

### BITOR function

BITOR function This function has been introduced with Excel 2013 and it returns bit-wise "OR" of 2 numbers. For example, binary representation o...

### UNICODE function

UNICODE is a new function introduced in Excel 2013. This function is used to return the code number of the first character of the text in reference...

### IFERROR Function - New Function in Excel 2007

In this article, we will learn where and how we can use Excel formula IFERROR. What is IFERROR function? The IFERROR function Returns a value you sp...

### Calculating Average Annual Growth

Problem: Columns A & B show annual profits for a number of years. We want to calculate the average rate at which profits grew each year. So...

### BITAND function

BITAND function This function lunched with Excel 2013 and it returns a bitwise "AND" of two numbers. Example:- The binary number for 5 is 101 an...

### Ranking Numbers in a Dynamic List

Problem: Range A4:A8 contains a list of numbers that is frequently changed by the addition or removal of numbers. Consequently, the current rank of...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.