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.
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.
Last edited: