In this article, we will learn How to calculate tax rate with base in Excel. Scenario: For Instance, Sometimes we need to calculate the tax ...
As I have mentioned in many of my blogs that a SUMPRODUCT is a very versatile function and can be used for multiple purposes. In this ar...
In this article, we will learn How to use IF function instead of SUMPRODUCT and SUMIFS function in Excel. Scenario: In simple words, when ...
In this article, we will learn how to find the Loser in a game of points with criteria in Excel. Scenario : Working with game data, sometimes we...
In this article, we will learn how to calculate total marks with criteria in Excel. Scenario: For instance, while working with the correct a...
In this article, we will learn how to flag the first duplicate in a range of values. Sometimes we need to identify the first duplicate from the ot...
In this article, we will learn how to use the MAX/MIN function to replace the long IF Excel formula. In simple words, while working with number...
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.