negetive numbers in a formula

[Andy]

I am trying to put together a formula that if the sum of 4 cells is less than
zero it the cell just shows 0

 

[Pete_UK]

Something like this:

=MAX(A1+B2+C3+D4,0)

if you want the sum to show if greater than zero, or this if not:

=IF(A1+B2+C3+D4<0,0,"")

Hope this helps.

Pete

 

[Gary''s Student]

=IF(A1+B2+C3+D4<0,0,A1+B2+C3+D4)