Main site > MoneySavingExpert.com Forums > Household & Travel > Techie Stuff > How to calculate a percentage in excel? (Page 1)

IMPORTANT! This is MoneySavingExpert's open forum - anyone can post

Please exercise caution & report any spam, illegal, offensive, racist, libellous post to forumteam@moneysavingexpert.com

  • Be nice to all MoneySavers
  • All the best tips go in the MoneySavingExpert weekly email

    Plus all the new guides, deals & loopholes

  • No spam/referral links
or Login with Facebook
How to calculate a percentage in excel?
Closed Thread
Views: 18,217
Thread Tools Search this Thread Display Modes
# 1
zebidee1
Old 10-06-2007, 11:18 AM
Serious MoneySaving Fan
 
Join Date: Jul 2006
Posts: 983
Default How to calculate a percentage in excel?

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.
zebidee1 is offline
Report Post
# 2
Need_More_Money
Old 10-06-2007, 11:21 AM
Fantastically Fervent MoneySaving Super Fan
 
Join Date: Feb 2006
Posts: 3,335
Default

multiply the total by 0.05

Last edited by Need_More_Money; 10-06-2007 at 11:25 AM.
Need_More_Money is offline
Report Post
# 3
zebidee1
Old 10-06-2007, 11:26 AM
Serious MoneySaving Fan
 
Join Date: Jul 2006
Posts: 983
Default

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 I need baby instruction.
zebidee1 is offline
Report Post
# 4
Need_More_Money
Old 10-06-2007, 11:27 AM
Fantastically Fervent MoneySaving Super Fan
 
Join Date: Feb 2006
Posts: 3,335
Default

Quote:
Originally Posted by zebidee1 View Post
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 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?
Need_More_Money is offline
Report Post
The Following User Says Thank You to Need_More_Money For This Useful Post: Show me >>
# 5
zebidee1
Old 10-06-2007, 11:31 AM
Serious MoneySaving Fan
 
Join Date: Jul 2006
Posts: 983
Default

YES! THANK YOU!!!!

Soooooo happy now. Doesn't take much does it? Lol.
zebidee1 is offline
Report Post
The Following User Says Thank You to zebidee1 For This Useful Post: Show me >>
# 6
bingo bango
Old 10-06-2007, 11:33 AM
Fantastically Fervent MoneySaving Super Fan
 
Join Date: Aug 2005
Location: Belfast
Posts: 2,146
Default

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
bingo bango is offline
Report Post
The Following User Says Thank You to bingo bango For This Useful Post: Show me >>
Closed Thread

Bookmarks
 
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

 Forum Jump  

Contact Us - MoneySavingExpert.com - Archive - Privacy Statement - Top

Powered by vBulletin® Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

All times are GMT +1. The time now is 8:30 AM.

 Forum Jump  

Free MoneySaving Email

Top deals: Week of 10 September 2014

Get all this & more in MoneySavingExpert's weekly email full of guides, vouchers and Deals

GET THIS FREE WEEKLY EMAIL Full of deals, guides & it's spam free

Latest News & Blogs

Martin's Twitter Feed

profile

Cheap Travel Money

Find the best online rate for holiday cash with MSE's TravelMoneyMax.

Find the best online rate for your holiday cash with MoneySavingExpert's TravelMoneyMax.

TuneChecker Top Albums

  • THE SCRIPTNO SOUND WITHOUT SILENCE
  • TRAINBULLETPROOF PICASSO
  • SAM SMITHIN THE LONELY HOUR (DELUXE EDITION)

MSE's Twitter Feed

profile
Always remember anyone can post on the MSE forums, so it can be very different from our opinion.
We use Skimlinks and other affiliated links in some of our boards, for some of our users.