$2\mathrm{.}5$ Complete the

"Approved?" column.

a$.$ Use the three nested IF functions with an AND function as part of the criteria for the first IF function in cell M$5.$

b$.$ Return Yes if $"$PMT OK$?"($cell $(15),$ "Score OK$?"($cell J$5),$ and "Down OK$?"($cell K$5)$ are all Yes.

c$.$ Return "Loan too large" $($without the quotes$)$ if $"$PMT OK$?"$ is No$.$

d$.$ Return "Score too low" $($without the quotes$)$ if "Score OK$?"$ is No$.$

e$.$ Otherwise, return "Down too low" $($without the quotes$).$

f$.$ Notice that if $"$PMT OK$?"$ is $"$No$",$ only "Loan too large" is displayed, regardless of the status of "Score OK$?"$ and "Down OK$?"$ See the reading for details on why. Copy your function down to complete the "Annrnvad?" collumn