Skip to content
Related Articles

Related Articles

Improve Article

How to Find the Percentage of Two Cells in Microsoft Excel?

  • Difficulty Level : Basic
  • Last Updated : 18 Jul, 2021

If you want to find the percentage of two cells in Microsoft Excel, Simply select an empty cell, where you want to display the percentage of the two cells.

Type in the following formula in the selected cell :

=address of cell1/address of cell2

For example, I want to print out the percentage of C2 and C3, so the formulae will be: =C2/C3, in an empty cell C4.

As soon as you click on the return key, You will get your percentage calculated in cell C4.



However, if a decimal value is displayed in the cell. Like 0.10, Simply press the shortcut key Ctrl+Shift+% to format as a percent or convert the numeric value into the percentage style and press the Return key.

The Decimal value will be converted to a percentage.

Before

After

You can also go to the Number section under the Home tab and press the % Symbol to convert to percentage format.

% symbol under the Number listbox

Attention reader! Don’t stop learning now. If you are an Excel beginner (or an intermediate) and want to learn Excel, Geeksforgeeks brings the perfect course for you to start, Diving Into Excel

My Personal Notes arrow_drop_up
Recommended Articles
Page :