ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   excel (https://www.excelbanter.com/excel-worksheet-functions/29266-excel.html)

rurubi

excel
 
anyone can help me for the following pls:
C1+B2=C2, C2+B3=C3, C3+B4=C4 and so on...

thankssssss

CLR

IN cell C2, put this formula........

=C1+B2

Then, Left-click on C2 and you will see a little black square in the lower
right hand corner of the cell. Left-click on that square and hold it down
and drag the cursor down column C as many cells as you want the formula
perpetuated. Let go of the Left mouse button and the formulas will be
automatically copied down through that area of column C.


Vaya con Dios,
Chuck, CABGx3




"rurubi" wrote in message
...
anyone can help me for the following pls:
C1+B2=C2, C2+B3=C3, C3+B4=C4 and so on...

thankssssss





All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com