In this article, we will learn simplifying formulas by reducing the complexity of IF functions in Microsoft Excel 2010. While working on NESTED IF formula; the successful execution of the command depends on whether the condition is met or not. … Continue reading
In this article, we will learn how to calculate the average difference between list price and sales price. We can either use the “AVERAGE” function or we can use the “SUM” function along with “COUNT” function in Microsoft Excel. SUM: … Continue reading
In this article, we will learn how to round the time intervals to the nearest specified time increment. We will use “ROUND” function in Microsoft Excel to get the output. ROUND: – This function is used for rounding a number … Continue reading
To find the nth highest score for a specified team, we can use the LARGE function to retrieve the result. LARGE: Returns the k-th largest value in a data set. For example: the second largest number from a list of … Continue reading
To find the maximum numerical value in a list based on a criteria, we can use the MAX function along with the If function in Excel. First we will learn how to use Max function in Microsoft Excel. MAX: This … Continue reading
To count based on multiple criteria we use COUNTIFS function in Microsoft Excel. Excel function COUNTIFS is used to count the entries in multiple ranges and with multiple criteria. To sum based on multiple criteria we use te Sumifs function in … Continue reading
To retrieve the value of the first non blank cell in a list, we will use Index and Match functions. Why and how we use Index and Match functions together to retrieve the first nonblank value from a range? Index … Continue reading
Problem: Columns A & B contain the number of points scored by a particular player during each quarter of a game. An empty cell indicates that no points were scored during that quarter. When using the following Array formula to … Continue reading
In this article, you’ll learn how to check if matching numbers exist in different ranges in Microsoft Excel. When we want to pick the values from first data to second data, we use Vlookup function. But, when Vlookup function does … Continue reading
In this article, we will learn how to switch the row value into column value and column value into row value through Transpose formula in Excel. Problem is: -Transposing the values in List1 (cells A2:A5) into a row, and the values in … Continue reading
