As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Calculate Percentage Increase in Excel

Adding a percentage increase to a number in Excel is easy!

The Formula:

New Number = (1 + Percent Increase)

For example, if you wanted to add a 20% increase to the number 100, you would use the following formula:

New Number = (1 + 0.20)

This would give you a new number of 120.

Percentage Change:

If you want to calculate the percentage change between two numbers, you can use the following formula:

Percent Change = ((New Number - Old Number) / Old Number)

For example, if you wanted to calculate the percentage change between the numbers 100 and 120, you would use the following formula:

Percent Change = ((120 - 100) / 100)

This would give you a percent change of 0.20, or 20%.

Rounding:

If you want to round your answer to a certain number of decimal places, you can use the ROUND function in Excel. The basic syntax for this function is as follows:

ROUND(number, num_digits)

The first argument is the number that you want to round, and the second argument is the number of decimal places that you want to round to. For example, if you wanted to round the number 1.2345 to two decimal places, you would use the following formula:

ROUND(1.2345, 2)

This would give you an answer of 1.23.

Putting It All Together

Let's say you have a list of numbers in Excel, and you want to add a 20% increase to each number. You can do this by using the following formula:

New Number = (1 + 0.20) * Old Number

If you want to round the answers to two decimal places, you can use the following formula:

New Number = ROUND((1 + 0.20) * Old Number, 2)