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

132Posts Today

1,602Users online

Martin's Twitter