I need help with calculating percentages in Google Sheets.
I have a spreadsheet where I want to find what 4% of different amounts would be. Here’s my setup:
- Column A contains the base amounts (like salary figures)
- Column B has the percentage rate I want to use (which is 4)
- Column C should display the calculated percentage amount
For instance, if someone earns £12 in column A, I want column C to automatically show me what 4% of that £12 equals.
What formula should I use in column C to make this calculation work? I’m pretty new to Google Sheets formulas so a simple explanation would be really helpful.
Thanks in advance for any help!
Use =A1*B1/100 in cell C1. I hit this same problem building budget trackers - this formula works great. Just drag it down to copy the formula to all your rows. The best part? Change any percentage in column B and everything updates automatically. Want 5% instead of 4%? Just change the number and it recalculates instantly. Quick heads up - make sure column B has the actual number 4, not ‘4%’ as text or the formula won’t work.
just multiply by 0.04 in column C! if A1 has £12, put =A10.04 in C1 and you’ll get £0.48. way easier than using the percentage column - unless u might change that 4% later, then use =A1B1/100 instead.
Use =A1*(B1/100) in cell C1. This multiplies your base amount in column A by the percentage in column B. So if A1 has 12 and B1 has 4, you’ll get 0.48 (which is 4% of 12). Copy the formula down and it’ll adjust the cell references automatically. Best part? If you change any percentage in column B later, all your calculations update instantly.