Forum Discussion
If calculation returns a negative number, then it needs to be a 0; 2nd part is to show Max number
1. For row 45, I have calculation for 30% of row 42 ex. =F42*.30. If the result is a negative number, then I would like it show a 0 instead of the negative number. 2. Next, for row 48, the ...
you can wrap the formula in an if statement like: IF(F42.3<0,0,F42.3). which says if the result is less than 0 then 0 if not then just use the result