We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
The MSE Forum Team would like to wish you all a Merry Christmas. However, we know this time of year can be difficult for some. If you're struggling during the festive period, here's a list of organisations that might be able to help
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Has MSE helped you to save or reclaim money this year? Share your 2025 MoneySaving success stories!
How to calculate a percentage in excel?
zebidee1
Posts: 991 Forumite
in Techie Stuff
If anyone can help, please please do it in very simple terms. I'm struggling to get my head round excel things here. :rolleyes:
I have added up a column of numbers in an excel worksheet and got the total showing in a cell at the bottom.
So far so good, lol.
I now need to find out what 5% of the total is and show that in a cell underneath.
Then I want to add the two sub totals together (I can do that bit
).
So far I've been using a calculator and inserting the percentage amount manually, but there must be an easier way?
Thanks if anyone can help me.
I have added up a column of numbers in an excel worksheet and got the total showing in a cell at the bottom.
So far so good, lol.
I now need to find out what 5% of the total is and show that in a cell underneath.
Then I want to add the two sub totals together (I can do that bit
).So far I've been using a calculator and inserting the percentage amount manually, but there must be an easier way?
Thanks if anyone can help me.
0
Comments
-
multiply the total by 0.050
-
Thanks, but I don't know how to do that. I've only just learned how to add using the sideways m thing in the toolbar.
Sorry
I need baby instruction. 0 -
ok. assuming your total is in the cell C10.Thanks, but I don't know how to do that. I've only just learned how to add using the sideways m thing in the toolbar.
Sorry I need baby instruction.
in the cell underneath, type =0.05*C10
change C10 to be the cell your total is actually in.
does that help?0 -
YES! THANK YOU!!!!
Soooooo happy now. Doesn't take much does it? Lol.0 -
If you need to show the percentage in a separate cell, then it needs a formula.
For talk's sake, the subtotal you already have is in cell F22.
In F24 (or wherever it is being displayed), you need to write =(F22/100)*5 - This gives you the 5% figure.
An alternative is =F22*0.05
If you just want to display the percentage and the subtotal in F22 added to give another figure, without needing to show the 5% figure, then you need something like: =F22+((F22/100)*5)
HTH0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.9K Banking & Borrowing
- 253.9K Reduce Debt & Boost Income
- 454.7K Spending & Discounts
- 246K Work, Benefits & Business
- 602.1K Mortgages, Homes & Bills
- 177.8K Life & Family
- 259.9K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards