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...
Forum Discussion
Lots of options. I would recommend (1) an if statement or (2) a 'max' function
IF Statement
if( ([Amount] - [Interest]) < 0, 0, [Amount]-[Interest])
if the value of amount - interest is less than 0, return 0 else return amount - interest
Max function
Max([Amount]-[Interest],0)
This will return 0 in the event that amount - interest is a (neg) value
------------------------------
Chayce Duncan
------------------------------
Formula:
[Amount]-[Interest]
Max([Amount]-[Interest],0)
But it says that there are extra characters beyond the end of the formula. What am I missing?
------------------------------
Jesse Edsell-Vetter
------------------------------
You should only need the second part - it looks like you left the original formula in there and QB can't decipher the two calculations without some adjustment. You should just need:
Max([Amount]-[Interest],0)
Delete the first row with amount - interest
------------------------------
Chayce Duncan
------------------------------