you need to "wrap" your formula like this

=MAX(formula,0)

"g m w" wrote:

i have written a spreadsheet that works out how quick i can pay my mortgage
off with extra payments and changes in the interest rate but towards the
bottom i get negative values which screws up a calculation for the total and
i want to know how do i stop the negative values so it will read a 0 instead
thank you