Newbie Formula Question

  • Thread starter Thread starter admiral_victory
  • Start date Start date
A

admiral_victory

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.
 
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
 
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.
Click to expand...



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.
 
Back
Top