### How to use LARGE function in Microsoft Excel

In this article, we’ll learn about LARGE function in Microsoft Excel. In Microsoft Excel, LARGE function returns the k’th largest value from an a...

### How to use AND function in Microsoft Excel

In this article, we are going to learn about how and where we use AND function of Microsoft Excel.   Microsoft Excel AND function tests multipl...

### Converting Decimal Fractions to Fractions of a Specified Number

In this article we will learn how to change the cell format into fraction. When we enter the value in fraction format Excel read that value as date an...

### BASE function

BASE function With Excel 2013, Microsoft has launched a new function i.e BASE function which converts a number into a text representation with the ...

### Determining and Indicating the Number of Times Each Value Has Been Entered in a List

Problem: We want to create a formula to determine the total number of times each value in List1 (column A) has been entered. The formula should als...

### Nesting OR & AND Functions to Meet Multiple Criteria

Problem: We want to check whether or not each value in List1 (column A) meets both of the following criteria: 1. The number must be even. 2. The ...

### Nesting OR & AND Functions to Meet Multiple Criteria

Nested formula allows us to use the multiple conditions in a cell. It helps us to create the flexibility of the function in Microsoft Excel. This func...

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.