 • 509K Members
• 9,112 Online
• 606K Conversations

Highlighted

# Help with Formula!!

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 Replies

# Re: Help with Formula!!

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),"")

# Re: Help with Formula!!

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)
Related Conversations
Need help with concatenate formula
Dave Cunningham in Excel on
2 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies