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.
Is this what you're looking for?
In cell C1:
In cell D1: