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's to save you money quickly and easily. We hope you like it!

Forum Team Contact us

Live Stats

3,350Posts Today

7,575Users online

Martin's Twitter
  • British Gas 5% gas only price cut's paltry, like the rest, typically youll still be RIPPED OFF £300/yr. Check now RT

  • Trust me reading about it isn't as bad as experiencing it

  • Just got into an empty lift at Itv. And quite clearly there's been a very recent very farty previous resident!

  • Follow Martin