negetive numbers in a formula
 

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

negetive numbers in a formula
 

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

On Apr 29, 5:00*pm, Andy wrote:
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

negetive numbers in a formula
 

=IF(A1+B2+C3+D4<0,0,A1+B2+C3+D4)
--
Gary''s Student - gsnu200781