IF formula

L

lance559

I am trying to create a formula. I believe it may be an IF formula. If
summed numbers in a row are negative, I would like those numbers to be
auotmatically summed as 0.

For exmaple, if I have a row of ten numbers and three of the summed numbers
are negative, what formula could I use so the positive numbers remain, but
the negative numbers will be 0? Thanks.
 
L

lance559

I am not doing something right.

For example,

H70 (50) (this is sum from another cell)
H71 100

H72 50 (sum of H70 & H71)

How do I make row 70 a 0 so the sum will automatically calculate in row H72
as 100.
 
Top