Return "0" if zero, return value if not zero

[RandyD123]

Hoping this one is easy. In my "N" column it does the math as seen in the formula bar. But what I want is if my "M" column is "0" then my "N" column should be "0" and not show negative numbers. Also when my "M" column gets a value (manual entry) the "N" column will still do the math.

thank you in advance

 

[Fluff]

How about

=if(m15=0,0,m15-j15)

 

[Cubist]

Try:

=MAX(M15-J15,0)

 

[Arts]

Is this what you're after

=IF(M15=0,0,M15-J15)

 

[Alex Blakenburg]

Try:

=MAX(M15-J15,0)

Row 13 seems to indicate that negative numbers are allowed as long as M is not 0.

 

[RandyD123]

Row 13 seems to indicate that negative numbers are allowed as long as M is not 0.

Yes that is true and when I use your formula Row 13 turns to "0". I need that negative if the math results in a negative number.

 

[RandyD123]

Is this what you're after

=IF(M15=0,0,M15-J15)

Yes, this seems to work and it keeps my negative numbers if the math results in a negative number!

 

[RandyD123]

Is this what you're after

=IF(M15=0,0,M15-J15)

Yes, this seems to work and it keeps my negative numbers if the math results in a negative number!

 

[RandyD123]

Thank you all who helped.

How about

=if(m15=0,0,m15-j15)

Yes that worked. Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.