Want a cell to enter "0" for values = to 0 or <0, and then take the positive
difference in that same cell and put it into another cell.

ie: In the worksheet I have a descending loan balance that will be
progressively reduced to zero from positive cash flow until the the loan is
ultimately paid of. In the last month of paying off the loan, the amount
owed will be less than the positive cash flow for the month leaving a credit
balance instead of reducing the balance to "0'. if I can get the results in
the cell to show '0" I would then want the cash flow over and above the final
loan payment to go into another cell that would start accumulating the profit
or positive cash flow for the remainder of the project.
--
Steve Pont

--
Steve Pont