SOLVED

how to make a formula apply only when the number is negative

%3CLINGO-SUB%20id%3D%22lingo-sub-3207069%22%20slang%3D%22en-US%22%3Ehow%20to%20make%20a%20formula%20apply%20only%20when%20the%20number%20is%20negative%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3207069%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20add%20a%20number%20from%20cells%20when%20negative%2C%20to%20another%20cell%20already%20populated%20with%20a%20positive%20number%5CThis%20is%20for%20monthly%20target%20bonus.%20If%20one%20month%20is%20negative%20in%20column%20of%20target%20achieved%2C%20then%20I%20need%20it%20to%20add%20that%20number%20to%20the%20next%20months%20column%20of%20target%20required.%20Hope%20this%20makes%20sense.%3C%2FP%3E%3CP%3EThanks%20Bill%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3207069%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-3207109%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20make%20a%20formula%20apply%20only%20when%20the%20number%20is%20negative%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3207109%22%20slang%3D%22en-US%22%3EI'm%20not%20really%20sure%20what%20you're%20asking%20for%20as%20I%20can't%20see%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EHave%20you%20considered%20just%20using%20a%20if%20formula%20or%20adding%20a%20-ve.%20remember%20if%20you%20add%20say%20-%20-5%20you%20get%20%2B5%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3207116%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20make%20a%20formula%20apply%20only%20when%20the%20number%20is%20negative%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3207116%22%20slang%3D%22en-US%22%3E%3Dif(E12%26lt%3B0%2CD4-E12%2CD6)%3CBR%20%2F%3ED4%20and%20D6%20just%20cells%20with%20other%20values%3C%2FLINGO-BODY%3E
Occasional Contributor

I want to add a number from cells when negative, to another cell already populated with a positive number\This is for monthly target bonus. If one month is negative in column of target achieved, then I need it to add that number to the next months column of target required. Hope this makes sense.

Thanks Bill

8 Replies
I'm not really sure what you're asking for as I can't see it.

Have you considered just using a if formula or adding a -ve. remember if you add say - -5 you get +5
Thanks
Sorry very new to this
If Cell E12 is <0 then I want to ADD this number to a positive number already in D13
=if(E12<0,D4-E12,D6)
D4 and D6 just cells with other values
Thanks Ill try it and let you know.
Sorry really new at this.
Can you please explain formula in txt. Really appreciate it.
best response confirmed by Hans Vogelaar (MVP)
Solution
=if(E12<0,D4-E12,D4)

if Cell E12 is less than 0 then Cell D4 (cell with new month figure you want to add to)-E12 (minus negative figure in E12) otherwise D4
E12 = -6
D4 = 510 (value for new month you want to add to E12)
you would get 510 - -6 = 516

E12 = 6
you'd get 510

@billh55 

 

No worries. I hope it helped