Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1816705%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1816705%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can%20not%20figure%20this%20out%2C%20I%20think%20I%20figured%20out%20to%20%223%22%2C%20but%20can%20not%20figure%20out%20other%20to%20make%20it%20say%20the%20other%202%20(4%20%26amp%3B%205).%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229140i753FBD8C7A5C311C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excel.jpg%22%20alt%3D%22Spreadsheet%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESpreadsheet%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3COL%3E%3CLI%3EUse%20the%20three%20nested%20IF%20functions%20with%20an%20AND%20function%20as%20part%20of%20the%20criteria%20for%20the%20first%20IF%20function%20in%20cell%20M5.%3C%2FLI%3E%3CLI%3EReturn%20Yes%20if%20%22PMT%20OK%3F%22%20(cell%20I5)%2C%20%22Score%20OK%3F%22%20(cell%20J5)%2C%20and%20%22Down%20OK%3F%22%20(cell%20K5)%20are%20all%20Yes.%3C%2FLI%3E%3CLI%3EReturn%20%22Loan%20too%20large%22%20(without%20the%20quotes)%20if%20%22PMT%20OK%3F%22%20is%20No.%3C%2FLI%3E%3CLI%3EReturn%20%22Score%20too%20low%22%20(without%20the%20quotes)%20if%20%22Score%20OK%3F%22%20is%20No.%3C%2FLI%3E%3CLI%3EOtherwise%2C%20return%20%22Down%20too%20low%22%20(without%20the%20quotes).%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1816705%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1816724%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1816724%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F845341%22%20target%3D%22_blank%22%3E%40Paul_H65%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(K5%3D%22No%22%2C%20%22Down%20too%20low%22%2C%20IF(J5%3D%22No%22%2C%20%22Score%20too%20low%22%2C%20IF(I5%3D%22No%22%2C%20%22Loan%20too%20large%22%2C%20%22Yes%22)))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

 

SpreadsheetSpreadsheet

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

@Paul_H65 

Perhaps

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