How to stop a result going below zero

Hi,

If cell a1 has a value of 10, anc cell a2 a value of 20, and I subtract the 20 from 10, how can I return a result of zero instead of minus 10?

Many Thanks

Sue

Try this:

=MAX(0,A1-A2)

Hope this helps.

Pete

Thanks Pete,

That did the trick

Sue

@ suma

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.