software

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 youyou need to quot;wrapquot; your formula like this

=MAX(formula,0)

quot;g m wquot; wrote:

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