How to use IF function with 3 conditions

I received a lot of questions on how to use IF function with 3 conditions, so I’ve decided to write an article on this topic. The IF examples described in this article assume that you have a basic understanding of how the IF function works. All examples from this article work in Excel for Microsoft […]

How to remove last character in Excel

Sometimes, the data in your spreadsheet may not be formatted as you need it to be. Removing extra characters can be tedious, and doing it manually is time-consuming and prone to error. Luckily, there are easy ways to manipulate data using Excel functions and formulas. In this article, you will learn how to remove last […]

How to count cells between two dates using COUNTIFS

You can use the COUNTIFS function to count the number cells between two dates of an Excel file. Example file included.

How to calculate a mortgage payment in Excel

To calculate a mortgage payment in Excel with a formula, you can use the PMT function. If you want to get the interest and principal amounts separately, you can use IPMT (interest component) and PPMT (principal component) functions. Before we begin, I recommend that you download the Excel spreadsheet. It includes all the formulas used […]

Count cells equal to a specific value

Counting cells that equal to a specific value can be achieved using COUNTIF function. If you need to use multiple criteria you can also use COUNTIFS.

How to use INDEX and MATCH functions in Excel

If you want to take your Excel skills to a new level, you have to learn how to use INDEX And MATCH, combine multiple functions and write complex formulas.

Subtotal by item type using SUMIF

If you need to calculate subtotals based on item type (or whatever common criteria), you can easily do so using the SUMIF function.

How to change case in Excel to UPPER, lower or Proper

Learn how to change text case to UPPER, lower or Proper format and combine text from different cells to obtain the desired result.

How to find duplicates in Excel using Conditional Formatting

Learn how to find duplicates in Excel. Perform the check in the same column or compare two different sheets, using conditional formatting or formulas.

Identify VAT rate based on country using VLOOKUP

To identify a VAT rate based on a simple tax rate table, you can use the VLOOKUP function. For this example we have also used a Data Validation List.

How to fix common Excel errors

Learn how to troubleshoot and fix #NULL!, #REF!, #DIV/0!, #NAME?, #N/A, #NUM, #VALUE, and ##### errors in Excel (practical examples included).

Sum sales by year using SUMIFS

If you are looking to create a breakdown of yearly sales based on a list of transactions you can use the SUMIFS function.