Why won't this formula work?

0

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

Answer
Discuss

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)
Discuss

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
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login