22. Excel How to calculate a percentage?

The ratio of a part to a whole is the ratio of the value of the part to the value of the whole.

For example, 17 passes out of 20 students. The pass rate is 17/20 = 0.85.

To express a rate in percent, multiply by 100 and put a % sign in front of it.

The pass percentage for the above example is: 17/20 x 100 = 85%.

In Excel, it is recommended that you only write the ratio and then use the Percent Style button Excel 2016 Percent Style button in the Number group on the Home tab.

In the following example,

Excel 2016 Example How to calculate a percentage

I wrote in cell B6 the formula :


That is


To get the percentage value, I then click on the Percent Style button in the Number group on the Home tab.

Excel 2016 Percent Style button

You can also increase or decrease the number of digits after the decimal point by using the Increase Decimal Button Excel 2016 Increase Decimal Button or the Decrease Decimal Button Excel 2016 Decrease Decimal Button in the Number group on the Home tab.

Conversely, if you write a value with a % sign in a cell, then Excel will recognise it as a percentage:

  • For example, write in a cell: 25%.
  • Select this cell and open the Format button menu in the Cells group on the Home tab of the Ribbon.
  • Click on the Format Cells... button. The Format Cells dialog box is opened.
  • Click on the Number tab, then on General in the Category list.
  • Confirm with the OK button.
  • Note that the value displayed is 0.25.

Excel 2016 Number cell format

<< 21. Excel How to count cells with a specific text ?

23. Excel How to change the date format ? >>

Reader comments

Add a comment