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