Calculating Incentive bonus

[Gref]

I have a situation where I am using this formula to calculate a 12% incentive bonus. =IF(C4="NAME",SUM(I4+G4+J4)*0.12,"")
The problem is I do not want to add cell J4 unless it is a negative number. Presently I am manually changing the formula if J4 is a positive number to =IF(C4="NAME",SUM(I4+G4)*0.12,"")
Don't know if this needs to be some kind of nested if function. Any help would be greatly appreciated. Thanks.

 

[starl]

you can put the IF statement inside to handle just J4

=IF(C4="NAME",SUM(I4+G4+IF(J4<0,J4,0))*0.12,"")

 

[Dave Patton]

=if(c4="name",sum(i4+g4+min(j4,0))*0.12,"")

 

[Gref]

That works great. Thanks

 

[starl]

I like Dave's solution better
I didn't think of using MIN. Good idea