Hello,
I am designing a bond amortization table. I am trying to constrain the principal payments, lets call them A1:A8 to be either $5,000 difference from the previous payment, or $0 difference from the previous payment. I cannot find the correct syntax to set a constraint that does the following. Assuming B2:B8 are the difference values.
Constraint:
B1:B8 = ($5,000 or 0)
Im guessing this is probably a simple error and I am overlooking an easy formula. But I would appreciate any help I could get.
Thanks
Bookmarks