Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 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!
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
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.4K Work, Benefits & Business
- 606.1K Mortgages, Homes & Bills
- 179.1K Life & Family
- 264K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards