Help with bringing 0 as a result if less than 0

[Wilcock1]

Please would you be able to help with adding into a current formula if the result is less than 0 then show 0.

The current formula is =(N2-3)/SUMIF('Sum of Digit'!A:B,N2,'Sum of Digit'!B:B)*M2. I believe that it is something like =if(<0,0) but am not sure how to add it into the formula. Any help would be appreciated.

 

[Joe4]

Just wrap it in a MAX function, i.e.

=MAX((N2-3)/SUMIF('Sum of Digit'!A:B,N2,'Sum of Digit'!B:B)*M2,0)

 

[Wilcock1]

Thats great Joe4 thanks so much for your help!!

 

[Joe4]

You are welcome.