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
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
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
D4 and D6 just cells with other values
- Sorry really new at this.
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- Thanks heaps.
- Thanks Ill try it and let you know.