JesseEdsell-Vet

12 months agoQrew Member

# Formula question

Hi all,

I am working on an app that calculates loans including deferred loans. Right now, if someone has not paid for a long time and the payment is less than the interest owed, the principle comes back as a negative number rather than a zero. (Current formula is payment amount-interest=principle). I need to make the formula show that there should never be a negative number for principle - just a zero if the amount paid is less than total interest owed. How can I limit the results to not get a negative number?

------------------------------

Jesse Edsell-Vetter

------------------------------