The Microsoft Excel LOOKUP function is one of the most popular functions of MS Excel. This Function is categorized under Excel Lookup and Reference functions. Use the LOOKUP function to look up a value in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range.   Some uses of […]

The FREQUENCY function in Excel help you to calculating the frequency (no of repeated value) of a data set within a given range of values. It means how many times a data value has occurred amongst a given set of values. Syntax =FREQUENCY(data_array, bins_array)   Data_array – It is an array or reference to a

A cell reference refers to the name or address of a specific cell or range of cells within the spreadsheet which is a combination of a column letter and a row number. Each worksheet in Excel consists of several cells. Each cell has a specific cell reference which helps the users to find easily address

Mixed cell references are more-tricky than the absolute cell references if we compare. There can be two types of mixed cell references: 1 The row is locked while the column changes when the formula is copied or dragged. 2 The column is locked while the row changes when the formula is copied or dragged. Below is

Absolute cell references are useful when you don’t want the cell reference to change as you copy or drag formulas. This reference used when you have a fixed value that you need to use in the formula (such as tax rate, commission rate, percentage number of months, etc.) absolute cell references don’t change when you

There is no spacefic function called Nested If function in MS Excel, but whenever we use multiple IF function together within IF in MS-Excel, it is called Nested If function. We use Nested If function in Excel when we need to apply more than one condition to analyze the data of excel, and whatever condition

The MAX function in Excel returns the largest numeric value in a range of cells. you can easily extract the largest value / number out of thousands and millions of values ​​typed in the sheet of MS EXCEL. STEP 1 – First of all, open that MS EXCEL sheet in your computer, inside which you

When we type many values ​​on the sheet of MS EXCEL and there are small and big values ​​in it, then we have to extract the smallest value from all these values, then in this case you can use the Min formula. Using the MIN formula, you can easily extract the smallest value / number

In this tutorial, you ’ll learn five different ways how to calculate percentage in Excel. All of them are correct and can be used interchangeably to get the same result. There are no specific functions for calculating percentage In MS Excel so you have to use the skills you were taught in your math’s class

The OR function in Microsoft Excel comes under the logical function category. The OR function is also used to test multiple conditions at a time just like the AND Function. This function also gives the result in True or False. If all the conditions are satisfied in the IF function, and if any one of