how do i calculate the difference plus or minus between two numbe.

  • Thread starter Thread starter Steve Paton
  • Start date Start date
S

Steve Paton

I am trying to calculate the difference month on month of sales figures
whether up or down any ideas how I can do it with excell
 
Steve --

Do you mean comparing Oct 08 to Oct 07?

A B C
1 Oct 07 Oct 08 % diff
2 $10000 $11000 =(B2-A2)/A2

formatting column C as % would show the difference as a percentage of the
2007 month.

HTH
 
Calculating the difference between two numbers is called subtraction. You do
it with this kind of formula in Excel:

=a2-a1

Regards,
Fred.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What's the best way to set this formula up? 0
Calculating the difference between hours 1
How calculate difference between [t]:mm-format and general format 3
Calculate elapsed time excluding specific timeframe 10
Differnce function and argument for amounts in adjacent cells 3
CREATING FORMULA FOR CALCULATING ENDING BALANCE WITH PMT AND INTRE 1
calculating percentages 8
Calculating days sales outstanding 4

Back
Top