Question: (1.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


(1.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 M5. b. Return Yes if "PMT OK?" (cell (15)), "Score OK?" (cell J5), and "Down OK?" (cell K5) 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 "Approved?" column. (1.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 M5. b. Return Yes if "PMT OK?" (cell (15)), "Score OK?" (cell J5), and "Down OK?" (cell K5) 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 "Approved?" column
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
