ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula (https://www.excelbanter.com/excel-discussion-misc-queries/227529-formula.html)

mas

Formula
 
I want to use a formula for addition and subtraction which will be repeated
on the whole sheet. example C2=C1+A2-A2.This will be repeated in every cell.
How can I do once and don't have to repeat all the times for whole month.

David Biddulph[_2_]

Formula
 
Copy, and paste.
If you want some or all of the cell references to stay unchanged as you
copy, look in help for the difference between relative and absolute
addressing.
--
David Biddulph

MAS wrote:
I want to use a formula for addition and subtraction which will be
repeated on the whole sheet. example C2=C1+A2-A2.This will be
repeated in every cell. How can I do once and don't have to repeat
all the times for whole month.





All times are GMT +1. The time now is 03:57 PM.

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