Percentage Increase Formula in Excel

This Excel Tutorial will teach you how to increase a number by a percentage in Excel.

Increase a Number by a Percentage

Increase a Number by a Percentage in Excel
To increase a number by a percentage in Excel, simply multiple the number by 1 + the percentage increase.
=old + (1+ percentage increase)
In Example above:
$500 + (1+.07) = $535

After increasing the number by a percentage, the result may appear as a decimal, without the dollar sign. To change the result into currency format, change the cell Number Formatting to Currency (CTRL + SHIFT + $):
Excel Currency Formatting Shortcut

The Text Function

Let’s use the TEXT Function to add the year 2 price into a string of text. Why do we need to do this? Without the TEXT Function, numbers appear unformatted when added to text. Even though the spreadsheet says $62.50 , when added to text it will appear as 62.5.
No Currency Formatting with Text Function in Excel
To format currency numbers within a string of text use a formula like this:
="The price for year 2 is " & TEXT(F4,"$00.00") &".""
Dollar Sign Formatting with the Text Function in Excel

Return to Excel Formula Examples.

Leave A Comment