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!