 SOLVED

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

Occasional Contributor

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

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

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

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

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

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

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

=if(E12<0,D4-E12,D6)
D4 and D6 just cells with other values

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

Thanks Ill try it and let you know.

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

Sorry really new at this.
Can you please explain formula in txt. Really appreciate it.
best response confirmed by Hans Vogelaar (MVP)
Solution

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

=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

Thanks heaps.

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

No worries. I hope it helped