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

Search
  • FIRST POST
    zebidee1
    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,061Posts Today

7,723Users online

Martin's Twitter
  • Thanks to @CBBC_Hacker for sending us our own Hacker, baby MSE is smitten. Altight cocker. http://t.co/mdVVz56YHD

  • RT @MoneySavingExp: Hi folks - the site will be down from 10pm tonight until 8am tomorrow while we re-charge the batteries with some behind?

  • Uk dominating world long jump.Who'd have thought it. Kathy Cook's British 200m record about to go I think. #Beijing2015

  • Follow Martin