Number less than zero is shown as a zero

Mitch@Enmach

Hello again community,

I am hoping someone can help me understand the right way to write this formula for what I am trying to achieve.

I am wanting to subtract one cell from another which in some cases provides a negative number. I would like the formula to pick up on this negative number and output a 0 in place of the negative number.

This is the formula I have so far that does not work.

=SUM([Column4]20 - [Column4]19) = IF([Column3]20 = <0, "0", "")

Many thanks in advance.

sean59916

Hi Mitch - 

If you are placing you formula in [Column3]20, use the following:

=IF(SUM([Column4]20 - [Column4]19) < 0, 0, SUM([Column4]20 - [Column4]19))

Regards, 

Sean

 

Mitch@Enmach

Thanks Sean, love your work!

Makes sense. 

 

sean59916

You're welcome