how to -Negative number transfer in other cell

[Ahmed.Rama3]

Hello.

I'm accountant and I'm working on a table, i know how to make all negative numbers display as 0(zero) with IF function.
But now I'm facing a different problem, I'm using a simple function like A2-B2-C1=D2, and i wanna know if i can make (only when negative number) display in other cell (from example below in C2) and make it positive, but when positive display it where it should be (from example in D2).

Hope you understand my problem, and thank you for helping, this would save me a lot of time!

[martindwilson]

not really as you cant have a function referring to the cell its in
but say your + - or 0 values are in b2
in c2 =-MIN(B2,0) which would display as +ve if <0 , and 0 if>=0
and in d2 =MAX(0,B2) which would display 0 if <=0 and + if>0