For every loan over $50,000, it must be reviewed monthly, and for every loan over $15,000, it must be reviewed semi-annually. Loans

under $15,000 are typically not reviewed. Create a function in cell H49 that will say "MTHLY" if the loan needs to be reviewed monthly,

"SEMI" if the loan needs to be reviewed semi-annually, or "N/A" if it does not need to be reviewed. Copy this formula down for all rows.