Excel: negative result equals zero Solved

Question

Hello, My problem is relatively simple, I would like the result of a subtraction to appear as zero when it is negative (for example 0-2=-2). Thank you for your help. jelumic

Mike-31 · Accepted Answer

Hello,  Look at this formula that references cells A1 =0 and B1 =2  =IF(A1-B1

Tiburn · Answer

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 :)

Mike-31 · Answer

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.

Tiburn · Answer

Ok, thanks Mike.

Excel: negative result equals zero

4 réponses

Samsung j5 unable to answer

Scam of the suvedene highway

Minecraft restore the cursor and the bar.

My ps3 keeps shutting down on its own...

Samsung series 4 led tv logo display...

How to enable bluetooth on a samsung tv?

Ctrl key issue

[metin2] sura ...

Freebox tv locked step 2 or network

Error 46 (brother dcp-150c) cleaning impossible