Thread: Stop a SUM formula from returning negative numbers

Hi, I have a simple SUM function in place to determine the number of days it takes to complete something (payment of expenses). The problem is that if the expense hasn’t yet been paid, the value returned is a large negative number. Is there a way I can change the formula so that rather than displaying negative numbers, it simply displays a zero? Or better yet, rather than displaying negative numbers is populates the cell with something like: In Process?

Thanks!

Try either:

=MAX(0,your formula)

or

=If(your formula<0,"In Process",your formula)


replace your formula with your actual formula (without initial = sign)

Thanks! I used the "In Process" suggestion and it worked wonderfully!