Home

Help with Formula!!

%3CLINGO-SUB%20id%3D%22lingo-sub-1058918%22%20slang%3D%22en-US%22%3EHelp%20with%20Formula!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1058918%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20away%20to%20use%20a%20formula%20to%20put%20the%20sum%20of%20two%20cells%20in%20one%20cell%20if%20it's%20positive%20and%20a%20in%20different%20cell%20if%20it's%20negative%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExplanation%2Fexample%3A%3CBR%20%2F%3ESo%20If%20A1%2BB1%20%3D%20%26lt%3B0%20it%20goes%20to%20C1%20but%20if%20it%20%3D%26gt%3B%200%20it%20goes%20to%20D1%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20looked%20through%20formulas%20an%20can't%20figure%20out%20but%20I%20don't%20have%20much%20experience%20with%20excel%20formulas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1058918%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1058941%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Formula!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1058941%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F484465%22%20target%3D%22_blank%22%3E%40MelissaE01825%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you're%20looking%20for%3F%3C%2FP%3E%3CP%3EIn%20cell%20C1%3A%3C%2FP%3E%3CP%3EIf(Sum(A1%2CB1)%26lt%3B%3D0%2CSum(A1%2CB1)%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20cell%20D1%3A%3C%2FP%3E%3CP%3EIf(Sum(A1%2CB1)%26gt%3B%3D0%2CSum(A1%2CB1)%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1058994%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Formula!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1058994%22%20slang%3D%22en-US%22%3EFrom%20your%20statements%2C%20it%20appears%20that%20if%20the%20SUM%20is%200%2C%20then%200%20will%20be%20returned%20in%20both%20C1%20and%20D1.%20Thus%2C%20the%20formula%20in%20C1%20would%20be%3A%3CBR%20%2F%3E%3DSUM(%24A1%2C%24B1)*%3CBR%20%2F%3E(SUM(%24A1%2C%24B1)%26lt%3B0)%3CBR%20%2F%3EConversely%2C%20the%20formula%20in%20D1%20would%20be%3A%3CBR%20%2F%3E%3DSUM(%24A1%2C%24B1)*%3CBR%20%2F%3E(SUM(%24A1%2C%24B1)%26gt%3B0)%3C%2FLINGO-BODY%3E
Highlighted
MelissaE01825
Occasional Visitor

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

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

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