How To Get A Percentage Of A Number On Excel

How To Articles

Hey there! So you want to learn how to calculate the percentage of a number in Excel? You’re in the right place! I’ll walk you through the process step by step.

Understanding the Basics

First things first, let’s understand what it means to find a percentage of a number. Calculating a percentage is a way of expressing a number as a fraction of 100, and it’s commonly used in various financial, statistical, and mathematical analyses.

Steps to Calculate a Percentage in Excel

  1. Open your Excel spreadsheet and input the number for which you want to find the percentage.
  2. Select the cell where you want the result to appear. This is where the percentage will be displayed.
  3. Enter the following formula: =Number*Percentage%, where “Number” is the cell containing the original number and “Percentage” is the actual percentage you want to calculate. Remember to use the percentage format by adding the % sign at the end of the percentage.
  4. Press Enter, and voila! You’ll see the resulting percentage in the designated cell.

Adding Personal Touches

Personally, I find it helpful to double-check my work by using real-life examples. For instance, let’s say I want to calculate 20% of 150. In Excel, I would input =150*20%, and the result would be 30. It’s always satisfying to see the formula in action!


Now, if you’re encountering any issues with calculating percentages in Excel, don’t worry – it happens to the best of us! One common mistake is forgetting to use the percentage format when entering the formula. Always remember to include the % sign after the percentage value to ensure accurate results.


There you have it! Calculating percentages in Excel can be a breeze once you’ve got the hang of it. With a little practice and attention to detail, you’ll be crunching those numbers like a pro in no time. Happy calculating!