1. I have the same problem, where a negative number is nonsense and show
should as zero.

2. I think you meant 10,000 - 12,000 = (2,000)?

"jen" wrote:

Hope this is easy (for you). Haven't used excel in a long time and need to
create simple formula and can't figure it out.

Example: I want to show value as zero if addition comes out negative.

12000.00 -10000.00 = (2000.00) but I want the value to be zero not the
negative value.