It is currently Sat Sep 23, 2017 12:12 am


Percentage Formula For Excel

Off Topic chat that doesn't fit anywhere else.
  • Author
  • Message
Offline
User avatar

Ossett Town FC

Caleb Folan

  • Posts: 16
  • Twitter: Spofforth

Percentage Formula For Excel

PostMon Dec 31, 2012 12:52 pm

If column A is 10 and colum B is 5, I know that B is 50% of A, but how can I do a formula so column C shows the percentage automatically?

Anyone?
Offline
User avatar

Barney Rubble

Alan Peacock

  • Posts: 2255
  • Twitter: @andyrubble666

Re: Percentage Formula For Excel

PostMon Dec 31, 2012 12:56 pm

=B1/A1 then format the cells to percentage ??
Offline
User avatar

Boro85

Wilf Mannion

  • Posts: 5433
  • Twitter: Jooky85

Re: Percentage Formula For Excel

PostMon Dec 31, 2012 12:57 pm

Easy, do:

Code: Select all
=(B1/A1)


Then select all of column C and format the cells to show "Percentage"

Beaten by Rubble!
Offline
User avatar

Ossett Town FC

Caleb Folan

  • Posts: 16
  • Twitter: Spofforth

Re: Percentage Formula For Excel

PostMon Dec 31, 2012 1:10 pm

Spot on, excpected it to be a complecated one!!!!

That's work finished for 2012!!!
Offline
User avatar

LTS_3

Micky Fenton

  • Posts: 3605
  • Twitter: @LTS_3

Re: Percentage Formula For Excel

PostMon Dec 31, 2012 2:03 pm

No offence but did an adult actually just ask how to calculate a percentage?! :embarrass: :mrgreen:
Offline
User avatar

akalongster

Mikkel Beck

  • Posts: 308
  • Twitter: @akeithsaunders

Re: Percentage Formula For Excel

PostMon Dec 31, 2012 2:04 pm

No!
Offline
User avatar

Barney Rubble

Alan Peacock

  • Posts: 2255
  • Twitter: @andyrubble666

Re: Percentage Formula For Excel

PostMon Dec 31, 2012 2:08 pm

Longster is right. An adult asked how to make his computer calculate a percentage ....
Offline
User avatar

LTS_3

Micky Fenton

  • Posts: 3605
  • Twitter: @LTS_3

Re: Percentage Formula For Excel

PostMon Dec 31, 2012 2:09 pm

I agree he didn't
Offline
User avatar

Ossett Town FC

Caleb Folan

  • Posts: 16
  • Twitter: Spofforth

Re: Percentage Formula For Excel

PostMon Dec 31, 2012 3:17 pm

LTS_3 wrote:No offence but did an adult actually just ask how to calculate a percentage?! :embarrass: :mrgreen:

I know how do to percentages, and you will see in my original post I prove it, I showed that I know 5 is 50% of ten. So there...

:smug:
Offline
User avatar

Capybara

Scott McDonald

  • Posts: 664

Re: Percentage Formula For Excel

PostThu Mar 10, 2016 11:23 am

I must admit I was expecting something a little more challenging than the subject line suggested. Turns out I was wrong.

Return to Anything & Everything

Who is online

Users browsing this forum: No registered users and 2 guests