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