Badm-134 Business Organization & Management

Loan repayment is calculated as the excess of cash available over desired ending balance, but never more than the amount of the loan. Therefore, need a nested if statement in which first test whether tentative cash balance exceeds desired balance and then if it does, compares excess cash available to outstanding loan balance: =IF(D26>50000,IF(D26-50000>D27,D27,D26-50000),0) ................
................