View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Newbie Formula Question

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.