negetive numbers in a formula

A

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
 
P

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
 
Top