Percent Change New Value Old Value Old Value. If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of. In the example shown the formula in D6 is.
Basic Percentage formula to calculate percentage is.
If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want. Enter a number in cell A1. That would give you a picture of whether costs. For this example the formula you would use is A1 1-B1.