![]() |
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