I have a 2 column S/S detailing monthly electrical meter readings .

The first column consists of the meter digital readout each month.

I would like the second column to subtract the previous month's
digital readout in column 1 from the present month's readout in
column 1 and enter this difference in column 2 opposite each months
reading as it occurs in column 1.

Thus , say , I would have a reading of 24543 against May in column 1
and another reading of , say , 24785 against June in column 1.

I require a formula which will show the increase between these 2
readings and place it against the June row in column 2.

What formula do I need to do this , please ?

B.N.

Hi

With May data in A2 and June data in A3, enter in cell B3
=IF(A3="","",A3-A2)
Copy the formula down column B as far as required.
The easiest way to achieve this, is to hover the cursor over the bottom
right corned of cell B3 until you see a small solid black cross (the fill
handle)
Click on the fill handle and drag down as far as required.
--
Regards
Roger Govier

wrote in message
...
I have a 2 column S/S detailing monthly electrical meter readings .

The first column consists of the meter digital readout each month.

I would like the second column to subtract the previous month's
digital readout in column 1 from the present month's readout in
column 1 and enter this difference in column 2 opposite each months
reading as it occurs in column 1.

Thus , say , I would have a reading of 24543 against May in column 1
and another reading of , say , 24785 against June in column 1.

I require a formula which will show the increase between these 2
readings and place it against the June row in column 2.

What formula do I need to do this , please ?

B.N.

Hi
Assuming that your data start from A2,
try placing this formual in B3 and copy down
to as far as your data in column A is.

=IF(A3<A2,A3-A2,"no change")

Does this do what you want?

HTH

--
Pls click on the Yes button below if this posting is helpful.

Thank You

cheers, francis


" wrote:

I have a 2 column S/S detailing monthly electrical meter readings .

The first column consists of the meter digital readout each month.

I would like the second column to subtract the previous month's
digital readout in column 1 from the present month's readout in
column 1 and enter this difference in column 2 opposite each months
reading as it occurs in column 1.

Thus , say , I would have a reading of 24543 against May in column 1
and another reading of , say , 24785 against June in column 1.

I require a formula which will show the increase between these 2
readings and place it against the June row in column 2.

What formula do I need to do this , please ?

B.N.

On Fri, 09 Jan 2009 17:08:55 +0000, wrote:

I have a 2 column S/S detailing monthly electrical meter readings .

The first column consists of the meter digital readout each month.

I would like the second column to subtract the previous month's
digital readout in column 1 from the present month's readout in
column 1 and enter this difference in column 2 opposite each months
reading as it occurs in column 1.

Thus , say , I would have a reading of 24543 against May in column 1
and another reading of , say , 24785 against June in column 1.

I require a formula which will show the increase between these 2
readings and place it against the June row in column 2.

What formula do I need to do this , please ?

B.N.



Thanks to both R.Govier and francis for the prompt replies.

Mr Govier's suggestion works OK and I've used that.

I'm afraid I didn't try francis's suggestion .

Regards,

B.N.