excel spreadsheet

[Guest]

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.

 

[fredg]

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.

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using. I would suggest you include your Windows and Office version
number in the message.

 

[Douglas J. Steele]

Sorry, this newsgroup is for questions about queries in Access, the database
product that's part of Office Professional.

You'd be best off reposting your question to a newsgroup related to Excel.