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). Use the three nested IF functions with an AND function as part of ...
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")))
=IF(AND(I5="Yes",J5="Yes",K5="Yes"),"Yes",IF(I5="No","Loan too large",IF(J5="No","Score too low","Down too low")))