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