Well, I suspect that part of the problem is that you are subtracting a
negative number (which is the same as adding). The other part of the problem
is that I didn't understand your row set up.
Try this instead:
=(D1<0,12-C1+D1,B1-C1)
Now, in the second row, all of the 1's will need to be 2's. If you drag
down your formula, this will update automatically.


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