Welcome Guest.

4Answers

EXCEL multiple text decision

Asked by: Melissa 242 views IT January 4, 2019

After all the judgments in E20 to N20 are passed, the total item is judged to be qualified; when the NG item appears? ? When the item is selected, the total judgment is blank

When the remark item has text, the conclusion item is judged to be qualified

4 Answers

  1. +1Votes  

    =IF(OR(AND(E20="OK",G20="OK",I20="OK",K20="OK",M20="OK"),B11<> ""),"Qualified","")

    Scott- January 5, 2019 |

  2. +1Votes  

    “Can be solved with the usual simple IF function.”

    David Jackson- January 5, 2019 |

  3. +6Votes  

    =IF (COUNTIF(E20:N20,"OK")=5,"Qualified","")

    Douglas Young- January 5, 2019 |

  4. +5Votes  

    =VLOOKUP("C3"&"EEE",IF({ 1,0}, $A$1:$A$7&$B$1:$B$7,$C$1:$C$7),2,0) ctrl+shift+Enter and press "C3"&"EEE" This section can reference cells.

    Elizabeth Williams- January 5, 2019 |