ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   calculating percentages (https://www.excelbanter.com/excel-worksheet-functions/51230-calculating-percentages.html)

Louise

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

PC

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




Louise

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





Louise

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





[email protected]

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.



All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com