Help with Formula!!

[MelissaE01825]

Is there away to use a formula to put the sum of two cells in one cell if it's positive and a in different cell if it's negative?

Explanation/example:
So If A1+B1 = <0 it goes to C1 but if it => 0 it goes to D1

I've looked through formulas an can't figure out but I don't have much experience with excel formulas.

Thanks

[#2]

Hello @MelissaE01825,

Is this what you're looking for?

In cell C1:

If(Sum(A1,B1)<=0,Sum(A1,B1),"")

In cell D1:

If(Sum(A1,B1)>=0,Sum(A1,B1),"")

[#3]

From your statements, it appears that if the SUM is 0, then 0 will be returned in both C1 and D1. Thus, the formula in C1 would be:
=SUM($A1,$B1)*
(SUM($A1,$B1)<0)
Conversely, the formula in D1 would be:
=SUM($A1,$B1)*
(SUM($A1,$B1)>0)