Here's one way.
=MAX(B1-A1,0)
HTH
--
Dana DeLouis
Win XP & Office 2003
"MorTTime" wrote in message
...
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.
|