$2\mathrm{.}3$ Complete the "Down.

K$?"$ column.

a$.$ Use nested IF functions in cell K$5).$ Include an AND function as part of the criteria in the second IF function.

b$.$ Return Yes if the "Down Payment" $($cell $($F$5)$ exceeds $10\%$ of the "Loan Amount" $($cell $($D$5)$ or if the "Down Payment" exceeds $5\%$ of the "Loan Amount" and the $"$PMT$/$Income$"$ ratio $($cell E$5)$ is less than $40\%.$

c$.$ Otherwise return No$.$

d$.$ Copy your formula down to complete the "Down OK$?"$ column.