How do I create a formula that will calculate monthly changes fro.
 

I'm looking to automate a calculation I do to show changes from a prior month
to the current month. It's a mix of positive and negative numbers...

ex..
Prior Current **change**
-5 -2 3
-5 -8 -3
-5 2 7

=B1-A1

HTH
Jason
Atlanta, Ga

-----Original Message-----
I'm looking to automate a calculation I do to show
changes from a prior month
to the current month. It's a mix of positive and
negative numbers...

ex..
Prior Current **change**
-5 -2 3
-5 -8 -3
-5 2 7

.

With current in B and prior in A

=B2-A2

copy down

--

Regards,

Peo Sjoblom


"tucson" wrote in message
...
I'm looking to automate a calculation I do to show changes from a prior
month
to the current month. It's a mix of positive and negative numbers...

ex..
Prior Current **change**
-5 -2 3
-5 -8 -3
-5 2 7