PC Review

Thread Tools Rate Thread


Posts: n/a
      26th Mar 2006
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.


"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 With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
hOW DO i SUBTRACT COLUMNS IN EXCEL? =?Utf-8?B?U3VidHJhY3QgY29sdW1ucw==?= Microsoft Excel Misc 1 29th Mar 2006 11:35 PM
How do I subtract two columns from the same total? =?Utf-8?B?TG9sbHljYXQ=?= Microsoft Excel Misc 7 26th Aug 2005 04:53 PM
subtract amounts from different columns? =?Utf-8?B?UGF1bGE=?= Microsoft Excel Misc 2 22nd Jan 2005 07:19 PM
Pivot Table Creating New Columns that Subtract Two Existing Columns den4673 Microsoft Excel Misc 3 17th Dec 2004 02:31 PM
macro to subtract columns and put result in new column Vel Microsoft Excel Programming 2 10th Feb 2004 08:26 PM




All times are GMT +1. The time now is 07:36 AM.