Your browser isn't supported
It looks like you're using an old web browser. To get the most out of the site and to ensure guides display correctly, we suggest upgrading your browser now. Download the latest:

Welcome to the MSE Forums

We're home to a fantastic community of MoneySavers but anyone can post. Please exercise caution & report spam, illegal, offensive or libellous posts/messages: click "report" or email forumteam@. Skimlinks & other affiliated links are turned on

    How to calculate a percentage in excel?
    • #1
    • 10th Jun 07, 11:18 AM
    How to calculate a percentage in excel? 10th Jun 07 at 11:18 AM
    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.
Page 1
Welcome to our new Forum!

Our aim is to save you money quickly and easily. We hope you like it!

Forum Team Contact us

Live Stats

3,414Posts Today

6,962Users online

Martin's Twitter
  • It's the start of mini MSE's half term. In order to be the best daddy possible, Im stopping work and going off line?

  • RT @shellsince1982: @MartinSLewis thanx to your email I have just saved myself £222 by taking a SIM only deal for £7.50 a month and keeping?

  • Today's Friday twitter poll: An important question, building on yesterday's important discussions: Which is the best bit of the pizza...

  • Follow Martin