How to quickly calculate percentages in Excel How to calculate percentages using Excel table formulas

There are many functions that can be used in Excel tables. The calculation formulas are often used by many people. Through the formulas, we can quickly get the data we want. Today, some friends want to know how to quickly use Excel. Calculate the percentage. In response to this problem, this software tutorial will share detailed operation methods for the majority of users. Users in need are welcome to come to the PHP Chinese website to view it. How to quickly calculate percentages in Excel: 1. First open the table, and then find the total sales.

2. Then use the formula to calculate the proportion in the blank grid on the right.

3. Then enter $ after this formula to fix it, as shown in the picture.

4. Finally, you can click the drop-down button of the mouse to calculate all the proportions and set them to %.

The above is the detailed content of How to quickly calculate percentages in Excel How to calculate percentages using Excel table formulas. For more information, please follow other related articles on the PHP Chinese website!