| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I subtract column 1 from 2 and show results in 3?HELP!
|
|
#2
|
|||
|
|||
|
In cell C1 put this formula
=B1-A1 then select C1 and pick on the little black square in the lower right corner and drag it down column C as many rows as you have data in A and B. This will automatically put =B2-A2 in cell C2, and =B3-A3 in cell C3, etc etc all the way down........... Vaya con Dios, Chuck, CABGx3 "ks" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract 20% from one column in Excel and place totals i. | Excel Discussion (Misc queries) | |||
| add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions | |||
| hide column but show chart | Charts and Charting in Excel | |||
| Excel Solver Results do not show up | Excel Worksheet Functions | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Linear Mode
