=SUM(B3:H3)-40,if(i4<"0","0")

# Why won't this formula work?

0

## Answers

0

Selected Answer

It won't work because you have a comma between **40** and **if**. Are you trying to subtract the value returned by the IF statement? What are you trying to do in the formula?

### Update

I think this is is the formula that you want:

`=IF(SUM(B3:H3)-40<0,0,SUM(B3:H3)-40)`

### Discussion

thanks for your response. I'm trying so that IF the return sum value in i4 is less than zero, then zero. Not a negative value.

Chuck (rep: 2) Jul 30, '16 at 10:12 pm

it didnt work becuase the IF statement should have been first in this formula. e.g. =IF(SUM(B3:H3)<0,"0",SUM(B3:H3))

Chuck (rep: 2) Jul 30, '16 at 11:28 pm