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...
- =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
Sorry really new at this.
Can you please explain formula in txt. Really appreciate it.
Can you please explain formula in txt. Really appreciate it.
=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
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.