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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube