Google Sheets Formulas Percentage

So there I was, staring at my screen like it had personally offended me. My friend had asked for help with a budget spreadsheet, and I confidently typed =A120%—only to get a result that made zero sense. “It’s simple,” I muttered, refreshing the page twice. Spoiler: it wasn’t the computer’s fault. (It never is, right?)

That moment of panic taught me something huge: Google Sheets formulas for percentages are deceptively tricky. But once you crack the code, they’re actually your best friend. Trust me—I’ve since become the go-to “spreadsheet whisperer” among my friends, and I’m about to share the goods with you.

Why Percentages Feel Like a Trap at First

You’d think typing =A120% would give you 20% of the number in A1. And you’d be almost right—except Google Sheets is weird about decimals. It treats the percent sign literally, so =A120% works, but =A120 gives you 20 times the value. (Yeah, I’ve been there, buddy.)

The real trick? Think of percentages as decimal fractions. 20% is 0.20, 50% is 0.50, and 100% is 1.0. Once you internalize that, the formulas become second nature. And if you’re like me and hate mental math? Just use the percentage symbol—but only in multiplication, never when adding or subtracting percentages directly.

The Three Percentages You’ll Actually Use

Let’s cut the fluff. Here are the three formula types that cover 90% of real-life spreadsheet needs. First: calculating a percentage of a number. Say you want 15% of 200. Just type =20015% and boom—30. (Yes, it’s that simple. No, I didn’t believe it at first either.)

Second: finding what percentage one number is of another. This is the “I got 45 out of 60 on the test” situation. Use =45/60, then format the cell as a percentage (Format > Number > Percent). Google Sheets will show 75%. Don’t manually multiply by 100—that’s a rookie move.

Third: increasing or decreasing a number by a percentage. Need to add 10% to your rent? Type =A1(1+10%). That gives you the original value plus the 10% bump. For a discount? Replace the plus with a minus: =A1(1-15%). It’s like magic, but with less rabbits.

The “Wait, That’s Not Right” Moment

Here’s where most people rage-quit. You copy a percentage formula down a column, and suddenly the values look insane. It’s probably a relative reference problem. If your formula references cell B2 but you drag it down, it changes to B3, B4, and so on. Use $B$2 (with dollar signs) to lock that cell. (I learned this the hard way—my grocery budget cried.)

Another common trap: adding percentages in a column. If you have 10% in one cell and 20% in another, =A1+A2 gives you 0.30, not 30%. Google Sheets stores percentages as decimals under the hood. So always format your result cell as a percentage after the calculation. Or just use =SUM(A1:A2) and format later.

Real-Life Examples You Can Steal

Let’s say you’re tracking sales commission. You sold $500 worth of stuff at a 8% commission rate. =5008% gives you $40. Nice, right? But what if your boss says “commission is 8% of sales, but only if sales exceed $300”? That’s when you use =IF(A1>300, A18%, 0). A little more sass, same logic.

Or maybe you’re splitting a dinner bill with toxic friends who forget to tip. Total bill is $120, and you want to add 18% tip. =120(1+18%) gives you $141.60. Now divide by the number of people. (And maybe write a formula to shame the person who ordered the most expensive wine.)

When Spreadsheets Lie to You

Have you ever seen a percentage that looks like 0.0001% and panicked? That’s usually a formatting issue. Your raw number might be 0.001, but you forgot to format the cell as a percentage. So Google Sheets displays “0.1%” if you format it, or “0.001” if you don’t. Always check the cell format before panicking.

Another lie: percentage differences in Google Sheets. The formula =(B2-A2)/A2 gives you the change from A2 to B2. If A2 is 50 and B2 is 75, that’s a 50% increase. But if the numbers flip? You get a negative percentage. That’s not a bug; it’s a math fact. Yet I’ve seen people scream at their monitors over it. Don’t be that person.

One Pro Tip That Changes Everything

Use the ARRAYFORMULA trick for multiple rows. Instead of dragging a formula down a 500-row spreadsheet, type =ARRAYFORMULA(B2:B * C2:C). Boom—it calculates every row at once. For percentages, it’s a lifesaver when you’re applying a discount to a whole list of prices.

And here’s a secret: Google Sheets can do percentages in conditional formatting too. Highlight cells that are above 90% of a target? Use a custom formula like =A1>B10.9. (Yes, this is how I learned to stop manually checking 200 cells. My eyeballs thanked me.)

The Final “I Swear It Works” Moment

So next time you’re fiddling with =A1B1 and getting a weird result, just take a breath. Check your cell format. Lock that reference. Add the percent sign. You’ve got this. And if all else fails? Type your question into the Google Sheets help forum—where someone has definitely cried over the exact same thing before. (Hello, it’s me. I’m the problem, it’s me.)

Now go forth and calculate. Your spreadsheet is waiting.