Home Excel Formulas

Formulas

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

Subtract If Greater

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

Percent Change Formula 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:

Latest Tutorials

NPER Function

NPER Function

CUMPRINC Function

CUMPRINC Function

YEARFRAC Function

YEARFRAC Function