The REPLACE function in Excel allows you to swap one or several characters in a text string with another character or a set of characters. If decimals is negative number will be rounded to the left of the decimal point. What to Know To create a formula with references highlight the cells you want to use then select an empty cell and enter the formula.
Select cell C3 and enter the formula shown below.
On the Home tab in the Number group apply a Percentage format. The same calculation can be done by using excel simple formulas. The result from IF can be a value a cell reference or even another formula. The percent change formula is used very often in Excel.