In this article, we will learn about FALSE function in Microsoft Excel. In Excel, FALSE function returns the Boolean value FALSE. FALSE does not take any argument, and we can either type the word FALSE directly onto the worksheet or … Continue reading →

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 array or set of data. With the help of examples, let us understand the use of … Continue reading →

In this article, we are going to learn about how and where we use AND function of Microsoft Excel. Microsoft Excel AND function tests multiple conditions at the same time, up to 255 conditions and only if all conditions … Continue reading →

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 and convert the number into date format. Let’s take example and understand: … Continue reading →

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 given base. Syntax:- =BASE(Number, Radix [Min_length]) Where, Number is the number which you want … Continue reading →

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 also provide a textual indication of the calculated frequency. Solution: Use the IF and … Continue reading →

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 number must be smaller than 3 or larger than 8. Solution: Use … Continue reading →

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 function is very useful when we want to check the multiple conditions. Also, Excel … Continue reading →

Problem: We want to create a conditional formula that will return TRUE if there is at least one number in List1 greater than the value in cell D1. Otherwise the formula will return FALSE. Solution 1: Use the following formula: … Continue reading →

Problem: The range A2:C8 contains rows of numbers. For each row, we want an indication of how many of the following conditions are met: 1. Num1 (column A) = 2 2. Num2 (column B) = 4 3. Num3 (column C) … Continue reading →