Formula to make numbers not go past 0

[sice]

Hi guys,

I was wondering if there is a formula that makes it so my numbers will stop at 0. I am not sure what the formula would be, so any help would be greatly appreciated. Thank you.

 

[RSXchin]

What do you mean?

 

[number kruncher]

A sample of data is a must for this one!

 

[Jonmo1]

Not sure I understand the problem, can you explain a little further?

Perhpas the MIN function would help?

=MIN(0,A1)

If the number in A1 is > 0, then it still returns 0
If the number in A1 is < = 0, then it returns the number in A1

 

[sice]

5+(-8)=-3 I would like it to stop at 0 and not go negative. If it is 5+8=13 then I would like it to still do the calculation. I hope this makes sense.

 

[Jonmo1]

Then use the MAX function...

=MAX(0,5+(-8))

 

[sice]

This worked perfectly. Thank you!