Negative numbers to 0

[Pantryman]

Hi all,

I tried to search for this one but could not find anything that matched
this problem.

Is there a simple function to convert to 0 anything below 0?
I.e.,

-3 becomes 0

-5 becomes 0

3 remains 3.

Thanks a lot in advance!

 

[Dave R.]

A couple ways

=MAX(A1,0)

or

=IF(A1<0,0,A1)