=SUM(B3:H3)-40,if(i4<"0","0")
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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