Formula Help

[Paul_H65]

I can not figure this out, I think I figured out to "3", but can not figure out other to make it say the other 2 (4 & 5).

Spreadsheet

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).

[#2]

@Paul_H65 

Perhaps

=IF(K5="No", "Down too low", IF(J5="No", "Score too low", IF(I5="No", "Loan too large", "Yes")))

[#3]

I got it to work! Nesting the other two IF functions after the AND function was a super tricky and took a lot of trial and error to figure out. This answer was accepted as "correct" by the grading program for the assignment.

=IF(AND(I5="Yes",J5="Yes",K5="Yes"),"Yes",IF(I5="No","Loan too large",IF(J5="No","Score too low","Down too low")))