Add a particular number as a running total
How can I add the number 7, for example so that in each cell the number gets
added. For example. 7 +7=14+7=21, and so forth. Thank you. |
Add a particular number as a running total
Put 7 in cell A1. Enter this formula in cell A2:
=A1+7 Copy A2 down the column for as many times as you want to do this. Hope this helps. Pete |
Add a particular number as a running total
Dear Pete, I am going to try it now. Thank you so much for your help.
Cuqui "Pete_UK" wrote: Put 7 in cell A1. Enter this formula in cell A2: =A1+7 Copy A2 down the column for as many times as you want to do this. Hope this helps. Pete |
Add a particular number as a running total
Hi Cuqui,
You can also put 0 in A1 and 7 in A2 then highlight both cells, hover your cursor over the bottom right corner of A2 and it will change into a small cross, click and drag the cross as far down the column as you need. HTH Martin |
All times are GMT +1. The time now is 11:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com