Excel Question:

Use a combination of ISNUMBER, if$/$and $($If $+$ AND$)$ statements to return what will be paid by the borrower or $$Paid Off$.$

Logic: If the PRIOR principal balance is a number AND it is also greater than the regular loan payment, then pull the regular payment $($say Cell D$4).$ If$,$ however, the PRIOR principal balance is a number AND greater than $0,$ then pull the PRIOR principal balance PLUS this month$$s interest. Otherwise, the cell should return $$Paid Off$.$ This formula requires two conditions that require the use of ISNUMBER.