Do not want to display negative formula results

[plabi]

If the result of a formula is negative, how do I display it as a zero?

 

[Myrna Larson]

A couple of ways

=IF(yourformula<0,0,yourformula)

=MAX(yourformula,0)

 

[bigwheel]

IF(A1-B1<0,0,A1-B1)