All TalkersTech Sections

How To Calculate Percentage Of A Number In Excel

Last Updated : Feb 11, 2022

How To Calculate Percentage Of A Number In Excel

In this article we will show you how to calculate percentage of a number in excel, If you are a person who regularly work with numbers, then you probably work with the percentage to. And Excel makes this work even easier for you, Excel can calculator percentage for you.

In this article we will teach how to get the right number in the right place to get the correct percentage.

You can calculate percentage in various method for example formulas and formatting. Completely depends on the type of results you need for your assignment.

There are no such basic percentage formulas in Excel which can multiply number bi percentage using a formula.

Step By Step Guide On How To Calculate Percentage Of A Number In Excel :-

  1. First open your Excel sheet.
  2. Select any of the empty cell where you want to display the answer
  3. And then enter equal sign in it.

    How To Calculate Percentage Of A Number In Excel

  4. Now you have to select the particular cell which contains the number of which you want to find the 10%.

    How To Calculate Percentage Of A Number In Excel

  5. Now enter an asterisk on the column.

    How To Calculate Percentage Of A Number In Excel

  6. Now you have to select the cell in which you have entered 10%
  7. After selecting the 10% column interrupt close parenthesis

    How To Calculate Percentage Of A Number In Excel

  8. And then press enter.
  9. Once you click on enter the calculation will automatically appear on the selected cell. For example if you have entered 600 to in cell A1 and then 10% in cell B1. Now copy the formula and paste into the cell C1 to calculate 10% of 600 =(A1*B1)

    How To Calculate Percentage Of A Number In Excel

  10. After this you can see the newly computerised percentage in cell C1.

How to multiply a cell in a column by same percentage :-

In this method you can quickly calculate all the number in the given column by the same percentage with using the same formula with some few steps

  1. First open your Excel sheet.
  2. Now enter the number you want to multiply by any percent in the column A.
  3. Then select column B after entering the number in column A.
  4. After this tap the right click button of your mouse.
  5. A menu box will appear on your screen, just select the format cells from it.

    How To Calculate Percentage Of A Number In Excel

  6. After selecting the format cells a pop-up will appear, Select the percenatge option.

    How To Calculate Percentage Of A Number In Excel

  7. And then press ok.
  8. Then enter any percentage in B1.
  9. Then, select B1 column.
  10. A small green dot will be visible at the right corner of the selected B1 column.
  11. Drag the dot sign over the cell in the column B to copy the percentage to other cell as well.
  12. Now select column C
  13. Then tap the right click button of your mouse.
  14. And then select the format cell from the list of option.
  15. After this select number option from the pop-up options.

    How To Calculate Percentage Of A Number In Excel

  16. And then press ok.
  17. Now go to cell C1 and enter=(A1*B1) in your Excel sheet.

    How To Calculate Percentage Of A Number In Excel

  18. After this your first calculation will appear in column C1.
  19. Now again select the columns C1.
  20. After selecting C1 column the green dot will be visible at the bottom of the right side of the corner.
  21. Drag down over the other cell in column C.

    How To Calculate Percentage Of A Number In Excel

Conclusion :-

This will copy the percentage formula to the other cell and automatically calculate percentage of the number will appear.

This is how you can calculate percentage in your Excel sheet these were the few easy and simple step which will get your work done and I hope this article on how to calculate percentage of a number in excel helps you.

Popular Articles