Creating a function that makes a negative number a zero

[Tina]

I am trying to create a function that will subtract, but if the answer is
less than zero, will put a zero in the cell. I don't know how to do this.
Can you help me?

 

[hodeware]

Try this


=IF(A1-A2<0,0,A1-A2)

with A1 & A2 being any cells

 

[Guest]

Hi
You could try wrapping your formula in a MAX function:
=MAX(yourfunction,0)