This formula divides the value in cell A1 by the value in cell B1. 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. The basic percentage formula is as follows.
C6 - D6 C6 100 - 92 100 8 100 08 When formatted using the Percentage number format08 8.
We can calculate the percentage for certain marks in examination or calculating discount for various prices the percentage change between two numbers and so on. If you want a simple number instead without a percent sign ie. On the Home tab click the Percentage button. 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.