### Iteration in Excel 2007

To intentionally use a Circular Reference: In this example, a Value-added tax (VAT) gross-up formula is in cell B1 (the formula is =B3-B2). 1. In ...

### BITLSHIFT function

BITLSHIFT function This function introduced in Excel 2013 and it returns a  number shifted left by bits specified as numbers For example, binar...

### BITXOR function

BITXOR function BITXOR function has been introduced with Excel 2013 and this function returns the bitwise XOR of two numbers. For example, Binar...

### XOR function

In this article, we will learn about how to use the XOR function in Excel. In simple words, logic_test are performed in excel to perform an action ...

### How to Delete Range Name in Excel

In Microsoft Excel if you want to remove named range, it is a very simple task. First, let’s create a Name Range so that we can understand it in a b...

### Finding a substring within a string

Problem: Determining whether the strings in column C contain the corresponding substrings in column D. Solution 1: Using the COUNTIF function in ...

### Creating Formulas that Only Return Results from Non-Blank Cells in Microsoft Excel 2010

In this article, we perform a logical test to get results from non-blank cells. We will use IF & ISBLANK function. The mathematical formulation...

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.