1.4

Complete the "Discount?" column.

1. Use the IF function with an OR function as part of the criteria argument in cellL5.
2. Return Yes if either "Savings Account?" (cellG5) or "AutoPay?" (cellH5) are listed as YES.
3. Otherwise, return "Suggest AutoPay" (without the quotes).
4. Copy your function down to complete the "Discount?" column.

1.5

Complete the "Approved?" column.

1. Use the three nested IF functions with an AND function as part of the criteria for the first IF function in cellM5.
2. Return Yes if "PMT OK?" (cellI5), "Score OK?" (cellJ5), and "Down OK?" (cellK5) 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.

Autore 2001 - Home Page Layout Food Duta View Help . 03 TANTE ES 5. India St- A Sorother X and MyEducator Tasks (14) Complete the Discount column a. Use the Function with an o function as part of the criteria argument in cell LS) b. Return Yesieither Savings Account (cel 65) "AutoPaycell HS) are listed as YES c. Otherwise, retom "Surgest AutoPay without the quotes d. Copy your function down to complete the Discount column Discount O z PMT/income Down Payment Savings Account Auto PMTORY 325 $47.000 YES NO Yes E $25.000 NO NO NO 7 37 $49000 NO YES B 47 $17.000 YES VES No 545.000 YES NO Yes 10 35 514000 190 YES You 11 36 330.000 VES NO Yes IN 538.000 NO YES Yes 11 415 351.000 YES YES Yes 27 $14,000 YES NO Yes $45.000 NO NO Yes 304 1.000 YES YES Yes 32 304 543 000 NO NO 18 39 152 009 TE YES Yes 10 143.000 VS NO 20 30 1310 YS NO Yes 21 1650D NO NO Yes 121.000 NO NO NO 120.000 YES Yes 2 42 $13.000 YES YES 38 341.000 NO NO Yes 351 $27.000 NO NO Ves 389 138.000 TES NO Yes 25 37.000 YES Yes 20 144.000 YES NO Yes SOCO NO YES Yes 25 355.000 YES YES YE 30 525.000 YES YES Yes 38 14,000 YES YES Ye 529.000 YES NO NO DEEEEEEEEEE Score OK? Down OK? Dict Approved? Yes Ye and Yes No Soest Yes Y Yos No Yes You Yes ves No No Yes Yes Yes Yes Yes Yes No Yes NO Yes No Sot Auto NO Yes Yes Yes Yes Suggest Auto Yes Yes Yes Na Yes Yes Na Yes YE Ver Yes Suggest Actory Na No Sagot AUTOPY Ye Yos Yes Na Yes Yes Yes 5229 Auto Na Yes Soest Auto Yes Ye Na You Yes Yes Yin Yes Yel Yes Yes Yes Yel Yos No Yes Yes No Yes 15 Complete the "Approved column a. Use the twee nested IF functions with an AND function as part of the criteria for the first IF function in cell IMS b. Return Yes if "PMTOK (cell) Score OK?" cell Sh, and "Down OK KS) are All Yes Return loan too large" (without the quotes PMT OK?" isNo d. Return "Score too low (without the quotes in Score OKT is No e. Otherwise, return Down too low (without the quotes f. Notice that if PMTOKT IS 'No' only Loan to large is displayed, regardless of the status of Score OKT" and "Down OK See the reading for details on why. Copy your function down to complete the "Approved column 30 0 2 2021/2/16 IM SEED A 72 d! E M oved? f(lf and MyEducator Tasks u. copy your OK?" column. TUTU OPICLADOV 22 1.4 Complete the "Discount?" column. a. Use the IF function with an OR function as part of the criteria argument in cell L5). b. Return Yes if either "Savings Account?" (cell G5) or "AutoPay?" (cell H5)) are listed as YES. c. Otherwiser, return "Suggest AutoPay" (without the quotes). d. Copy your function down to complete the "Discount?" column. (27) 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 bill Yos "Discount?" column. ay Pay Pay Pay E27 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 15)), 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 Pay Pay E (27)