Calculate a Percentage IncreaseLets say you anticipate that next years costs will be 8 higher so you want to see. Check if everything went alright. For example if you have a column containing numbers and want to calculate 10 of one of those numbers enter 10 in another cell then use a formula using the asterisk as the multiplication operator.
To calculate the difference as a percentage we subtract this months value from last months and then divide the result by last months value.
So our Februarys sales are 319 higher than Januarys sales Hey. To increase the value or to calculate the amount of percentage increase in excel below mentioned formulas are used Amount 1 or new_valueold_value-1 or new value old valueold value. Select a blank cell for placing the result for increasing cell number by percentage please enter formula A2 1B2 into the Formula Bar and then press the Enter key. Enter a number in cell A1.