## Equated Monthly Installment (EMI)

Calculate your Equated Monthly Installment (EMI) in Excel.

Skip to content
# Formulas

## Reverse Compound Annual Growth Rate (CAGR)

## Use a Letter to Represent a Value in Excel

## Calculate Private Mortgage Insurance (PMI)

## Get the day name of a date in Excel

## SUMPRODUCT and EXACT Formula

## SPLIT FIRST and LAST NAMES

## Compound Quarterly Growth Rate (CQGR)

## Summing Only Positive or Negative Values

## Compound Annual Growth Rate (CAGR)

Scroll to Top
Formulas are expressions that utilize defined values and provide a calculation. Formulas provide computational power for your spreadsheets.

Reverse Compound Annual Growth Rate is a calculation to determine the future value of your investment. In this calculation, the Compound Annual Growth Rate (CAGR), which is the …

This tutorial will show you how to use a letter to represent a specific value. Using this process, you can perform mathematical calculations, such as multiplying X time …

Learn how to calculate Private Mortgage Insurance (PMI) on a new home purchase.

Here is an easy way to get the name of a date in Excel. Overview: Let’s look at the following example using the TEXT Function. By using this …

In this tutorial, we will combine the SUMPRODUCT and EXACT Function in a formula to determine the total number of Wins for Ohio State. Yes, to be fair, …

Split First and Last name This tutorial covers how to split first and last names in excel. Splitting First and Last names from a combined cell in Excel …

Compound Quarterly Growth Rate (CQGR) in Excel is rather easy to calculate. This can be very useful to forecast potential income or forecast personal returns. Before we begin, …

Learn how to sum only positive or negative values in excel. If you are an avid excel user, you will eventually have a need to only sum either …

The compound annual growth rate (CAGR) is an essential function regardless of industry. In this tutorial, we will cover how easy it is in Excel to formulate this …