Microsoft Excel is the Swiss army knife for data enthusiasts, and we’re no strangers to its prowess. Whether we’re navigating Excel 2016 or the slicker realms of Excel 2021 and Excel for Microsoft 365, adding percentages to numbers is a task that crops up regularly. It’s like knowing how to pour milk into coffee – seems straightforward, but there’s an art to getting it just right, to avoid drowning in a milky brew or scalding with too much java.
Adding a percentage – that’s our game today. Whether you’re gearing up to increase your prices by a certain percent or figuring out what that 20% discount really amounts to, Excel serves as your loyal sidekick. And, with Excel for the Web rolling out its welcome mat, even when we’re on the go, a trusty browser is all we need to crunch those percentage-infused numbers. Let’s ditch the abacus and dive into the modern age, where a few clicks and taps let us handle percentages like pros.
Contents
Setting Up Your Spreadsheet
Before we start juggling numbers like circus performers, let’s set the stage with a well-organized spreadsheet. Remember, a tidy workspace is a happy workspace!
First things first, let’s talk about the layout. We’ll need three columns: Column A for the product name or description, Column B for the original price or value, and Column C for the percentage we want to add. Picture each cell as a tiny basket, ready to hold your precious numerical eggs.
In Cell A1, type ‘Product Name’, in Cell B1, let’s write ‘Original Price’, and in Cell C1, boldly declare ‘Percentage Increase’. This row is our spreadsheet’s headline—the marquee that displays what’s showing in our numerical theater.
| Product Name | Original Price | Percentage Increase |
| Example Product | $100 | 5% |
Let me tell you, the magic happens in Cell D2 and beyond! That’s where we’ll calculate the new price after the increase. So, in Cell D1, type ‘New Price’. It’s like a drum roll in Cell D2 as we prepare for the grand reveal of our calculated values.
Now, before we start the number crunching show, let’s remember to format cells. Those percentage cells need tweaking to ensure they’re actually read as percentages. Right-click Cell C2, select ‘Format Cells’, and choose ‘Percentage’. This little trick stops Excel from thinking you’re entering the latest scoreboard from the baseball game.
Alright, team, our spreadsheet is now a perfectly prepped canvas, ready for action! Stay tuned as we grab our numerical paintbrushes and start adding vibrant splashes of percentage increases to our spreadsheet masterpiece in the following acts.
Performing Basic Calculations
When we’re about to crunch some numbers in Excel, it boils down to some essentials: adding, subtracting, multiplying, and dividing. Let’s not beat around the bush; we’ve got numbers to tame!
Adding Values
Addition—our first math lesson, right? To add values or percentages in Excel, we use the plus sign (+). Simple as pie. Need to increase a number by a certain percentage? Add the product of the original number and the percentage expressed as a decimal. For example, to increase 100 by 10%, you’d calculate 100 + (100 * 0.10) to land on 110.
Subtracting Amounts
To find the difference, we wield the minus sign (-). Maybe we’re giving a discount on an item, or just playing the subtraction game. For instance, to offer a 15% markdown on a $200 jacket, we’d type up 200 – (200 * 0.15) and voilà, $170 is our discounted price!
Multiplying Percentages
Now, to multiply is to see things grow—works the same here. To find out, say, what 20% of 50 is, just multiply the total amount by the percentage in decimal form. Punch in =50 * 0.20, and bam, 10! Use this for calculating percentage increases or determining the part of a whole.
Dividing Data
We divide when we need to split or understand ratios. Excel handles this with the forward slash (/). If you want to check what percentage one number is of another, simply divide the part by the whole. For a quick reality check, entering =part/total could tell you that yes, indeed, our cats may spend 90% of their day snoozing.
| Operation | Symbol | Example |
| Addition | + | =100 + (100 * 0.10) |
| Subtraction | – | =200 – (200 * 0.15) |
| Multiplication | * | =50 * 0.20 |
| Division | / | =part/total |
Working with Percentages
Excel is a wizard when it comes to numbers, and percentages are no exception. Whether it’s adding a dash of increase to data or trimming a sale with a discount, we’ll explore the sorcery of percentages together. Let the magic unfold!
Calculating Percentage Increase
We encounter percentage increase often, especially when prices go up or salaries get a much-awaited boost. To calculate this in Excel:
- Original Number: The starting value before the increase.
- Percentage Increase: The increase rate, converted to decimal form. For 15%, use 0.15.
- New Value: The resulting amount after the hike.
Determining Percentage Decrease
On the flip side, when discounts or price drops come into play, percentage decrease helps us keep our wallets happy. To work this out in Excel:
- Original Number: The original price or value before markdown.
- Percentage Decrease: The reduction rate, write as a decimal. So, for 20%, use 0.20.
- Reduced Value: The final figure after cutting back.
Applying Percentage to Totals
Say we’re calculating sales tax or determining total costs; percentages can pile up or chip away at our totals. Here’s the gist:
- Original Number: The pre-tax or pre-discount price.
- Percentage: The tax rate or discount rate as a decimal.
- Total: The all-in price tag, with all extras included or deducted.
Adjusting Prices with Percentages
Whether we’re adjusting for inflation or setting up a sale, we need to tweak prices. With a spreadsheet full of numbers, Excel lets us apply a percentage adjustment to an entire column with ease. Simply multiply the range of prices by 1 plus the percentage increase (or 1 minus the percentage decrease) to reflect the updated prices.
Advanced Excel Functions
We’re venturing into Excel’s inner workings now, and it’s like a treasure trove for data enthusiasts! 😄 Let’s dig into some nifty tricks to handle percentages like pros.
When you’re sprucing up numbers with Percent Style formatting, it’s not just about making numbers look pretty. You’re actually instructing Excel to treat these values as percentages. Remember, the decimal values and decimal equivalents are the real MVPs here!
Adding a simple 10% can be straightforward, but things can get spicy with multiple percentages or, heaven forbid, a negative percentage. That’s when our friend, the formula bar, steps in. If you’ve ever mixed up absolute and relative cell references or wondered why dragging the fill handle is making your numbers do the conga line in all the wrong directions — we’ve been there.
| Option | Use Case |
| Paste Special | To apply a percentage to multiple cells without altering the format. |
| Absolute Cell Reference ($) | To fix a reference when copying a formula across cells. |
| Percent Style Button | To quickly format numbers as percentages. |
Now, if your food expenditures have gone up and you need that increase reflected across a budget sheet, we’ve got your back. Here’s a tip: use the Paste Special option—this is where the magic happens. No need to reformat those cells one by one like it’s 1999!
Lastly, who knew that pressing a couple of keys on the keyboard could be your shortcut to success? CTRL + R and CTRL + D are about to become your new best friends for filling data horizontally or vertically. For those wondering, this right here is the type of inside knowledge that turns a mere mortal into an Excel demigod! 🤓
So grab that absolute reference like it’s your lifeline on “Who Wants to Be a Millionaire?”, format those cells with confidence, and let’s show Excel who’s boss!