Home Excel Formulas

# Formulas

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

### SPLIT FIRST and LAST NAMES

0
Split First and Last name This tutorial covers how to split first and last names in excel.

### Sum if date is greater than

0
Sum if date is greater than a specified date. In this example, we will use the following formula to sum a range...

### Sum if less than

0
Sum if less than with named criteria.

### Equated Monthly Installment (EMI)

0
Calculate your Equated Monthly Installment (EMI) in Excel.

### Subtract If Greater than Zero

0
Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a...

### Compound Annual Growth Rate (CAGR)

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

### Annual Growth Rate in Excel

0
Annual Growth Rate in Excel Calculating the Annual Growth Rate in Excel is very easy. Annual growth rates are...

### Calculate Private Mortgage Insurance (PMI)

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

### Use a Letter to Represent a Value in Excel

0
This tutorial will show you how to use a letter to represent a specific value. Using this process, you can perform mathematical...

### Get the day name of a date in Excel

0
Here is an easy way to get the name of a date in Excel. Overview: