New at this. Are both formulas in the same cell? And if they are, are they
in every cell say Jan - Feb, etc.
Jan Feb Mar
payment from closings 3000 4000 2500
gross profit 0 2000 4500
beg loan balance 5000 2000 0
end loan balance 2000 -2000(want this to be "0")
(want the 2000 to go into
gross profit Feb cell)

--
Steve Pont


"Harlan Grove" wrote:

"Steve" wrote...
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.
....

X is the balance, Y is the payment, use

=MAX(0,X-Y)

for the balance after applying the payment and

=MAX(0,Y-X)

for the credit balance after applying the payment. Prior to the last
payment, the former will be positive and the latter zero. Just after the
last payment, the former will be zero and the latter either zero or
positive.