Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Louise
 
Posts: n/a
Default calculating percentages

hi all

Quick question........

If my company made £10,000 last year and only £7,500 this year, how do I
work out what percentage the revenue has decreased by, using these two
figures???

Thank you.

Louise
  #2   Report Post  
PC
 
Posts: n/a
Default calculating percentages

You find the difference between the two numbers and divide by the base.

or

Divide the ending figure by the beginning figure and subtract 1

Your choice really




"Louise" wrote in message
...
hi all

Quick question........

If my company made £10,000 last year and only £7,500 this year, how do I
work out what percentage the revenue has decreased by, using these two
figures???

Thank you.

Louise



  #3   Report Post  
Louise
 
Posts: n/a
Default calculating percentages

Thank you.

Louise

"PC" wrote:

You find the difference between the two numbers and divide by the base.

or

Divide the ending figure by the beginning figure and subtract 1

Your choice really




"Louise" wrote in message
...
hi all

Quick question........

If my company made £10,000 last year and only £7,500 this year, how do I
work out what percentage the revenue has decreased by, using these two
figures???

Thank you.

Louise




  #4   Report Post  
Louise
 
Posts: n/a
Default calculating percentages

Just out of interest, what does the -1 do to the calculation??? what does it
represent??

THanks again.

Louise

"PC" wrote:

You find the difference between the two numbers and divide by the base.

or

Divide the ending figure by the beginning figure and subtract 1

Your choice really




"Louise" wrote in message
...
hi all

Quick question........

If my company made £10,000 last year and only £7,500 this year, how do I
work out what percentage the revenue has decreased by, using these two
figures???

Thank you.

Louise




  #5   Report Post  
 
Posts: n/a
Default calculating percentages


Louise wrote:
"PC" wrote:
"Louise" wrote:
If my company made £10,000 last year and only £7,500 this year,
how do I work out what percentage the revenue has decreased by


You find the difference between the two numbers and divide by the base.
or
Divide the ending figure by the beginning figure and subtract 1


Just out of interest, what does the -1 do to the calculation???
what does it represent??


The two methods are the same algebraically.

(7500 / 10000) - 1 = (7500 - 10000) / 10000

In general, the percentage difference is the difference
(later number minus earlier number) divided by the earlier
number.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating percentages in pivot tables on subtotals David Ruderman - Chapman University Excel Worksheet Functions 1 November 24th 05 04:54 PM
calculating percentages msdobe Excel Discussion (Misc queries) 6 July 29th 05 04:46 PM
Calculating Percentages tifosi3 Excel Discussion (Misc queries) 7 July 11th 05 08:42 PM
Calculating Percentages with Variables tssjhs Excel Worksheet Functions 1 January 28th 05 01:27 AM
Calculating percentages tssjhs Excel Worksheet Functions 2 January 25th 05 01:56 PM


All times are GMT +1. The time now is 10:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"