# Category Archives: Formula

## Excel XOR function

Excel Version in which XOR function can work: Excel XOR function will work in Excel 2016 Excel 2013 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones. About Excel XOR function: XOR function… Read more »

## How to use excel IFS function

Excel Version in which IFS function can work: Excel IFS function will work in Excel 2016, Excel Online, Excel for Android tablets, Excel Mobile, Excel for Android phones. About excel IFS function: Excel IFS function checks multiple condition and returns value for first TRUE condition. IFS function can be used… Read more »

## How to use Excel AND Function (as Worksheet Function)

Excel Version in which AND function can work: AND function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About AND… Read more »

## MID function in excel worksheet

Excel Version in which MID function can work: MID function will work in Excel 2016, Excel 2013, and Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, and Excel 2000. About MID function: MID worksheet function extracts specified number of letters from a word. This is a… Read more »

## IF with OR formula for multiple logical tests.

How to use IF with OR function..? In our previous post IF with AND formula for multiple logical tests is explained with the example. In this post we can understand if with or formula. Instead of using AND function, we can use OR function for testing multiple logical tests to… Read more »

## IF with AND formula for multiple logical tests.

How to use IF with AND function..? In our previous post IF function and nested IF function is explained with the example. Similarly, instead of using Nested IF function IF with AND formula can be used for testing multiple logical tests to give the results. AND Function: In AND logic, different… Read more »

## IF function and nested if furmula in excel

How to use IF FUNCTION AND NESTED IF ..? In excel we can do logical test with if function, IF function will check the given condition, based on the output of the condition it can give two different results. If the given condition is YES, it will give one output and… Read more »

## Find the Duplicate entries in the list using Countif formula

To find out the duplicate entries in a list, we can use the COUNTIF formula. The COUNTIF function counts the number of cells in a range which meets the given criteria. With the help of COUNTIF function we can find out how many times a given entry is appearing in… Read more »

## 10 Shortcut Keys in excel to speedup your work.

The shortcut keys will speed up the work by avoiding mouse clicks. Remembering these shortcut keys may be difficult, but by regular practice we can develop the habit of using short cut keys. Following are the 10 shortcut keys to speedup your work. 1 Ctrl+Space and Shift+Space  these are the… Read more »

## Left, Right and Len functions in excel

If you want to split the information in a cell and get only few number of characters in a particular cell you can use the simple functions like LEFT or RIGHT.LEFT: syntax for LEFT function=LEFT(text, [num_chars])LEFT function will give the number of characters given in the formula from left of the… Read more »