Thread: negative values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
g m w
 
Posts: n/a
Default negative values

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