Hi...need a formula that sets cell equal to zero if sum of cell range is negative , but if sum of cell range is 0 or higher than the solution is the sum of cell range.

eg. solution would be in d3

a3 b3 c3

-17 22 -9

d3 if sum of a3 to c3 = less than zero/negative,0 or if sum a3 to c3 is zero or higher/positive, sum of a3:c3

total is -4 so cell should be 0

a4 b4 c4

12 -14 26

d4

total is 24 so cell should be 24

Thanks

## Bookmarks