Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating percentages in pivot tables on subtotals | Excel Worksheet Functions | |||
calculating percentages | Excel Discussion (Misc queries) | |||
Calculating Percentages | Excel Discussion (Misc queries) | |||
Calculating Percentages with Variables | Excel Worksheet Functions | |||
Calculating percentages | Excel Worksheet Functions |