Complete the "Down OK?" column.

1. Use nested IF functions in cell K5. Include an AND function as part of the criteria in the second IF function.
2. Return Yes if the "Down Payment" (cell F5) exceeds 10% of the "Loan Amount" (cell D5) or if the "Down Payment" exceeds 5% of the "Loan Amount" and the "PMT/Income" ratio (cell E5) is less than 40%.
3. Otherwise return No.
4. Copy your formula down to complete the "Down OK?" column.

and

"Approved?" column.

1. Use the three nested IF functions with an AND function as part of the criteria for the first IF function in cell M5.
2. Return Yes if "PMT OK?" (cell I5), "Score OK?" (cell J5), and "Down OK?" (cell K5) are all Yes.
3. Return "Loan too large" (without the quotes) if "PMT OK?" is No.
4. Return "Score too low" (without the quotes) if "Score OK?" is No.
5. Otherwise, return "Down too low" (without the quotes).
6. 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 "Approved?" column.

(can you please do both)