Now, let's take examples to illustrate how to use the percentage formula on the right. See more examples of calculating percentages and learn more about formatting numbers as percentages. Also, start the free Excel trial. The percentage, which can also be called a percentage, is a fraction of a number of 100%.

Percent means by 100 and indicates a part of a total amount. For example, 45% represents 45 out of 100, or 45% of the total amount. In this formula, V1 equals the cost of one product and V2 equals the cost of the other product.