| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use Excel to match text data from 2 separate columns ? | Excel Worksheet Functions | |||
| remove automatic formatting of new columns in Excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| Add more lines and more columns in Excel | Excel Worksheet Functions | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Linear Mode
