Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate difference in Times | Excel Discussion (Misc queries) | |||
calculate the difference between two cells | Excel Discussion (Misc queries) | |||
Calculate time difference between cells | Excel Discussion (Misc queries) | |||
Calculate Difference b/e 2 dates. | New Users to Excel | |||
Calculate difference between two dates | Excel Worksheet Functions |