If the number in column D is negative and you are trying to subtract it you
need to change the formula to this:

=IF(D2<0,B2-C2+D2,B2-C2)


"Lollycat" wrote:

I tried that but it doesn't give me the answer I am looking for. Using the
formula you suggested the total of the first row was 338 when it should have
been 143. In other words, I want column E to be 200 minus 12 minus 45 (if 45
is less than 0). If the number in that column (column D) is a positivbe
number, it should be ignored in the total. The total of the second row was
0. What do do?


"Melinda" wrote:

Hi,
Here's what I would do (there's probably a more elegant way). In Column E:
=if(D2<0,B2-C2-D2,B2-C2)

Hope that helps.
Melinda

"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!