How to calculate tax rate with base in Excel

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 ...

Using SUMPRODUCT to Count With Multiple Or Criteria

  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...

How to use SUM & IF function instead for SUMPRODUCT or SUMIFS function in Excel

In this article, we will learn How to use IF function instead of SUMPRODUCT and SUMIFS function in Excel.  Scenario: In simple words, when ...

Find the Loser in game with criteria in Excel

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...

Calculate marks with criteria in Excel

In this article, we will learn how to calculate total marks with criteria in Excel. Scenario: For instance, while working with the correct a...

How to Mark First Duplicate in Excel

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...

Use MAX/MIN function to replace long IF Excel formula

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...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube