Forum Discussion
Solved
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
- =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
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
