How do I subtract two columns from the same total?

Lollycat

Posts: n/a

Thank you all so very much!

"Domenic" wrote:

Try...

=B1-C1-IF(D1<0,ABS(D1))

or

=B1-C1+IF(D1<0,D1)

Hope this helps!

In article ,
"Lollycat" wrote:

Hi,

How do I subtract two columns with two different conditions from the same
total?

A B C D E
Article 1 200 12 -45
Article 2 350 12 50

Column E should always contain B - C, but column D should only be subtracted
if it is less than 0.

Thanks in advance!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get Msg "Cannot shift objects off sheet" when hidng columns" Why?	Steve Ball	Excel Discussion (Misc queries)	2	June 27th 05 06:41 PM
Having trouble totaling columns in excel 2003, always worked b4	rjmac	Excel Worksheet Functions	1	June 24th 05 07:01 PM
Eliminate unused columns	jlbreyer	Excel Discussion (Misc queries)	3	June 20th 05 07:16 PM
Subtract a group of cells from a total based on ending date	Nicholas Scarpinato	Excel Discussion (Misc queries)	0	May 17th 05 03:25 PM
Pulling data from 2 columns for a total	Urgent	Excel Worksheet Functions	3	December 17th 04 10:18 PM

All times are GMT +1. The time now is 04:44 PM.

Menu

About Us