Sum is positive value or "0" value. Negative value equals "0"

I have a doc where I would like to use a formula that would subtract an
amount from an amount in another cell, but when it reached the value of 0 it
would stop. [i.e. 10-6=4, 10-12=0]. I have not found a way to do it, used
"IF" I don't want a word answer.
--
Thank you for your help.

Here's one way.
=MAX(B1-A1,0)

HTH
--
Dana DeLouis
Win XP & Office 2003


"MorTTime" <morttime@discussions.microsoft.com> wrote in message
news:964838A7-D6F4-4579-853D-12BEB93E85E1@microsoft.com...
>I have a doc where I would like to use a formula that would subtract an
> amount from an amount in another cell, but when it reached the value of 0
> it
> would stop. [i.e. 10-6=4, 10-12=0]. I have not found a way to do it, used
> "IF" I don't want a word answer.
> --
> Thank you for your help.