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...

How to use the XOR function in Excel

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube