Home Excel Formulas

Formulas

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

sum if date is greater

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.

Sum if greater than

0
To sum if greater than, we need to use the SUMIF Function and define our criteria. In this example, we will use...

Calculate Percentage Change in Excel

0
Quickly Calculate Percentage Change in Excel.
Equated Monthly Installment

Equated Monthly Installment (EMI)

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

Reverse Compound Annual Growth Rate (CAGR)

0
Reverse Compound Annual Growth Rate is a calculation to determine the future value of your investment. In this calculation, the Compound Annual...

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

Calculate Private Mortgage Insurance (PMI)

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

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:

SUMPRODUCT and EXACT Formula

0
In this tutorial, we will combine the SUMPRODUCT and EXACT Function in a formula to determine the total number of Wins for...

Latest Tutorials

Excel Tip Calculator

Tip Calculator Template

sum if date is greater

Sum if date is greater than

Sum if between