Newbie Formula Question
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. |
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. |
Newbie Formula Question
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. |
Newbie Formula Question
|
All times are GMT +1. The time now is 10:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com