Microsoft Excel is a powerful tool that can make complex calculations easy and simple. One common task is adding a percentage to a number in Excel. Whether you need to calculate sales tax or apply a discount, adding a percentage to a number is a common task for many Excel users. In this blog post, we will explore different methods that you can use to add a percentage to a number in Excel.
Method 1: Enter the formula manually
One simple way to add a percentage to a number in Excel is by entering a formula manually. To do this, first select an empty cell where you want the result to appear. Next, type in the following formula:
=number*(1+percentage)
For example, if you want to add a 10% increase to the number 50, type in “=50*(1+0.10)” in the cell and press enter. The result will be 55.
Method 2: Use the multiplication formula
Another way to add a percentage to a number in Excel is by using the multiplication formula. This method involves multiplying the original number by 1 plus the percentage increase. Here are the steps to do this:
 Select an empty cell where you want the result to appear.
 Type in the original number.
 Type in the percentage increase in decimal format (e.g., 0.10 for 10%).
 Add a multiplication symbol (*) between the number and the percentage increase.
 Press enter to see the result.
Example
Let’s say you want to add a 15% discount to a product that costs $500.
In the cell where you want the result to appear, type in “=500*(10.15)”
The result will be $425, which is the original price minus the 15% discount.
Method 3: Use the percentage format
If you don’t need to calculate with the new number, but rather just want to display it with the percentage increase, this method is for you.
 Select the cell or cells you want to display the result in.
 Rightclick and select “Format Cells”.
 In the Number tab, select “Percentage” from the Category list.
 Under the options, change the decimal places to 0, if desired.
 Click “OK” to apply the changes.
Example
Let’s say you want to display a number with a 25% increase as a percentage.
 Select the cell where you want the result to appear.
 Enter the original number (e.g. 100).
 Type in “25%” (without quotes) or “0.25” (as decimal format) to increase the number by 25%.
 Rightclick and select “Format Cells”.
 In the Number tab, select “Percentage” from the Category list and click “OK.
Conclusion
Adding a percentage to a number in Excel can seem daunting at first, but with these methods, it’s quite simple. By entering formulas, using multiplication, or formatting cells, you can calculate percentage increases or discounts in no time. Give these methods a try, and see how much easier your calculations can be.
Formatting Percentage Values in Excel
In Excel, you can also format numbers as percentages, which is helpful when working with large data sets. To do this, select the cells you want to format and rightclick. Then, click on “Format Cells” and, in the “Number” tab, select “Percentage.” Here, you can also adjust the decimal places so that your percentages are displayed as you prefer.
Working with Negative Percentages
In some cases, you may need to subtract a percentage from a number. When this occurs, you can use the same methods to calculate the decrease. If you need to subtract 10% from 50, for instance, you’ll use “=50*(10.10)” to calculate your result.
Using Relative Cell References
To save time when working with percentage calculations, you can use relative cell references. By doing this, you can apply the same calculation to a range of cells without the need to enter the formula manually for each of them.
To use relative cell references, enter the formula for the first cell in your range and then drag the fill handle down or across the cells you want to fill. Excel will automatically adjust the cell references in the formula to match the current row or column.
Dealing with RoundOff Errors
When working with percentages in Excel, you may notice small differences in your results due to roundoff errors. Since percentages can be calculated using very small decimal values, Excel rounds off the result to a certain number of digits, which can cause slight differences when compared with the exact value.
To solve roundoff errors, you can adjust the number of decimal places in your calculation or wrap your formula in a ROUND function to round off the result to a specific number of decimals.
Final Thoughts
Adding percentages to a number is a common task in Excel, but it can be confusing to new users. Using formulas, formatting cells, and working with relative references can make it much easier to calculate percentage increases or decreases. Remember, when working with percentages in Excel, keep an eye on roundoff errors, and adjust your formulas accordingly. With these tips, you’ll be able to use percentages in Excel like a pro in no time!
FAQ
Here are some of the common questions related to adding percentages to numbers in Excel.
How do I calculate a percentage increase in Excel?
To calculate percentage increase in Excel, simply subtract the original value from the new value and then divide the result by the original value. Finally, multiply the result by 100 to get the answer in percentage form.
What is the difference between relative and absolute cell references in Excel?
In Excel, a relative cell reference is used when you want the formula to change when you copy or move it to a new cell. On the other hand, an absolute cell reference is used when you want the formula to stay the same when you copy or move it to a new cell. You can use either of these types of cell references when calculating percentages in Excel.
Can I apply a percentage format to a cell without using a formula?
Yes, you can use the “Percentage” format to display a number as a percentage by simply selecting the cell or cells you want to format, rightclicking, and clicking on “Format Cells”. From there, choose “Percentage” and adjust the decimal places as necessary.
Can I use a negative percentage to subtract from a number in Excel?
Yes, you can use a negative percentage to subtract from a number in Excel. Simply follow the same methods for adding a percentage, but use a negative value as your percentage increase.
Is it possible to add multiple percentages to a number in Excel?
Yes, you can add multiple percentages to a number in Excel by using nested formulas, which means using one formula inside another. The formula would look like “=number*(1+percentage1)*(1+percentage2)*…”.
Featured Companies

Learn PowerPoint
Explore the world of Microsoft PowerPoint with LearnPowerpoint.io, where we provide tailored tutorials and valuable tips to transform your presentation skills and clarify PowerPoint for enthusiasts and professionals alike.

Learn Word
Your ultimate guide to mastering Microsoft Word! Dive into our extensive collection of tutorials and tips designed to make Word simple and effective for users of all skill levels.

Resultris Marketing
Boost your brand's online presence with Resultris Content Marketing Subscriptions. Enjoy highquality, ondemand content marketing services to grow your business.
Trending
Other Categories
 Basic Excel Operations
 Excel Addins
 Excel and Other Software
 Excel Basics and General Knowledge
 Excel Cell References and Ranges
 Excel Charts and Graphs
 Excel Data Analysis
 Excel Data Manipulation and Transformation
 Excel Data Validation and Conditional Formatting
 Excel Date and Time Functions
 Excel Errors
 Excel File Management
 Excel Formatting and Visual Adjustments
 Excel Formulas and Functions
 Excel Integration and Conversion
 Excel Linking and Merging
 Excel Macros and VBA
 Excel Printing
 Excel Settings
 Excel Tips and Shortcuts
 Excel Training
 Excel Versions
 Form Controls and User Interaction
 How To
 Pivot Tables
 Working with Text