ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to auto calculate difference between cells like c1=a1-b1 (https://www.excelbanter.com/excel-worksheet-functions/185835-how-auto-calculate-difference-between-cells-like-c1%3Da1-b1.html)

Jill

how to auto calculate difference between cells like c1=a1-b1
 
how do I set up Excel spreadsheet to auto calculate the difference , like
c1=a1-b1, I want the whole column to do it, so when i enter values in like
a1,a2, a3, etc, it automatically calculates the difference.

Gary''s Student

how to auto calculate difference between cells like c1=a1-b1
 
In C1 enter:
=A1-B1

copy this cell and paste it down the column.
--
Gary''s Student - gsnu200782


"Jill" wrote:

how do I set up Excel spreadsheet to auto calculate the difference , like
c1=a1-b1, I want the whole column to do it, so when i enter values in like
a1,a2, a3, etc, it automatically calculates the difference.


Gaurav[_3_]

how to auto calculate difference between cells like c1=a1-b1
 
in C1, type =A1-B1 and drag it down as far as needed.


"Jill" wrote in message
...
how do I set up Excel spreadsheet to auto calculate the difference , like
c1=a1-b1, I want the whole column to do it, so when i enter values in like
a1,a2, a3, etc, it automatically calculates the difference.





All times are GMT +1. The time now is 12:00 AM.

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