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

## Increase a Number by a Percentage

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 + $):

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

To format currency numbers within a string of text use a formula like this:

`="The price for year 2 is " & TEXT(F4,"$00.00") &".""`

Return to Excel Formula Examples.

## Leave A Comment