We're aware that some users are experiencing technical issues which the team are working to resolve. Thank you for your patience.
📨 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?

Options
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.

Comments

  • multiply the total by 0.05
  • zebidee1
    zebidee1 Posts: 991 Forumite
    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 :o I need baby instruction.
  • zebidee1 wrote: »
    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 :o I need baby instruction.
    ok. assuming your total is in the cell C10.
    in the cell underneath, type =0.05*C10
    change C10 to be the cell your total is actually in.
    does that help?
  • zebidee1
    zebidee1 Posts: 991 Forumite
    YES! THANK YOU!!!!

    Soooooo happy now. Doesn't take much does it? Lol.
  • bingo_bango
    bingo_bango Posts: 2,594 Forumite
    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)

    HTH
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.6K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.4K Spending & Discounts
  • 243.6K Work, Benefits & Business
  • 598.4K Mortgages, Homes & Bills
  • 176.8K Life & Family
  • 256.8K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.