ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hOW DO i SUBTRACT COLUMNS IN EXCEL? (https://www.excelbanter.com/excel-discussion-misc-queries/79605-re-how-do-i-subtract-columns-excel.html)

Toppers

hOW DO i SUBTRACT COLUMNS IN EXCEL?
 
To subtract B1 from A1 with result in C1

in C1 put

=A1-B1 (= sign is required as this tells Excel it is a formula)

To repeat this for B2 form A2 etc, copy the formula into C2.

To copy a formula down i.e. to many cells, click on C2, hold cursor over
bottom right hand of cell (black square) until cross appears, hold left mouse
button and drag cursor down as far as required.

HTH

"Subtract columns" wrote:

Please help me. I am very new to Excel. I am trying to subtract one column
from the next. I do not know where to put the formula; or even what the
formula would be.? Signed Extremely Frustrated.



All times are GMT +1. The time now is 08:40 PM.

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