Excel: negative result equals zero

ok this formula works except that I have a problem, I would like the value '0' to be TRULY '0'

Let me explain, if the sum of my calculation is -4, this code displays 0 and that’s perfect, but I would like that after the first calculation, if I add +1 to my calculation, the sum should be 1 and not still 0 (Because for excel, even if it displays 0, for it the sum is still at -4.

I would like excel to forget that it is -4 and even if it is -124, it should believe that it is 0 and thus, if I add 1 to this sum, it should display 1 and not still 0.

Thank you :)

Hello,

Not so simple, if in A1 you have example 1 and in B1 5
the result is -4
if you add 1 in A1 so A1 is 2 minus B1 5 negative result -3 so still 0 and even in VBA the result will always be negative or then you add a calculation cell example C1

=IF(A1-B1<0,0,A1-B1)+C1

and there we can play with additional conditionals if needed
--
A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

Ok, thanks Mike.