Q88. Convert the following statement to “pseudo-Excel” formulas (follow the example to see what we mean by that).
Example. "If it is Tuesday, this must be Belgium, otherwise it is France" would become something like

if(day="Tuesday","Belgium","France")

If the calculated payment (CALC_PMT) is less than the alternative monthly minimum payment (ALT_MIN_PMT) then the payment is the alternative monthly payment otherwise it is the calculated payment.
f(x)=if (CALC_PMT<ALT_MIN_PMT,ALT_MIN_PMT,CALC_PMT)

Q89. If the current balance (BAL) is less than the calculated payment then pay the balance off, otherwise, pay the calculated payment.

f(x)=if (BAL<CALC_PMT,BAL,CALC_PMT)

Q90. If the calculated payment is less than the alternative minimum monthly payment then pay the alternative monthly minimum unless it is more than the remaining balance in which case just pay the balance off. Otherwise pay the calculated payment.
f(x)=if(CALC_PMT<ALT_MIN_PMT, if (ALT_MIN_PMT>BAL,BAL),CALC_PMT,ALT_MIN_BAL)

page revision: 0, last edited: 23 Oct 2012 20:20